Re: Redo logs - need a guru
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