DX Lock in index

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Tue, 28 Apr 2009 14:09:50 +0200
Message-ID: <8580d4110904280509n34e9b31es84e0df40930fdf68_at_mail.gmail.com>


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.


Received on Tue Apr 28 2009 - 07:09:50 CDT

Original text of this message