Note
This view is available starting with V1.4.
Purpose
This view displays the information about the most recent 10 wait events for all sessions in the current OBServer node of the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SID | NUMBER | NO | For V4.2.x:
|
| CON_ID | NUMBER | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port of the server. |
| SEQ# | NUMBER | NO | The sequence number of the wait event. |
| EVENT# | NUMBER | NO | The event number. |
| EVENT | VARCHAR2(64) | NO | The name of the wait event. |
| P1TEXT | VARCHAR2(64) | NO | The description of the first parameter of the wait event. |
| P1 | NUMBER | NO | The value of the first parameter of the wait event. |
| P2TEXT | VARCHAR2(64) | NO | The description of the second parameter of the wait event. |
| P2 | NUMBER | NO | The value of the second parameter of the wait event. |
| P3TEXT | VARCHAR2(64) | NO | The description of the third parameter of the wait event. |
| P3 | NUMBER | NO | The value of the third parameter of the wait event. |
| WAIT_TIME_MICRO | NUMBER | NO | The wait time of the wait event, in microseconds. |
| TIME_SINCE_LAST_WAIT_MICRO | NUMBER | NO | The time elapsed since the last wait event ended, in microseconds. |
| WAIT_TIME | NUMBER | NO | The wait time of the wait event, in 1/100 seconds. |
Sample query
In the user tenant, query the information about the most recent 10 wait events for all sessions in the current OBServer node.
obclient [SYS]> SELECT * FROM SYS.V$SESSION_WAIT_HISTORY;
The query result is as follows:
+----------------------+--------+----------------+----------+------+--------+-------+--------+------+--------+------+--------+------+--------------------+------------------+----------------------------+
| SID | CON_ID | SVR_IP | SVR_PORT | SEQ# | EVENT# | EVENT | P1TEXT | P1 | P2TEXT | P2 | P3TEXT | P3 | WAIT_TIME | WAIT_TIME_MICRO | TIME_SINCE_LAST_WAIT_MICRO |
+----------------------+--------+----------------+----------+------+--------+-------+--------+------+--------+------+--------+------+--------------------+------------------+----------------------------+
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 1 | 0 | NULL | NULL | 0 | NULL | 0 | NULL | 0 | 174315119274.33609 | 1743151192743361 | 0 |
+----------------------+--------+----------------+----------+------+--------+-------+--------+------+--------+------+--------+------+--------------------+------------------+----------------------------+
1 row in set