Note
This view is available starting with V1.4.
Purpose
This view displays information about the current or previous wait events for all sessions in the current tenant across all OBServer nodes. The information includes the wait event name, wait time, and other relevant details.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SID | NUMBER | NO | For V4.2.x versions:
|
| CON_ID | NUMBER | NO | Tenant ID |
| SVR_IP | VARCHAR2(46) | NO | Server IP address |
| SVR_PORT | NUMBER(38) | NO | Server port |
| EVENT | VARCHAR2(64) | NO | Name of the wait event |
| P1TEXT | VARCHAR2(64) | NO | Description of the first parameter of the wait event |
| P1 | NUMBER | NO | Value of the first parameter of the wait event |
| P2TEXT | VARCHAR2(64) | NO | Description of the second parameter of the wait event |
| P2 | NUMBER | NO | Value of the second parameter of the wait event |
| P3TEXT | VARCHAR2(64) | NO | Description of the third parameter of the wait event |
| P3 | NUMBER(38) | NO | Value of the third parameter of the wait event |
| WAIT_CLASS_ID | NUMBER | NO | ID of the wait event category |
| WAIT_CLASS# | NUMBER | NO | Sequence number of the wait event category |
| WAIT_CLASS | VARCHAR2(64) | NO | Name of the wait event category |
| STATE | VARCHAR2(19) | NO | Current state of the wait event. The state can be one of the following: |
| WAIT_TIME_MICRO | NUMBER | NO | Wait time in microseconds. If the session is currently waiting, this column displays the duration of the wait so far. If the session is not waiting, this column displays the total wait time of the last wait event. |
| TIME_REMAINING_MICRO | NUMBER | NO | |
| TIME_SINCE_LAST_WAIT_MICRO | NUMBER | NO | Time elapsed since the last wait event ended, in microseconds. If the session is currently waiting, this column displays 0. |
Sample query
Query the details of the current or previous wait events for the current tenant across all nodes, and display the first two records.
obclient [SYS]> SELECT * FROM SYS.GV$SESSION_WAIT WHERE ROWNUM <=2\G
The query result is as follows:
*************************** 1. row ***************************
SID: 3221561745
CON_ID: 1004
SVR_IP: 11.xxx.xxx.xxx
SVR_PORT: 28825
EVENT: wait in request queue
P1TEXT: pcode
P1: 0
P2TEXT: level
P2: 0
P3TEXT: priority
P3: 0
WAIT_CLASS_ID: 102
WAIT_CLASS#: 2
WAIT_CLASS: CONFIGURATION
STATE: WAITED SHORT TIME
WAIT_TIME_MICRO: 18
TIME_REMAINING_MICRO: -1
TIME_SINCE_LAST_WAIT_MICRO: -98896269941982083
*************************** 2. row ***************************
SID: -9223372036854723648
CON_ID: 1004
SVR_IP: 11.xxx.xxx.xxx
SVR_PORT: 28825
EVENT: latch: palf handle impl lock wait
P1TEXT: address
P1: 139727583928432
P2TEXT: number
P2: 1074026206
P3TEXT: tries
P3: 17
WAIT_CLASS_ID: 11.xxx.xxx.xxx
WAIT_CLASS#: 4
WAIT_CLASS: CONCURRENCY
STATE: WAITED SHORT TIME
WAIT_TIME_MICRO: 26
TIME_REMAINING_MICRO: NULL
TIME_SINCE_LAST_WAIT_MICRO: -96979328468187015
2 rows in set
References
- For more information about wait events, see Common wait events.