Re: Transaction Gradually Slows to a crawl! (please help)

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 29 May 2003 00:02:50 +1000
Message-ID: <d23Ba.44935$1s1.605302@newsfeeds.bigpond.com>

"Ryan" <rgaffuri_at_cox.net> wrote in message news:g_UAa.115250$823.9886_at_news1.east.cox.net...
> how do you disable redo logs? you can generate no redo? really? i have a
> staging database also.
>

Hi Ryan,

By setting "_disable_logging"=true

Note though that this is a somewhat naughty, unsupported and risky thing to do .....

Note also that if your database is in archivelog mode, it's does rather nasty stuff to the statuses of the poor online redo logs and they'll probably need to be re-created when you set it back to false again. Therefore if you were to ever set the above, I would recommend placing the database in noarchivelog mode first.

Note also (last one I promise) that poor LGWR has an incredibly frustrating time of it in that it is still being pinged to perform it's writes but nothing happens. It's rather good fun watching your log write times start to go up and up and up ...

Not that I've ever done it of course ...;)

Cheers

Richard Received on Wed May 28 2003 - 09:02:50 CDT