Purpose
The GV$SYSTEM_EVENT view displays system wait events on all OBServer nodes of the current tenant, including the number of occurrences, wait time, and number of timeouts of each class 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 OBServer node where the information is stored. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node 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. |