Overview
Displays the wait events of the current tenant on the current OBServer node, and provides statistics such as the number of occurrences, total wait time, and timeout count for each type of wait event.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | IP Address of the Server Where Information is Located |
| SVR_PORT | bigint(20) | NO | Port number of the server where the information is located |
| EVENT_ID | bigint(20) | NO | ID of the event to wait for |
| EVENT | varchar(64) | NO | Description of the Waiting Event |
| WAIT_CLASS_ID | bigint(20) | NO | Class ID of the Waiting Event |
| WAIT_CLASS# | bigint(20) | NO | Index of the class to which the event belongs |
| WAIT_CLASS | varchar(64) | NO | Class of the waiting event |
| TOTAL_WAITS | bigint(20) | NO | Total Wait Count for This Event |
| TOTAL_TIMEOUTS | bigint(20) | NO | Total Number of Timeout Events for This Wait Event |
| TIME_WAITED | double | NO | Total wait time for this event, in 10 milliseconds. |
| AVERAGE_WAIT | double | NO | The average wait time for this event, in 10 milliseconds. |
| TIME_WAITED_MICRO | bigint(20) | NO | Total wait time for this event, in microseconds. |
Sample query
In a user tenant, view all wait events of the current tenant on the current node, and display the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.V$SYSTEM_EVENT LIMIT 10;
The query result is as follows:
+--------+----------------+----------+----------+----------------------------+---------------+-------------+---------------+-------------+----------------+-------------+----------------------+-------------------+
| CON_ID | SVR_IP | SVR_PORT | EVENT_ID | EVENT | WAIT_CLASS_ID | WAIT_CLASS# | WAIT_CLASS | TOTAL_WAITS | TOTAL_TIMEOUTS | TIME_WAITED | AVERAGE_WAIT | TIME_WAITED_MICRO |
+--------+----------------+----------+----------+----------------------------+---------------+-------------+---------------+-------------+----------------+-------------+----------------------+-------------------+
| 1002 | 11.xxx.xxx.xxx | 28825 | 10001 | db file data read | 108 | 8 | USER_IO | 6466 | 0 | 248.8259 | 0.038482199195793376 | 2488259 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 11001 | db file compact read | 109 | 9 | SYSTEM_IO | 480081 | 0 | 30589.1178 | 0.06371657657770252 | 305891178 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 11002 | db file compact write | 109 | 9 | SYSTEM_IO | 2426062 | 0 | 63913.4377 | 0.026344519513516143 | 639134377 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 11016 | palf read | 109 | 9 | SYSTEM_IO | 541222 | 0 | 8143.9096 | 0.015047262675944438 | 81439096 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 11017 | palf write | 109 | 9 | SYSTEM_IO | 19637686 | 0 | 483846.5034 | 0.024638671959618868 | 4838465034 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 13000 | sync rpc | 107 | 7 | NETWORK | 1533 | 0 | 1351.2232 | 0.88142413568167 | 13512232 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 13001 | mysql response wait client | 106 | 6 | IDLE | 20 | 0 | 0.037 | 0.00185 | 370 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 13004 | wait in request queue | 102 | 2 | CONFIGURATION | 11518452 | 0 | 26999.07 | 0.002343984243716083 | 269990700 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 15101 | default condition wait | 104 | 4 | CONCURRENCY | 5465549 | 0 | 206549.5945 | 0.03779118886318648 | 2065495945 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 15102 | sleep wait | 106 | 6 | IDLE | 103 | 0 | 1023.8728 | 9.940512621359224 | 10238728 |
+--------+----------------+----------+----------+----------------------------+---------------+-------------+---------------+-------------+----------------+-------------+----------------------+-------------------+
10 rows in set
References
View the current or last wait event for all sessions:
View all wait events at the session level:
View the definitions of all wait events for a tenant: V$EVENT_NAME
For more information about wait events, see Common wait events.