-
Statspack report- Top wait events
Hi,
My statspack is running every one hour.
In my report for the wait events, I am getting as follows.
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
queue messages 1,800
1,842,945 82.62
PL/SQL lock timer 360
368,574 16.52
db file sequential read 106,165
15,344 .69
db file scattered read 13,802
1,097 .05
log file parallel write 4,293
923 .04
Here as for as I know waits time is in 100th of a second
So for a queue messages
1,842,945 =18429.45 Seconds
18429.45/60 =307.1575 M
305.1575/60=5.085 Hours
How come it can for 5 Hours time in a one hour statspack report?
How is it possible? My performance is very slow.
Please clarify my doubt
Seelan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|