Purpose
The GV$SYSTEM_EVENT view displays system wait events of tenants on all servers, including the number of occurrences, wait time, and number of timeouts of each type of wait event.
Note
This view is introduced since OceanBase Database V1.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | NUMBER | NO | The ID of the tenant. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server where the information is stored. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server where the information is stored. |
| EVENT_ID | NUMBER | NO | The ID of the wait event. |
| EVENT | VARCHAR2(64) | NO | The description of the wait event. |
| WAIT_CLASS_ID | NUMBER | NO | The ID of the class to which the wait event belongs. |
| WAIT_CLASS# | NUMBER | NO | The subscript of the class to which the wait event belongs. |
| WAIT_CLASS | VARCHAR2(64) | NO | The name of the class to which the wait event belongs. |
| TOTAL_WAITS | NUMBER | NO | The total number of waits for the event. |
| TOTAL_TIMEOUTS | NUMBER | NO | The total number of timeouts for the event. |
| TIME_WAITED | NUMBER | NO | The total wait time for the event, in hundredths of a second. |
| AVERAGE_WAIT | NUMBER | NO | The average wait time for the event, in hundredths of a second. |
| TIME_WAITED_MICRO | NUMBER | NO | The total wait time for the event in microseconds. |