V$LOCKED_OBJECT
This view 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 |
---|---|---|
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
|
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27573546/viewspace-758967/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27573546/viewspace-758967/