V$SESSION_WAIT View
The V$SESSION_WAIT view provides detailed information about the event or resource that each session is waiting for. This view contains only one row of information per session, active or inactive,
The V$SESSION_WAIT view provides detailed information about the event or resource that each session is waiting for. This view contains only one row of information per session, active or inactive,
at any given time. Unlike the other views, this view displays session-level wait information in real time. Because of this, it may very well show different results each time you query the view.
V$SESSION_WAIT 视图记录了每个session等待事件或资源的详细信息,每个session在视图中只记录一条记录。包括 active和inactive两种状态,与其他动态性能视图不同的是,该视图中的信息
是实时的,所以每次查询 的结果可能就不一样。
该视图的表结构如下:
SQL> desc v$session_wait
Name Type Nullable Default Comments
--------------- ------------ -------- ------- --------
SID NUMBER Y
SEQ# NUMBER Y
EVENT VARCHAR2(64) Y
P1TEXT VARCHAR2(64) Y
P1 NUMBER Y
P1RAW RAW(4) Y
P2TEXT VARCHAR2(64) Y
P2 NUMBER Y
P2RAW RAW(4) Y
P3TEXT VARCHAR2(64) Y
P3 NUMBER Y
P3RAW RAW(4) Y
WAIT_CLASS_ID NUMBER Y Starting Oracle10g
WAIT_CLASS# NUMBER Y Starting Oracle10g
WAIT_CLASS V