DBA Data[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