On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
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 Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- control file parallel write 5,499 1,141 90.37 CPU time 97 7.70 log file parallel write 1,305 12 .95 db file parallel write 162 6 .44 log file switch completion 10 2 .16
------------------------------------------------------------- Wait Events for DB: 9IDEV Instance: 9idev Snaps: 5 -6 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txn ---------------------------- ------------ ---------- ---------- ------ -------- 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
------------------------------------------------------------- Background Wait Events for DB: 9IDEV Instance: 9idev Snaps: 5 -6 -> ordered by wait time desc, waits desc (idle events last)
__________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dba1 mcc INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).