Note
This view is introduced since OceanBase Database V4.2.2.
Purpose
The oceanbase.DBA_WR_EVENT_NAME view displays the names of persisted tenant-level wait events in the current tenant.
Columns
| Column | Type | Nullable? | Description | |
|---|---|---|---|---|
| EVENT_ID | bigint(20) | No | The ID of the wait event. | |
| EVENT_NAME | varchar(64) | Yes | The name of the wait event. | |
| PARAMETER1 | varchar(64) | Yes | The name of the first parameter of the wait event. | |
| PARAMETER2 | varchar(64) | Yes | The name of the second parameter of the wait event. | |
| PARAMETER3 | varchar(64) | Yes | The name of the third parameter of the wait event. | |
| WAIT_CLASS_ID | bigint(20) | Yes | The ID of the wait event class. | |
| WAIT_CLASS | varchar(64) | Yes | The name of the wait event class. | ---Names of wait event classes are to be provided. |
Example
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