DBWR pegged out
- From: "Doug Gernaat" <dag@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 08 Mar 2011 09:55:04 -0600
after oracle suggested bumping up db_writer_processes from 2 to 4, at times it
is still getting pegged out. "write complete waits" will become a top time
event.
drilling down will show:
SID User Wait state/time Waiting Location
23 db_user In waiting (2ms) write complete waits,
TEMP datafile:604
30 db_user In waiting (88ms) write complete waits,
TEMP datafile:604
179 db_user In waiting (101ms) write complete waits,
TEMP datafile:604
189 db_user In waiting (0ms) write complete waits,
TEMP datafile:604
354 db_user In waiting (109ms) write complete waits,
TEMP datafile:604
1532 db_user In waiting (6ms) write complete waits,
TEMP datafile:604
and diff users will fall in out of these write complete waits. i always see
TEMP... not any other dfiles.
also during these times... ora_ckpt will start blocking other sessions. is this
I/O contention? any suggestions?
dbwr_io_slaves is set to 0.
this is 11.2.0.2 on solaris sparc 64.
thanks
-doug-
--
//www.freelists.org/webpage/oracle-l
Other related posts:
