Re: Increasing redo size, increases shutdown time

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_at_gmail.com>
> 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