性能诊断与调优之V$--V$SESSION_WAIT

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,

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