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