DX Lock in index
Date: Tue, 28 Apr 2009 14:09:50 +0200
Message-ID: <8580d4110904280509n34e9b31es84e0df40930fdf68_at_mail.gmail.com>
List,
I have just encountered a situation where we get blocking locks on indexes where the locktype is DX. I didn't think blocking occured on index for regular SQL. Does anyone recognize this or know of a document that goes into detail on DX locks. I'm not finding much detail on this locktype.
I don't have a current lock situation to pull data from, but last time the locked object seemed to map to an index. Isn't DX supposed to be a transaction lock controlling the undo and other things required for a remote incomming transaction? That is, should I expect it to block data and/or index? I'm mostly looking for verification that the current conclusion that this was in an index is unlikely and we need to track the lock next time to try to find a target more natural for DX.
Mathias
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 28 2009 - 07:09:50 CDT