DBA Data[Home] [Help]

VIEW: SYS.V_$GLOBAL_BLOCKED_LOCKS

Source

View Text - Preformatted

select "ADDR","KADDR","SID","TYPE","ID1","ID2","LMODE","REQUEST","CTIME","CON_ID" from v$global_blocked_locks
View Text - HTML Formatted

SELECT "ADDR"
, "KADDR"
, "SID"
, "TYPE"
, "ID1"
, "ID2"
, "LMODE"
, "REQUEST"
, "CTIME"
, "CON_ID"
FROM V$GLOBAL_BLOCKED_LOCKS