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

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 30 May 2003 05:53:43 +1000
Message-ID: <3ed6737c$0$1028$afc38c87@news.optusnet.com.au>

"Tanel Poder" <tanel@@peldik.com> wrote in message news:3ed62044

[snip]
> And in case of any occurrence of Murphy's Laws, I used some of
> the saved time gotten from _disable_logging to make additional backups
> during the upgrade process.
>
> Tanel.

I think this is the real point! At the end of the day, you can never win with Oracle. What you gain on the one hand (by switching off redo writing) you lose on the other (by having -if you've got any sense!- to do extra backups... or, if the worst comes to the worst, having to restore a database from backup and repeat the entire bulk job).

I've used _disable_logging to speed up a regular weekend bulk load, but only because a closed whole database backup was taken on the Friday night anyway.

Like everything else, it's there to be used when occasion demands it, but never expect it to be "free".

Regards
HJR Received on Thu May 29 2003 - 14:53:43 CDT