Re: Parallel index creates causing blocking lock alerting
Date: Thu, 25 Oct 2012 09:02:48 -0500 (CDT)
Message-ID: <aedd87b673d5869f5a8160ccf71d6dc6.squirrel_at_society.servebeer.com>
1+ week ago, I wrote:
> After upgrading to 11.2.0.3 (64-bit AIX 5.3), during index creates with DOP
> 2 on our dev DB, EM12c goes nuts in alerting me to blocking locks. It looks
> like the issue is in the DB:
>
> There are several messages in DBA_ALERT_HISTORY with a REASON of "Session
> nnn is blocking 0 other sessions". If it's blocking zero sessions, then why
> the message? The only thing of consequence happening at the time of these
> messages on a Friday night in this dev DB is a slew of CREATE
> INDEX...PARALLEL 2 statements running sequentially (one at a time). ASH and
> AWR reports seem to confirm this.
No one else seeing this? Oracle tells me that this is normal. Yes, I saw the behavior in 10.1 as well, but that version didn't feel the need to wake me up about it...
[sigh] I think I preferred my old unsupported bugs rather than the supported ones I have now.
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 25 2012 - 16:02:48 CEST