V$SESSION_WAIT_HISTORY

Last Updated:2026-09-03 07:27:35

Note

This view is introduced since OceanBase Database V1.4.

Purpose

The V$SESSION_WAIT_HISTORY view displays the latest 10 wait events of all sessions on the current OBServer node.

Columns

Column	Type	Nullable?	Description
SID	bigint(20)	NO	For V4.3.x: Before V4.3.5 BP2: In all connection modes (direct mode/ODP mode), this field indicates the server session ID. V4.3.5 BP2 and later versions: In direct mode: This field indicates the server session ID. In ODP mode: When the ODP parameter `client_session_id_version = 2`, this field indicates the client session ID. When `client_session_id_version = 1`, this field indicates the server session ID.
CON_ID	bigint(20)	NO	The ID of the tenant.
SVR_IP	varchar(46)	NO	The IP address of the OBServer node.
SVR_PORT	bigint(20)	NO	The port number of the OBServer node.
SEQ#	bigint(20)	NO	The sequence number of the wait event.
EVENT#	bigint(20)	NO	The number of the wait event.
EVENT	varchar(64)	NO	The name of the wait event.
P1TEXT	varchar(64)	NO	The description of the first parameter of the wait event.
P1	bigint(20) unsigned	NO	The value of the first parameter of the wait event.
P2TEXT	varchar(64)	NO	The description of the second parameter of the wait event.
P2	bigint(20) unsigned	NO	The value of the second parameter of the wait event.
P3TEXT	varchar(64)	NO	The description of the third parameter of the wait event.
P3	bigint(20) unsigned	NO	The value of the third parameter of the wait event.
WAIT_TIME	double	NO	The wait time of the wait event, in hundredths of a second.
WAIT_TIME_MICRO	bigint(20)	NO	The wait time of the wait event, in microseconds.
TIME_SINCE_LAST_WAIT_MICRO	bigint(20)	NO	The amount of time in microseconds elapsed from the end of the last wait to the current wait.

Sample query

Query the details of all current session wait events on the current node, including the most recent 10 wait events.

obclient [oceanbase]> SELECT * FROM oceanbase.V$SESSION_WAIT_HISTORY LIMIT 1\G

The query result is as follows:

*************************** 1. row ***************************
                       SID: 3221608040
                    CON_ID: 1
                    SVR_IP: xx.xx.xx.xx
                  SVR_PORT: 2882
                      SEQ#: 1
                    EVENT#: 0
                     EVENT:
                    P1TEXT:
                        P1: 0
                    P2TEXT:
                        P2: 0
                    P3TEXT:
                        P3: 0
                 WAIT_TIME: 174572146997.0574
           WAIT_TIME_MICRO: 1745721469970574
TIME_SINCE_LAST_WAIT_MICRO: 0

Previous topic

V$SESSION_WAIT

Last

Next topic

V$SESSTAT