Oracle Database 11gR2 Performance Tuning Cookbook

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 ...