Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
This view lists all locks acquired by every transaction on the system.
Column | Datatype | Description |
---|---|---|
XIDUSN |
NUMBER |
Undo segment number |
XIDSLOT |
NUMBER |
Slot number |
XIDSQN |
NUMBER |
Sequence number |
OBJECT_ID |
NUMBER |
Object ID being locked |
SESSION_ID |
NUMBER |
Session ID |
ORACLE_USERNAME |
VARCHAR2(30) |
Oracle user name |
OS_USER_NAME |
VARCHAR2(30) |
OS user name |
PROCESS |
VARCHAR2(12) |
OS process ID |
LOCKED_MODE |
NUMBER |
Lock mode |