oracle session_wait,40.Oracle雜記——Oracle常用動態視圖v$session_wait

40.Oracle雜記——Oracle常用動態視圖v$session_wait

視圖v$session_wait顯示每個會話當前后最后等待。

視圖描述如下：

sys@PDB1> desc v$session_wait;

Name                                                                  Null?    Type

------------------------------------------------------------- ------------------------------------

SID                                                                           NUMBER

SEQ#                                                                                 NUMBER

EVENT                                                                               VARCHAR2(64)

P1TEXT                                                                 VARCHAR2(64)

P1                                                                             NUMBER

P1RAW                                                                             RAW(8)

P2TEXT                                                                 VARCHAR2(64)

P2                                                                             NUMBER

P2RAW                                                                             RAW(8)

P3TEXT                                                                 VARCHAR2(64)

P3                                                                             NUMBER

P3RAW                                                                             RAW(8)

WAIT_CLASS_ID                                                                     NUMBER

WAIT_CLASS#                                                                          NUMBER

WAIT_CLASS                                                                  VARCHAR2(64)

WAIT_TIME                                                                   NUMBER

SECONDS_IN_WAIT                                                              NUMBER

STATE                                                                               VARCHAR2(19)

WAIT_TIME_MICRO                                                             NUMBER

TIME_REMAINING_MICRO                                                          NUMBER

TIME_SINCE_LAST_WAIT_MICRO                                             NUMBER

CON_ID                                                                           NUMBER

各個列的描述如下：

SID：會話ID

SEQ#：當前或上次等待的數量

EVENT：會話等待的資源或事件

P1TEXT：第一個等待事件參數的描述

P1：第一個等待事件參數(十進制)

P1RAW：第一個等待事件參數(十六進制)

P2TEXT：第2個等待事件參數的描述

P2：第2個等待事件參數(十進制)

P2RAW：第2個等待事件參數(十六進制)

P3TEXT：第3個等待事件參數的描述

P3：第3個等待事件參數(十進制)

P3RAW：第3個等待事件參數(十六進制)

WAIT_CLASS_ID：等待事件類ID

WAIT_CLASS#：等待事件類號

WAIT_CLASS   ：等待事件類名字

WAIT_TIME：如果會話正在等待，那么值為0，如果會話不在等待，那么值為>0,-1,-2.

SECONDS_IN_WAIT：如果會話正在等待，這個值是總計

STATE：等待狀態

WAIT_TIME_MICRO：等待時間的總計。如果會話在正在等待，那么值就是當前等待花費的時間，如果會話不在等待，那么這個值就是上次等待時間總和

TIME_REMAINING_MICRO：有4個值，>0,0,-1,NULL. >0 當前等待需要的時間，0 等待超時，-1 當前等待無限期，NULL會話沒有在等待

TIME_SINCE_LAST_WAIT_MICRO  ：上次等待結束后流逝的時間

CON_ID ：容器ID