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_EVENT_NAME view displays the names of tenant-level wait events that have been persisted for the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| EVENT_ID | NUMBER(38) | NO | The ID of the wait event. |
| EVENT_NAME | VARCHAR2(64) | YES | The name of the wait event. |
| PARAMETER1 | VARCHAR2(64) | YES | The name of wait event parameter 1. |
| PARAMETER2 | VARCHAR2(64) | YES | The name of wait event parameter 2. |
| PARAMETER3 | VARCHAR2(64) | YES | The name of wait event parameter 3. |
| WAIT_CLASS_ID | NUMBER(38) | YES | The ID of the class to which the wait event belongs. |
| WAIT_CLASS | VARCHAR2(64) | YES | The name of the class to which the wait event belongs. |
The WAIT_CLASS column in the view contains the names of the wait event classes and their corresponding IDs as shown in the following table.
Class Name |
Class ID |
Description |
|---|---|---|
| OTHER | 100 | A wait event that does not belong to any other class. |
| 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's command input. |
| CONCURRENCY | 104 | A wait event for internal database resources. |
| COMMIT | 105 | A wait event related to log submission. |
| 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 names of tenant-level wait events that have been persisted for the current tenant and display the first record.
obclient [SYS]> SELECT * FROM SYS.DBA_WR_EVENT_NAME WHERE ROWNUM = 1;
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 row in set