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>
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-lReceived on Wed Apr 27 2011 - 07:07:04 CDT