Hi,
My system waitevents show follwoing stats.
Total Total Time
Avg
Waits Timeouts Waited % of
Wait
Event Name (in 1000s) (in 1000s) (in Hours) Concern
(Secs)
-------------------------- ----------- ----------- ----------- -------
virtual circuit status 24.67 24.67 147.33 65.24
21.50 <-----
dispatcher timer 8.10 8.10 75.00 33.21
33.34 <------
direct path write 464.78 0.00 1.52 0.67
0.01
control file parallel writ 161.14 0.00 0.50 0.22
0.01
db file sequential read 722.82 0.00 0.41 0.18
0.00
direct path read 591.98 0.00 0.37 0.16
0.00
log file parallel write 72.38 0.00 0.20 0.09
0.01
db file parallel write 5.04 0.00 0.17 0.08
0.12
log file sync 63.44 0.00 0.16 0.07
0.01
db file scattered read 807.96 0.00 0.13 0.06
0.00
SQL*Net message from clien 5,214.62 0.00 1,874.77 0.00
1.29
rdbms ipc message 663.95 516.08 599.03 0.00
3.25
pmon timer 162.20 162.19 75.01 0.00
1.66
smon timer 1.63 1.62 74.93 0.00
165.99
SQL*Net break/reset to cli 259.03 0.00 0.02 0.00
0.00
Any thought?
Is your PC infected? Get a FREE online computer virus scan from McAfeeŽ
Security.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu May 06 2004 - 15:22:13 CDT
