DBA Data[Home] [Help]

VIEW: SYS.GV_$SESSION_EVENT

Source

View Text - Preformatted

select "INST_ID","SID","EVENT","TOTAL_WAITS","TOTAL_TIMEOUTS","TIME_WAITED","AVERAGE_WAIT","MAX_WAIT","TIME_WAITED_MICRO","EVENT_ID","WAIT_CLASS_ID","WAIT_CLASS#","WAIT_CLASS","CON_ID" from gv$session_event
View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "EVENT"
, "TOTAL_WAITS"
, "TOTAL_TIMEOUTS"
, "TIME_WAITED"
, "AVERAGE_WAIT"
, "MAX_WAIT"
, "TIME_WAITED_MICRO"
, "EVENT_ID"
, "WAIT_CLASS_ID"
, "WAIT_CLASS#"
, "WAIT_CLASS"
, "CON_ID"
FROM GV$SESSION_EVENT