Re: Awr waits over 100%
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: kennethnaim@xxxxxxxxx
- Date: Wed, 28 Sep 2011 16:26:11 -0600
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
Other related posts:
