DBA Data[Home] [Help]

VIEW: SYS.V_$HANG_SESSION_INFO

Source

View Text - Preformatted

select "HANG_ID","INSTANCE","SID","SERIAL#","OSPID","FATAL_BACKGROUND","ROOT","PNAME","WAIT_EVENT_TEXT","QOS_PC_RANK","QOS_PC_ITT","QOS_PC_RTT","QOS_PC_KEY","CON_ID" from v$hang_session_info
View Text - HTML Formatted

SELECT "HANG_ID"
, "INSTANCE"
, "SID"
, "SERIAL#"
, "OSPID"
, "FATAL_BACKGROUND"
, "ROOT"
, "PNAME"
, "WAIT_EVENT_TEXT"
, "QOS_PC_RANK"
, "QOS_PC_ITT"
, "QOS_PC_RTT"
, "QOS_PC_KEY"
, "CON_ID"
FROM V$HANG_SESSION_INFO