Re: Awr waits over 100%
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 28 Sep 2011 12:19:12 -0600
Message-Id: <13888B67-9528-4026-8691-911CF826939A_at_centrexcc.com>
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
Date: Wed, 28 Sep 2011 12:19:12 -0600
Message-Id: <13888B67-9528-4026-8691-911CF826939A_at_centrexcc.com>
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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 28 2011 - 13:19:12 CDT