V$ENQUEUE_LOCK

This view shows the locks owned by enqueue state objects.

Fields

The most relevant view fields are as follows:

• ADDR: The address of the lock state object

• KADDR: The address of the lock

• SID: The identifier for the session holding or acquiring the lock

• TYPE: The type of lock

• ID1: Lock identifier #1 (depends on TYPE)

• ID2: Lock identifier #2 (depends on TYPE)

• LMODE: A lock mode in which the session holds the lock; values can be:

  • NONE

  • NULL (NULL)

  • ROW-S (SS)

  • ROW-X

  • SHARE (S)

  • S/ROW-X (SSX)

  • EXCLUSIVE (X)

• REQUEST: A lock mode in which the process request locks; values are the same as for LMODE fields

• CTIME: The time since the current mode was grant

• BLOCK: Whether this lock is blocking another lock

See also

• The V$LOCK, V$LOCKED_OBJECT, DBA_WAITERS, and DBA_BLOCKERS sections in this appendix