Overview
The DBA_WR_EVENT_NAME view displays the names of persistent tenant-level wait events for the current tenant.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| EVENT_ID | bigint(20) | NO | Wait for Event ID |
| EVENT_NAME | varchar(64) | YES | Wait Time Name |
| PARAMETER1 | varchar(64) | YES | Name of the wait time parameter 1 |
| PARAMETER2 | varchar(64) | YES | Name of Wait Time Parameter 2 |
| PARAMETER3 | varchar(64) | YES | Name of the Wait Time Parameter 3 |
| 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. |
The values in the WAIT_CLASS column of the view contain the type name and corresponding event ID of the wait event, 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 names of persistent tenant-level wait events for the current tenant and display the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_EVENT_NAME LIMIT 10;
The query result is as follows:
+----------+-----------------------------------+------------+------------+------------+---------------+-------------+
| EVENT_ID | EVENT_NAME | PARAMETER1 | PARAMETER2 | PARAMETER3 | WAIT_CLASS_ID | WAIT_CLASS |
+----------+-----------------------------------+------------+------------+------------+---------------+-------------+
| 0 | latch: latch wait queue lock wait | address | number | tries | 104 | CONCURRENCY |
| 1 | latch: default spin lock wait | address | number | tries | 104 | CONCURRENCY |
| 2 | latch: default spin rwlock wait | address | number | tries | 104 | CONCURRENCY |
| 3 | latch: default mutex wait | address | number | tries | 104 | CONCURRENCY |
| 4 | latch: kv cache bucket latch wait | address | number | tries | 104 | CONCURRENCY |
| 5 | latch: time wheel task latch wait | address | number | tries | 104 | CONCURRENCY |
| 7 | latch: election latch wait | address | number | tries | 104 | CONCURRENCY |
| 8 | latch: trans ctx latch wait | address | number | tries | 104 | CONCURRENCY |
| 14 | latch: clog reconfirm latch wait | address | number | tries | 104 | CONCURRENCY |
| 17 | latch: clog task latch wait | address | number | tries | 104 | CONCURRENCY |
+----------+-----------------------------------+------------+------------+------------+---------------+-------------+
10 rows in set