Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> [Q] wait time on stat
WE have ORACLE 9.2.0.3 database run under Win2000. I
run "statspack" and found "Top 5 timed event". Look
like "control file parallel write " and "redo file
parallel write " take lots time. How to fix?
Top 5 Timed Events
% Total EventWaits Time (s) Ela Time
Avg Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txnBackground Wait Events for DB: 9IDEV Instance: 9idev Snaps: 5 -6
---------------------------- ------------ ----------
---------- ------ --------
control file parallel write 5,499 0 1,141 207 211.5 log file parallel write 1,305 1,299 12 9 50.2 db file parallel write 162 0 6 34 6.2 log file switch completion 10 0 2 204 0.4 control file sequential read 3,827 0 2 0 147.2 db file sequential read 176 0 1 7 6.8 direct path write 92 0 1 6 3.5 log file sync 14 0 0 33 0.5 log file single write 20 0 0 13 0.8 log file sequential read 35 0 0 6 1.3 direct path read 92 0 0 2 3.5 SQL*Net break/reset to clien 44 0 0 0 1.7 SQL*Net more data to client 7 0 0 0 0.3 async disk IO 4 0 0 0 0.2 virtual circuit status 6,826 496 19,650 2879 262.5 wakeup time manager 530 530 19,179 36187 20.4 SQL*Net message from client 6,457 0 12,084 1871 248.3 jobq slave wait 402 381 1,227 3051 15.5 SQL*Net message to client 6,458 0 0 0 248.4
-------------------------------------------------------------
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 28 2004 - 14:09:26 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |