Re: Automatic checkpoint tuning on RAC

"Mladen Gogala" <mladen_at_bogus.email.com> wrote in message news:h2gbfd$3q8$1_at_solani.org...
>I recently talked about the automatic checkpoint tuning with a colleague
> of mine and we considered setting fast_start_mttr_target to a decent non-
> zero value like 300 on a RAC database. I am aware of the recommendation
> not to set it and the argument for that recommendation is the fact that
> another RAC instance will do a recovery, if an instance fails.
>

Have you got a reference for the recommendation to not set it ?

It seems to be fairly irrelevant to suggest that it's not needed because "another RAC instance will do a recovery" - the fast_start_mttr_target would surely affect the time it takes that instance to do the recovery.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

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

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