Note
This view is available starting with V4.2.2.
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 | Wait for Event Name |
| WAIT_CLASS_ID | bigint(20) | YES | ID of the category to which the event belongs |
| WAIT_CLASS | varchar(64) | YES | Category name of the event to be waited for |
| TOTAL_WAITS | bigint(20) | YES | Total Number of Wait Events |
| TOTAL_TIMEOUTS | bigint(20) | YES | Total Timeout Count of 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 name and corresponding event ID of the wait event. The following table describes these values.
Type of the event to be waited for |
Event Number |
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 entering commands |
| CONCURRENCY | 104 | Wait events for internal database resources |
| COMMIT | 105 | Waiting Events Related to Log Commit |
| IDLE | 106 | The session is in an inactive state, waiting for the task's wait event. |
| NETWORK | 107 | Network Communication Related Waiting Events |
| USER_IO | 108 | I/O Waiting Events |
| SYSTEM_IO | 109 | I/O Waiting Event for Background Processes |
| CLUSTER | 111 | Cluster-related wait events |
Sample query
Query the persistent tenant-level wait event information for 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