Awr waits over 100%
- From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
- Date: Wed, 28 Sep 2011 10:55:01 -0400
I pulled an awr this morning for a period and the top wait events add up to
almost 200%. I was curious if anyone saw this before. I've seen it slightly
over 100% that I wrote off for rounding but never saw it so high. I'm
addressing the actual wait events so no issues there.
Top 5 Timed Events
Event
Waits
Time(s)
Avg Wait(ms)
% Total Call Time
Wait Class
log file sync
356,514
2,521
7
84.5
Commit
log file parallel write
358,641
1,967
5
65.9
System I/O
CPU time
1,192
39.9
db file parallel write
23,911
364
15
12.2
System I/O
log buffer space
135
58
427
1.9
Configuration
Thanks,
ken
--
//www.freelists.org/webpage/oracle-l
Other related posts:
