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: mccdba1_at_yahoo.com
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: 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
