DBA Data[Home] [Help]

VIEW: SYS.V_$CON_SYSTEM_EVENT

Source

View Text - Preformatted

select "EVENT","TOTAL_WAITS","TOTAL_TIMEOUTS","TIME_WAITED","AVERAGE_WAIT","TIME_WAITED_MICRO","TOTAL_WAITS_FG","TOTAL_TIMEOUTS_FG","TIME_WAITED_FG","AVERAGE_WAIT_FG","TIME_WAITED_MICRO_FG","EVENT_ID","WAIT_CLASS_ID","WAIT_CLASS#","WAIT_CLASS","CON_ID" from v$con_system_event
View Text - HTML Formatted

SELECT "EVENT"
, "TOTAL_WAITS"
, "TOTAL_TIMEOUTS"
, "TIME_WAITED"
, "AVERAGE_WAIT"
, "TIME_WAITED_MICRO"
, "TOTAL_WAITS_FG"
, "TOTAL_TIMEOUTS_FG"
, "TIME_WAITED_FG"
, "AVERAGE_WAIT_FG"
, "TIME_WAITED_MICRO_FG"
, "EVENT_ID"
, "WAIT_CLASS_ID"
, "WAIT_CLASS#"
, "WAIT_CLASS"
, "CON_ID"
FROM V$CON_SYSTEM_EVENT