Note
- This view is available starting with V4.3.5 for V4.3.x.
- This view is available starting with V4.2.2 for V4.2.x.
Purpose
This view DBA_WR_SYSTEM_EVENT displays the persistent tenant-level wait events of the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SNAP_ID | NUMBER(38) | NO | The snapshot ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the node. |
| EVENT_ID | NUMBER(38) | NO | The wait event ID. |
| EVENT_NAME | VARCHAR2(64) | YES | The name of the wait event. |
| WAIT_CLASS_ID | NUMBER(38) | YES | The ID of the wait event category to which the wait event belongs. |
| WAIT_CLASS | VARCHAR2(64) | YES | The name of the wait event category to which the wait event belongs. |
| TOTAL_WAITS | NUMBER(38) | YES | The total number of wait events. |
| TOTAL_TIMEOUTS | NUMBER(38) | YES | The total number of timeouts. |
| TIME_WAITED_MICRO | NUMBER(38) | YES | The total wait time. |
The values of the WAIT_CLASS column in this view indicate the wait event categories and their corresponding IDs, as shown in the following table.
| Wait event category | ID | Description |
|---|---|---|
| OTHER | 100 | A wait event that does not belong to any other category. |
| 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 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 a cluster. |
Sample query
Query the persistent tenant-level wait events of the current tenant and display the first 10 records.
obclient [SYS]> SELECT * FROM SYS.DBA_WR_SYSTEM_EVENT WHERE ROWNUM = 1;
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 |
+---------+----------------+----------+----------+---------------------------------+---------------+-------------+-------------+----------------+-------------------+
| 27 | 172.xx.xxx.xxx | 2882 | 2 | latch: default spin rwlock wait | 104 | CONCURRENCY | 35 | 0 | 22996 |
+---------+----------------+----------+----------+---------------------------------+---------------+-------------+-------------+----------------+-------------------+
1 row in set