To add a bit more, on a busy system it is even possible that productive work ( CPU time ) "appears" to be > 100% according to AWR. Regards Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com On 2011-09-28, at 12:19 PM, Wolfgang Breitling wrote: > I'd consider that "normal" > While a system has only a limited ( to the number of cpus/cores ) capacity > for productive work, any system has an unlimited capacity to wait. > E.g. if one session holds a lock for 1 hour and 2 sessions wait for that lock > fthen you may have up to 100% ( 1 hour in 1 hour ) cpu usage from that one > session and 200% ( 2 hours in 1 hour ) waits from the other 2 sessions. > Regards > Wolfgang Breitling > Centrex Consulting Corporation > http://www.centrexcc.com > > On 2011-09-28, at 8:55 AM, Kenneth Naim wrote: > >> 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. >> > > > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l