Re: Optimal size for Redo Logs?

If logs are too small then Oracle checkpoint frequency will be high, which can affect DBWR and checkpoint behavior. On the other hand if logs are very large it could take a long time to recover in the case of crash.

We have to trade those two things off. It is not possible to provide a specific size recommendation for redo log files, but redo log files in the range of a hundred megabytes to a few gigabytes are considered reasonable. Size your online redo log files according to the amount of redo your system generates. A rough guide is to switch logs at most once every twenty minutes.

Statspack report will tell you redo/second on the top of that report.

HTH,
http://www.WebYourCompany.com

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F95413A.20B76026_at_remove_spam.peasland.com>...
> > > > Can anyone tell me the BIG picture?
> > >
> > >
> > > Sure. It is in the Oracle Concepts Manual.
> >
> > RTFM is all fine and dandy. However, the correctness of Oracle
> > manuals are getting trashed in other threads here.
>
> Sure, the Oracle docs do contain some inaccuracies. But I find that to
> be the exception, not the rule. And the OP was looking for the "BIG
> picture". How can you go wrong with the docs for that?
>
> Cheers,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Wed Oct 22 2003 - 13:14:15 CDT