Re: DBWR pegged out
Date: Thu, 10 Mar 2011 09:52:13 +0530
I think if it is using temp tablespace then its application issue.. check the sorts, usuage of indexes..
random guess is think on re-sizing sga and check utilisation of memory by oracle and at os level..
oracle has recommended setting _db_fast_obj_ckpt and _db_fast_obj_truncate to false to see if they alleviate UnQuote
after this check whether checkpoint interval becomes consistent and size of
archives..other wise in future you may face issues db recovery, if it
On 9 March 2011 21:06, Doug Gernaat <dag_at_its.msstate.edu> wrote:
> thanks to all for the info...
> this is a sun-fire v890 48G of memory and 6CPU.
> this is a new problem after upgrading to 11gR2.
> it is sporadic... i want to say it is encountered mostly
> when there is commit intensive jobs running.
> oracle has recommended setting _db_fast_obj_ckpt and
> _db_fast_obj_truncate to false to see if they alleviate
> write complete waits and enq: KO - fast object.
-- ============================== DO NOT FORGET TO SMILE TODAY ============================== -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 09 2011 - 22:22:13 CST