Overview
The DBA_WR_SYSTEM_EVENT view displays the persistent tenant-level wait event information for the current tenant.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| SNAP_ID | bigint(20) | NO | Snapshot ID |
| SVR_IP | varchar(46) | NO | Node IP |
| SVR_PORT | bigint(20) | NO | Node Port Number |
| EVENT_ID | bigint(20) | NO | Wait for Event ID |
| EVENT_NAME | varchar(64) | YES | Event Name |
| WAIT_CLASS_ID | bigint(20) | YES | Category ID of the event to be waited for |
| WAIT_CLASS | varchar(64) | YES | The name of the category to which the event belongs. |
| TOTAL_WAITS | bigint(20) | YES | Total Number of Wait Events |
| TOTAL_TIMEOUTS | bigint(20) | YES | Total Number of Timeout Attempts for Waiting Events |
| TIME_WAITED_MICRO | bigint(20) | YES | Total Waiting Time for Events |
The values in the WAIT_CLASS column of the view contain the type names and corresponding event IDs of the wait events, as shown in the following table.
Type of the event to be waited for |
Wait Event Number ID |
Description |
|---|---|---|
| OTHER | 100 | Waiting Events Not Belonging to Other Types |
| APPLICATION | 101 | Wait Events Caused by Client Code |
| CONFIGURATION | 102 | Waiting Events Caused by Insufficient Database or Instance Resource Configuration |
| ADMINISTRATIVE | 103 | Wait Events Caused by Database Administrators' Command Input |
| CONCURRENCY | 104 | Wait events for internal database resources |
| COMMIT | 105 | Waiting Events Related to Log Commit |
| IDLE | 106 | A wait event that the session is in an inactive state and waiting for a task. |
| NETWORK | 107 | Network Communication-Related Waiting Events |
| USER_IO | 108 | I/O Wait Events |
| SYSTEM_IO | 109 | Waiting for I/O of Background Process Event |
| CLUSTER | 111 | Cluster-related wait events |
Sample query
Query the persistent tenant-level wait event information of the current tenant and display the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_SYSTEM_EVENT LIMIT 10;
The query result is as follows:
+---------+----------------+----------+----------+-----------------------------------+---------------+-------------+-------------+----------------+-------------------+
| SNAP_ID | SVR_IP | SVR_PORT | EVENT_ID | EVENT_NAME | WAIT_CLASS_ID | WAIT_CLASS | TOTAL_WAITS | TOTAL_TIMEOUTS | TIME_WAITED_MICRO |
+---------+----------------+----------+----------+-----------------------------------+---------------+-------------+-------------+----------------+-------------------+
| 1 | 172.xx.xxx.xxx | 2882 | 2 | latch: default spin rwlock wait | 104 | CONCURRENCY | 9 | 0 | 2514 |
| 1 | 172.xx.xxx.xxx | 2882 | 3 | latch: default mutex wait | 104 | CONCURRENCY | 318 | 0 | 14740 |
| 1 | 172.xx.xxx.xxx | 2882 | 8 | latch: trans ctx latch wait | 104 | CONCURRENCY | 15 | 0 | 15244 |
| 1 | 172.xx.xxx.xxx | 2882 | 40 | latch: config lock wait | 104 | CONCURRENCY | 14 | 0 | 207794 |
| 1 | 172.xx.xxx.xxx | 2882 | 99 | latch: tablet bucket lock wait | 104 | CONCURRENCY | 1 | 0 | 1334 |
| 1 | 172.xx.xxx.xxx | 2882 | 258 | latch: palf handle impl lock wait | 104 | CONCURRENCY | 3 | 0 | 186 |
| 1 | 172.xx.xxx.xxx | 2882 | 283 | latch: ls meta lock wait | 104 | CONCURRENCY | 26 | 0 | 3568 |
| 1 | 172.xx.xxx.xxx | 2882 | 10001 | db file data read | 108 | USER_IO | 2 | 0 | 3946 |
| 1 | 172.xx.xxx.xxx | 2882 | 11001 | db file compact read | 109 | SYSTEM_IO | 1545 | 0 | 816400 |
| 1 | 172.xx.xxx.xxx | 2882 | 11002 | db file compact write | 109 | SYSTEM_IO | 10292 | 0 | 1420220 |
+---------+----------------+----------+----------+-----------------------------------+---------------+-------------+-------------+----------------+-------------------+
10 rows in set