Re: Sizing Redo log files

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 25 Jun 2012 18:32:35 -0700
Message-ID: <CAORjz=P9n_R=KVjPx+f0gZSKWZE-JbY58mKN8bW1xxMAQDbmEQ_at_mail.gmail.com>



On Wed, Jun 20, 2012 at 10:48 PM, Prasad Reddy Subbella < Prasad_Subbella_at_infosys.com> wrote:
> Hi All,
> Please share/guide me the best practices to be used for sizing redo log
> files.
>
>
> Here's one:

Make sure that the time required to cycle through all (N-1) redo files is less than the time it takes to have the archivelogs created for (N-1) redo logs.

This should ensure that the archiver will not bump into the redo.

(please correct math if wrong, I am tired)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 25 2012 - 20:32:35 CDT

Original text of this message