Note
- For V4.3.x, this view is available starting with V4.3.5.
- For V4.2.x, this view is available starting with V4.2.2.
Purpose
The DBA_WR_SYSTEM_EVENT view displays the persistent tenant-level wait event information of the current tenant.
Columns
| Column | 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 event ID |
| EVENT_NAME | varchar(64) | YES | Wait event name |
| WAIT_CLASS_ID | bigint(20) | YES | Wait event classification ID |
| WAIT_CLASS | varchar(64) | YES | Wait event classification name |
| TOTAL_WAITS | bigint(20) | YES | Total number of wait events |
| TOTAL_TIMEOUTS | bigint(20) | YES | Total number of timeouts for wait events |
| TIME_WAITED_MICRO | bigint(20) | YES | Total wait time for wait events |
The values of the WAIT_CLASS column in the view indicate the wait event classification name and the corresponding wait event ID, as shown in the table below.
| Wait event classification name | Wait event ID | Description |
|---|---|---|
| OTHER | 100 | A wait event that does not belong to other classifications |
| APPLICATION | 101 | A wait event caused by client code |
| CONFIGURATION | 102 | A wait event caused by insufficient database or instance resource configuration |
| ADMINISTRATIVE | 103 | A wait event caused by a database administrator command |
| CONCURRENCY | 104 | A wait event for internal database resources |
| COMMIT | 105 | A wait event related to log commit |
| IDLE | 106 | A wait event for an inactive session |
| NETWORK | 107 | A wait event related to network communication |
| USER_IO | 108 | A wait event for user I/O |
| SYSTEM_IO | 109 | A wait event for background process I/O |
| CLUSTER | 111 | A wait event related to the cluster |
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 | 7 | 0 | 113693 |
| 1 | 172.xx.xxx.xxx | 2882 | 3 | latch: default mutex wait | 104 | CONCURRENCY | 517 | 0 | 29687 |
| 1 | 172.xx.xxx.xxx | 2882 | 8 | latch: trans ctx latch wait | 104 | CONCURRENCY | 84 | 0 | 68001 |
| 1 | 172.xx.xxx.xxx | 2882 | 33 | latch: ls latch wait | 104 | CONCURRENCY | 2 | 0 | 9829 |
| 1 | 172.xx.xxx.xxx | 2882 | 40 | latch: config lock wait | 104 | CONCURRENCY | 20 | 0 | 358460 |
| 1 | 172.xx.xxx.xxx | 2882 | 47 | latch: rs bootstrap lock wait | 104 | CONCURRENCY | 1 | 0 | 29706546 |
| 1 | 172.xx.xxx.xxx | 2882 | 55 | latch: unit manager lock wait | 104 | CONCURRENCY | 2 | 0 | 2965 |
| 1 | 172.xx.xxx.xxx | 2882 | 92 | latch: block manager lock wait | 104 | CONCURRENCY | 1 | 0 | 5 |
| 1 | 172.xx.xxx.xxx | 2882 | 99 | latch: tablet bucket lock wait | 104 | CONCURRENCY | 3 | 0 | 2684 |
| 1 | 172.xx.xxx.xxx | 2882 | 202 | latch: zone merge manager write lock wait | 104 | CONCURRENCY | 1 | 0 | 554 |
+---------+----------------+----------+----------+-------------------------------------------+---------------+-------------+-------------+----------------+-------------------+
10 rows in set