Search results for query: *

I have an Oracle database sitting on a Windows 2000 server. When the the online-redo logs are written to the resources oracle uses goes through the roof and the server grinds to a halt. I presume the LGWR process is not performing efficently but I don't know why. I re-sized the on-line redo...

I need to undo a delete that was executed on a table that has field with a datatype CLOB. When I use logminer to retrieve the "undo" transaction it, logminer tells me that CLOBS are not supported. The insert statement looks like this: insert into article (title,teaser,body,) values ('Latest...

does anyone know of a way to retrieve a pages size in bytes using javascript.

I have an Oracle 8i database running on Windows NT. Is there a formula I could use to work out the optimumn size of the online redo redo logs.

I'm applying archive redo logs to a standby database periodically. Sometimes the logs are corrupted and throw an error when they get applied. Is there a way of catching an oracle error and then executing some code (to grap the logs from the primary database again)? If any of you have any...

We have a web site that contains an application that allows users to create microsites. Every time a user creates a microsite a different host header name is added to the website. Potentially a single website could have hundreds of host header names. Can any of you see a problem with this?

I've set up a site and set the default document to index.htm. When I type in the url minus index.htm I get a HTTP - 404 error. In order to see the site I need to add index.htm i.e. www.websitename.com/index.htm. I've enabled the default document and cleared IIS's cache but it still won't work...

We have a standby databse that graps archive redo logs from the live server and applies them. The problem is sometimes that logs get corrupted in transfer. Does any of you know of a way to check whether a log has been corrupted and then request the archive redo log again.

Does anyone know if there is a way of compressing data files.

Does anyone know hou do delete all tables belonging to a user. I tried the following but it doesn't work: delete from username.*

Does anyone no what this file is used for: ora817/network/log/nmi.log Its grown to about 1.5GB and I want to get rid of it or at leaset limit its size. Can I do this?

We have a standby database that pulls archive logs from the primary and applies them to the standby. When these logs arrive at the standby they are often corrupted. I know I'm being lazy here, but does anyone have a script that will check whether the archive redo logs are OK.

I am running the following query. select a.spkeywords,b.eventname from eventlist a, event b where b.spid in a.list "list" is a field containing a list of event ids. I want to return all events that appear in this list. The problem is my list is delimited by a comma but oracle needs...

Does any one of you know what process I have to follow to take a standby database out of read only mode and make it the primary database.

I'm have a standby database running Oracle 8.1.7. When I run a large query or do any sorting I get the following error message: ORA-01647: tablespace 'TEMP' is read-only, cannot allocate space in it This is because the standby database is in read only mode and queries running on a read only...

insert into tablename(name,address) values('fred','14 Evergree Terrace') I was running the above query and kept getting the error "ORA-00928:missing select keyword" when inserting a row in a table, so I changed the insert statement to the following: insert into tablename...

I'm trying to build a search engine which isn't case sensitive. Does any of you know how I can do non-case sensitive searching in oracle.

My database is operating in archive log mode but for some reason it has stopped archiving the online redo logs. I think it is trying to do so but for some reason can't. Does any of you know whether I can check if Oracle is attempting to archive the logs? Also does the sequence number of the...

I'm running oracle 8.1.7 on Windows 2000. I need to find out what what size the SGA is. Any ideas ???