Note
- The view was introduced in V4.3.5 of V4.3.x.
- The view was introduced in V4.2.2 of V4.2.x.
Purpose
The DBA_WR_SYSTEM_EVENT view displays the tenant-level persistent wait events in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SNAP_ID | NUMBER(38) | NO | Snapshot ID |
| SVR_IP | VARCHAR2(46) | NO | Node IP |
| SVR_PORT | NUMBER(38) | NO | Node port |
| EVENT_ID | NUMBER(38) | NO | Wait event ID |
| EVENT_NAME | VARCHAR2(64) | YES | Wait event name |
| WAIT_CLASS_ID | NUMBER(38) | YES | ID of the wait event category |
| WAIT_CLASS | VARCHAR2(64) | YES | Name of the wait event category |
| TOTAL_WAITS | NUMBER(38) | YES | Total number of wait events |
| TOTAL_TIMEOUTS | NUMBER(38) | YES | Total number of timeouts |
| TIME_WAITED_MICRO | NUMBER(38) | YES | Total wait time |
The following table describes the wait event categories and their corresponding wait event IDs in the WAIT_CLASS column of the view. | Wait event category | Wait event ID | Description | |------|----|------| | OTHER | 100 | Wait events that do not belong to other categories | | APPLICATION | 101 | Wait events caused by client-side code | | CONFIGURATION | 102 | Wait events caused by insufficient database or instance resource configurations | | ADMINISTRATIVE | 103 | Wait events caused by commands entered by database administrators | | CONCURRENCY | 104 | Wait events caused by waiting for internal database resources | | COMMIT | 105 | Wait events related to log commit | | IDLE | 106 | Wait events caused by idle sessions waiting for tasks | | NETWORK | 107 | Wait events related to network communication | | USER_IO | 108 | Wait events caused by waiting for user I/O | | SYSTEM_IO | 109 | Wait events caused by waiting for I/O by background processes |
| CLUSTER | 111 | Wait events related to clusters|
Sample query
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