Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: redolog buffer

Re: redolog buffer

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 12 Apr 2005 09:02:06 -0700
Message-ID: <1113321500.667588@yasure>


nitin_kaul_at_rediffmail.com wrote:

> hi
> i work on 9.2.0.1.0 win 2k.
>
> I have 3 redolog groups each of 25mb.
>
> i have noticed that value of
> redo buffer allocation retries, redo log space wait time has been
> increasing.
>
> Also the number of archive files generated is increasing.
>
> so do i have to increase the size of redolog and what is the impact of
> redo buffer allocation retries, redo log space wait time on the
> database.
>
> thanks

Redo log should be sized based on a balancing act where fewer log switches improve performance but increase the risk of data loss. The first thing I would suggest you do is apply four years worth of patches and get yourself to 9.2.0.4 or 9.2.0.6. Then, if there is a problem, diagnose its root cause.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Apr 12 2005 - 11:02:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US