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