RE: Sizing Redo log files

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 26 Jun 2012 10:47:21 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1C72ABD451_at_JAXMSG01.crowley.com>

Or, if the sustained throughput to the arch destination is less than the sustained redo rate, make sure there are enough redo logs so that the lgwr never circles around to a current log.... because the rate is not a steady full steam ahead all the time rate.

(I'm over reaching here as devils advocate... :) ).

Anyway, good catch. I think I read it and understood what he was saying without visualizing the actual statements in my head, because I instinctively knew that what you said 'kind of had' to be the case and it simply translated that way.

Details, details.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Tuesday, June 26, 2012 9:49 AM
To: jkstill_at_gmail.com
Cc: Prasad_Subbella_at_infosys.com; Oracle-L_at_freelists.org Subject: Re: Sizing Redo log files

Jared
I'm pretty sure you have that the wrong way around. I reckon that you've required time to cycle through redo be *less* than time to archive this redo, That'll hurt. I suspect you meant

Make sure that the time required to archive (N) redo logs is less than the time taken to generate (N) redo logs. That ought pretty much to imply make sure the sustained throughput to your arch destination is greater than your sustained redo rate.

On Tue, Jun 26, 2012 at 2:32 AM, Jared Still <jkstill_at_gmail.com> wrote:

> 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
>
>
>

--
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 26 2012 - 09:47:21 CDT