Note
This view is introduced since OceanBase Database V4.2.2.
Purpose
The DBA_WR_SYSTEM_EVENT view displays information about persisted tenant-level wait events in the current tenant.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SNAP_ID | NUMBER(38) | No | The ID of the snapshot. |
| SVR_IP | VARCHAR2(46) | No | The IP address of the server. |
| SVR_PORT | NUMBER(38) | No | The port number of the server. |
| EVENT_ID | NUMBER(38) | No | The ID of the wait event. |
| EVENT_NAME | VARCHAR2(64) | Yes | The name of the wait event. |
| WAIT_CLASS_ID | NUMBER(38) | Yes | The ID of the wait event class. |
| WAIT_CLASS | VARCHAR2(64) | Yes | The name of the wait event class. |
| TOTAL_WAITS | NUMBER(38) | Yes | The total number of waits for the event. |
| TOTAL_TIMEOUTS | NUMBER(38) | Yes | The total number of timeouts of the wait event. |
| TIME_WAITED_MICRO | NUMBER(38) | Yes | The total wait time of the event. |
The following table describes the class and ID of the wait event in the WAIT_CLASS column of the view.
Event class |
Event ID |
Description |
|---|---|---|
| OTHER | 100 | The wait event that does not belong to any other types described in the table. |
| APPLICATION | 101 | The wait event caused by client code. |
| CONFIGURATION | 102 | The wait event caused by insufficient database or instance resources. |
| ADMINISTRATIVE | 103 | The wait event caused by the command entered by the database administrator. |
| CONCURRENCY | 104 | The wait event that waited for internal resources of the database. |
| COMMIT | 105 | The wait event related to log commit. |
| IDLE | 106 | The wait event that waited for the task execution in an idle session. |
| NETWORK | 107 | The wait event related to network communication. |
| USER_IO | 108 | The wait event that waited for user I/O requests. |
| SYSTEM_IO | 109 | The wait event that waited for I/O requests of the background process. |
| CLUSTER | 111 | The wait event related to the cluster. |
Example
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