Re: Increasing redo size, increases shutdown time
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Apr 2006 08:30:48 +0100
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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
