Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-10
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_DML_LOCKS

DBA_DML_LOCKS lists all DML locks held in the database and all outstanding requests for a DML lock.

Column Datatype NULL Description
SESSION_ID NUMBER   Session holding or acquiring the lock
OWNER VARCHAR2(30) NOT NULL Owner of the lock
NAME VARCHAR2(30) NOT NULL Name of the lock
MODE_HELD VARCHAR2(13)   The type of lock held. The values are:
  • ROWS_S (SS): row share lock

  • ROW-X (SX): row exclusive lock

  • SHARE (S): share lock

  • S/ROW-X (SSX): exclusive lock

  • NONE: lock requested but not yet obtained

MODE_REQUESTED VARCHAR2(13)   Lock request type. The values are:
  • ROWS_S (SS): row share lock

  • ROW-X (SX): row exclusive lock

  • SHARE (S): share lock

  • S/ROW-X (SSX): exclusive lock

  • NONE: Lock identifier obtained; lock not held or requested

LAST_CONVERT NUMBER   The last convert
BLOCKING_OTHERS VARCHAR2(40)   Blocking others