Re: Redo logs - need a guru

From: Frank Bommarito <75662.112_at_CompuServe.COM>
Date: 1996/07/25
Message-ID: <4t7o88$6iu$1_at_mhadg.production.compuserve.com>#1/1


A redo log should last at least 30 minutes. If you are filling up your REDO in less that 30 minutes - on average - then it is too small.
Step 1. Make redos bigger

Redo logs are very write intensive for spurts upto the size of the log_buffer parameter - and - if archiving is turned on - then this space where the redos are located has large read operations too. --
Step 2. Move Redos to their own disk - and - insure that it is setup for large writes - and - if archiving reads.

There are several init.ora parameters whick dictate how often a "checkpoint" occurs. Try to see that this is about 30 minutes as well. This lessens the latch backlog to the redos by letting them "stream".

Hope this helps - Email for any more info needed. Frank Received on Thu Jul 25 1996 - 00:00:00 CEST

Original text of this message