9.7 V$SERVICE_EVENT

V$SERVICE_EVENT displays aggregated wait counts and wait times for each wait statistic.

Column Datatype Description

SERVICE_NAME

VARCHAR2(64)

Service name from V$SERVICES

SERVICE_NAME_HASH

NUMBER

Service name hash from V$SERVICES

EVENT

VARCHAR2(64)

Name of the wait event; derived statistic name from V$EVENT_NAME

EVENT_ID

NUMBER

Identifier of the event

TOTAL_WAITS

NUMBER

Total amount of time waited for the event by this service (in hundredths of a second)

TOTAL_TIMEOUTS

NUMBER

Total number of timeouts for the event by this service

TIME_WAITED

NUMBER

Time waited for the event (in hundredths of a second)

AVERAGE_WAIT

NUMBER

Average amount of time waited for the event by this service (in hundredths of a second)

MAX_WAIT

NUMBER

Maximum time (in hundredths of a second) waited for the event by this service

TIME_WAITED_MICRO

NUMBER

Total time waited for the event (in microseconds)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data