DBA Data[Home] [Help]

VIEW: SYS.GV_$SESSION_BLOCKERS

Source

View Text - Preformatted

select "INST_ID","SID","SESS_SERIAL#","WAIT_ID","WAIT_EVENT","WAIT_EVENT_TEXT","BLOCKER_INSTANCE_ID","BLOCKER_SID","BLOCKER_SESS_SERIAL#","CON_ID" from gv$session_blockers
View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "SESS_SERIAL#"
, "WAIT_ID"
, "WAIT_EVENT"
, "WAIT_EVENT_TEXT"
, "BLOCKER_INSTANCE_ID"
, "BLOCKER_SID"
, "BLOCKER_SESS_SERIAL#"
, "CON_ID"
FROM GV$SESSION_BLOCKERS