Feature
This view displays system wait events of tenants on the current OBServer, including the number of occurrences, wait time, and number of timeouts of each type of wait event.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | NUMBER | NO | The ID of the tenant. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer where the information is stored. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer 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. |