Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> extensive waits on 'direct path writes'
From a statspack report (9.2.0.8 on solaris) of a 5 hour duration during a night batch update
cycle on a data warehouse
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- PX Deq Credit: send blkd 1,717,992 121,654 17.92 direct path write 212,362 109,472 16.13 db file scattered read 2,080,746 106,406 15.68 direct path read 1,420,179 88,819 13.08 enqueue 28,024 79,127 11.66
I've never seen the 'direct path write' event be the top event before
(according to Metalink the PX Deq... event is an idle event, so I'm
ignoring that one)
I'm trying to understand the following statements (from metalink) "If asynchronous IO is not being used then the IO write request blocks until completed but this dies not show as a wait at the time the IO is issued. The session returns later to pick up the completed IO data but can then show a wait on "direct path write" even though this wait will return immediately. "
Matt
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 10 2007 - 09:36:31 CDT
![]() |
![]() |