8.43 V$LOCKED_OBJECT
V$LOCKED_OBJECT
lists all locks acquired by every transaction on the system. It shows which sessions are holding DML locks (that is, TM-type enqueues) on what objects and in what mode.
Column | Datatype | Description |
---|---|---|
|
|
Undo segment number |
|
|
Slot number |
|
|
Sequence number |
|
|
Object ID being locked |
|
|
Session ID |
|
|
Oracle user name |
|
|
Operating system user name |
|
|
Operating system process ID |
|
|
Lock mode. The numeric values for this column map to these text values for the lock modes for table locks:
See Also: Oracle Database Concepts for more information about lock modes for table locks |
|
|
The ID of the container to which the data pertains. Possible values include:
|