Overview
gv$system_event displays all tenant-level wait events in the cluster.
Related tables/views
__all_virtual_system_event
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | BIGINT(20) | No | The ID of the tenant. |
| SVR_IP | varchar(32) | No | The IP address of the OBserver where the information is stored. |
| SVR_PORT | BIGINT(20) | No | The port number of the OBserver where the information is stored. |
| EVENT_ID | BIGINT(20) | No | The ID of the wait event. |
| EVENT | varchar(64) | No | The description of the wait event. |
| WAIT_CLASS_ID | BIGINT(20) | No | The ID of the class to which the wait event belongs. |
| WAIT_CLASS# | BIGINT(20) | No | The subscript of the class to which the wait event belongs. |
| WAIT_CLASS | varchar(64) | No | The name of the class to which the wait event belongs. |
| TOTAL_WAITS | BIGINT(20) | No | The total number of waits for the event. |
| TOTAL_TIMEOUTS | BIGINT(20) | No | The total number of timeouts for the event. |
| TOTAL_WAITED | DOUBLE | No | The total wait time for the event, in hundredths of a second. |
| AVERAGE_WAIT | DOUBLE | No | The average wait time for the event, in hundredths of a second. |
| TOTAL_WAITED_MICRO | BIGINT(20) | No | The total wait time for the event in microseconds. |