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

From: Richard Foote <richard.foote_at_bigpond.com>
Date: 29 May 2003 16:40:40 -0700
Message-ID: <69f6c1c8.0305291540.211f3bb7@posting.google.com>

"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3ed62044$1_1_at_news.estpak.ee>...
> > 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).
>

Hi Tanel,

Can you explain to me how you get a log switch when you disable redo logging and how huge redo logs help when they're not being written to ???

Cheers ;)

Richard Received on Thu May 29 2003 - 18:40:40 CDT