Awr waits over 100%
From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Wed, 28 Sep 2011 10:55:01 -0400
Message-ID: <038101cc7dee$9aa254c0$cfe6fe40$_at_gmail.com>
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.
Date: Wed, 28 Sep 2011 10:55:01 -0400
Message-ID: <038101cc7dee$9aa254c0$cfe6fe40$_at_gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 28 2011 - 09:55:01 CDT