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 following table describes the types and IDs of wait events contained in the WAIT_CLASS column of a view.
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