V$LOCKED_OBJECT

This view shows which sessions are holding DML locks and on what objects.

Fields

The most relevant view fields are:

• XIDUSN: The undo segment number

• XIDSLOT: The slot number

• XIDSQN: The sequence number

• OBJECT_ID: The object ID being locked

• SESSION_ID: The session identifier number

• ORACLE_USERNAME: The Oracle username

• OS_USER: The operating system user

• PROCESS: The operating system process identifier

• LOCKED_MODE: The lock mode

See also

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