Experiencing again apperant hang very slow

From: Subodh Deshpande <subodh_deshpande_at_yahoo.com>
Date: Mon, 15 Dec 2008 04:04:44 -0800 (PST)
Message-ID: <409973.14772.qm@web31105.mail.mud.yahoo.com>


hi all, this is a 9.2.0.8 rac two node db. we have increased the size of redo from 33 mb to 100mb as per recommendations of expert and after which we are facing the problmes of waits..it seems that db is frequently checkpointing, now have been given the recommendation that should remove the follwing parameters log_checkpoints_to_alert TRUE => this is what i changed to false log_checkpoint_interval 2048 log_checkpoint_timeout 0 => i think this will not have now any effect as only integers should be considered.. and should set FAST_START_MTTR_TARGET to say 600 can somebody suggest me what are the default values, especially of log_checkpoint_interval 2048 thanks subodh

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 15 2008 - 06:04:44 CST

Original text of this message