Are Enqueue locks implemented with a FIFO queuing mechanism

From: Matt McClernon <mccmx_at_hotmail.com>
Date: Wed, 27 Apr 2011 12:07:04 +0000
Message-ID: <COL117-W57D2F99C14B3BFB5D91FF6B7980_at_phx.gbl>


Oracle 11gR1 EE on RHEL 4 (x86_64)

Are Oracle enqueue locks obtained in a 'first in, first out' fashion..? I'm specifically interested in 'enqueue - JI' locks - i.e. the exclusive lock obtained to serialzie a materialzized view refresh.

We had a situation recently where a session was waiting to obtain an 'enqeue - JI' resource and was being blocked by sessions which were established after the first session requested access to the lock in question. This behaviour seems unusual (buggy..?) because I expected a fifo type implementation with enqueue resources in Oracle.                                                  

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 27 2011 - 07:07:04 CDT

Original text of this message