Overview
V$SYSTEM_EVENT displays system-level wait events of tenants on the current OBServer, including the occurrence count, wait time, and timeout count of each type of wait event.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | NUMBER(38) | NO | The ID of the tenant. |
| EVENT_ID | NUMBER(38) | NO | The ID of the wait event. |
| EVENT | VARCHAR2(64) | NO | The name of the wait event. |
| WAIT_CLASS_ID | NUMBER(38) | NO | The ID of the class of the wait event. |
| WAIT_CLASS# | NUMBER(38) | NO | The number of the class of the wait event. |
| WAIT_CLASS | VARCHAR2(64) | NO | The name of the class of the wait event. |
| TOTAL_WAITS | NUMBER(38) | NO | The total number of waits for the event. |
| TOTAL_TIMEOUTS | NUMBER(38) | NO | The number of wait timeouts for the event. |
| TIME_WAITED | NUMBER(38) | NO | The total wait time for the event, in hundredths of a second. |
| AVERAGE_WAIT | NUMBER(38) | NO | The average wait time for the event, in hundredths of a second. |
| TIME_WAITED_MICRO | NUMBER(38) | NO | The total wait time in microseconds. |