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

See Also: "Oracle Wait Events"

EVENT_ID

NUMBER

Identifier of the wait event

TOTAL_WAITS

NUMBER

Total number of waits for the event by the service

TOTAL_TIMEOUTS

NUMBER

Total number of timeouts for the event by the service

TIME_WAITED

NUMBER

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

AVERAGE_WAIT

NUMBER

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

MAX_WAIT

NUMBER

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

TIME_WAITED_MICRO

NUMBER

Total amount of time waited for the event by the service (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