DBA Data[Home] [Help]

VIEW: SYS.V_$SERVICE_EVENT

Source

View Text - Preformatted

select "SERVICE_NAME","SERVICE_NAME_HASH","EVENT","EVENT_ID","TOTAL_WAITS","TOTAL_TIMEOUTS","TIME_WAITED","AVERAGE_WAIT","MAX_WAIT","TIME_WAITED_MICRO","CON_ID" from v$service_event
View Text - HTML Formatted

SELECT "SERVICE_NAME"
, "SERVICE_NAME_HASH"
, "EVENT"
, "EVENT_ID"
, "TOTAL_WAITS"
, "TOTAL_TIMEOUTS"
, "TIME_WAITED"
, "AVERAGE_WAIT"
, "MAX_WAIT"
, "TIME_WAITED_MICRO"
, "CON_ID"
FROM V$SERVICE_EVENT