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...

forgot ot mention: the database is sitting on a Windows 2000 server.

I'm using an Oracle 8.1.7.0.0 database. There must be some way of retrieving CLOB data from an archive_redo_log, otherwise standby databases wouldn't work with CLOB data, which I find hard to believe.

Thanks for getting back to me. I do an export of the database every night, unfortunetly this transaction happened prior to the last export so the export contains the bad transaction. As far as you know is it impossible to retrieve clob data from the archive logs. Regards Gerard

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.

ok thanks everyone!

thanks for all your responses. Mufasa, any ideas how I can check how frequent log switches are happening.

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?

Thanks for replying to my query. I've already done this, the problem is the default document still isn't being picked up. I've checked that the web user has rights to the file and made sure the file isn't set as hidden but still no joy.

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.*

Thanks jee! I searched around a couple of forums and got the same answer.

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?

Thanks for that suggestion. I'll give it a try.

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.