DBWR pegged out

From: Doug Gernaat <dag_at_its.msstate.edu>
Date: Tue, 08 Mar 2011 09:55:04 -0600
Message-Id: <4D75FCF8020000340006BCFF_at_mailhost.groupwise.msstate.edu>

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-

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 08 2011 - 09:55:04 CST