DBA Data[Home] [Help]

VIEW: SYS.V_$SESSION_BLOCKERS

Source

View Text - Preformatted

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

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