DBA Data[Home] [Help]

VIEW: SYS.GV_$LOCKED_OBJECT

Source

View Text - Preformatted

select "INST_ID","XIDUSN","XIDSLOT","XIDSQN","OBJECT_ID","SESSION_ID","ORACLE_USERNAME","OS_USER_NAME","PROCESS","LOCKED_MODE","CON_ID" from gv$locked_object
View Text - HTML Formatted

SELECT "INST_ID"
, "XIDUSN"
, "XIDSLOT"
, "XIDSQN"
, "OBJECT_ID"
, "SESSION_ID"
, "ORACLE_USERNAME"
, "OS_USER_NAME"
, "PROCESS"
, "LOCKED_MODE"
, "CON_ID"
FROM GV$LOCKED_OBJECT