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.      

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-l
Received on Wed Sep 28 2011 - 09:55:01 CDT

Original text of this message