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:
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-lReceived on Mon Jun 25 2012 - 20:32:35 CDT