DBA Data[Home] [Help]

VIEW: SYS.V_$GES_DEADLOCKS

Source

View Text - Preformatted

select "DID","DD_TIME","NUMBER_OF_SESSIONS","MASTER_INSTANCE","VICTIM_INSTANCE","VICTIM_PID","VICTIM_RESNM","VICTIM_SID","VICTIM_SERIAL#","VICTIM_REQ_LEVEL","CON_ID" from v$ges_deadlocks
View Text - HTML Formatted

SELECT "DID"
, "DD_TIME"
, "NUMBER_OF_SESSIONS"
, "MASTER_INSTANCE"
, "VICTIM_INSTANCE"
, "VICTIM_PID"
, "VICTIM_RESNM"
, "VICTIM_SID"
, "VICTIM_SERIAL#"
, "VICTIM_REQ_LEVEL"
, "CON_ID"
FROM V$GES_DEADLOCKS