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>
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-lReceived on Mon Dec 15 2008 - 06:04:44 CST