Re: Parallel index creates causing blocking lock alerting
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 25 Oct 2012 09:02:48 -0500 (CDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
