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

> Disabling redo logging effectively disables incremental checkpointing.

In my experience, checkpointing still occurs during log switches, thus you should create huge redo logs (temporarily) and set log_checkpoint_interval & timeout accordingly (version 8.1.7).

I was doing an Apps 10.7->11i migration (with no dedicated disks to redologs) and it helped a lot. Since I had run several test runs without a problem before, I assumed that I won't have any problems during production one either. 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. Received on Thu May 29 2003 - 10:03:24 CDT