Dynamic Performance (V$) Views, 98 of 238

V$LOCKED_OBJECT

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(15)`	OS user name
`PROCESS`	`VARCHAR2(9)`	OS process ID
`LOCKED_MODE`	`NUMBER`	Lock mode