Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: Increasing redo size, increases shutdown time

Jonathan Lewis

2006-04-25




Quite possibly.

In the absence of any other directive, the continuous
checkpointing mechanism sets the effective size of
log_checkpoint_interval to 90% of the smallest log
file. This means you could get a LOT more dirty
blocks in the buffer if you increase the size of the redo
log dramatically. Since the database shutdown (other
than abort) requires a database checkpoint, you would
then spend more time writing those blocks to disc.


Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html


> Date: Mon, 24 Apr 2006 14:57:36 -0400
> From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@(protected)>
> Subject: Increasing redo size, increases shutdown time
>
> Hi, does this afirmation makes sense?
> After I increased redologs to 200mb, to test time of archive, I found
> the time to shutdown increased to, and it was not switching.
>
> Is there some correlation?
>
> Thank you
>


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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.