[Home] [Help]
VIEW: SYS.GV_$GLOBAL_BLOCKED_LOCKS
Source
View Text - Preformatted
select "INST_ID","ADDR","KADDR","SID","TYPE","ID1","ID2","LMODE","REQUEST","CTIME","CON_ID" from gv$global_blocked_locks
View Text - HTML Formatted
SELECT "INST_ID"
, "ADDR"
, "KADDR"
, "SID"
, "TYPE"
, "ID1"
, "ID2"
, "LMODE"
, "REQUEST"
, "CTIME"
, "CON_ID"
FROM GV$GLOBAL_BLOCKED_LOCKS