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博客 ” ，链接：https://blog.itpub.net/27573546/viewspace-758967/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
UNDO表空间不足解决方法
下一篇：
V$LOCK
请登录后发表评论
登录
全部评论
