v$session_event视图

SQL> conn system/** as sysdba;

SQL> desc v$session_event;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------

 SID                                                NUMBER
 EVENT                                              VARCHAR2(64)
 TOTAL_WAITS                                        NUMBER
 TOTAL_TIMEOUTS                                     NUMBER
 TIME_WAITED                                        NUMBER
 AVERAGE_WAIT                                       NUMBER
 MAX_WAIT                                           NUMBER
 TIME_WAITED_MICRO                                  NUMBER

SQL> select distinct SID from v$session_event;

       SID
----------
         1
         2
         3
         4
         5
         6
         7
         8

已选择8行。 

SQL> col SID format a5
SQL> col event format a35
SQL> col total_waits format a10
SQL> col total_timeouts format a10
SQL> col total_timeouts format a10
SQL> col time_waited format a10
SQL> col average_wait format a20

SQL> select SID,event,total_waits,total_timeouts,time_waited,average_wait from v$session_event where
 sid =8 order by time_waited desc
  2  /

       SID EVENT                               TOTAL_WAITS TOTAL_TIMEOUTS
---------- ----------------------------------- ----------- --------------
TIME_WAITED AVERAGE_WAIT
----------- ------------
########## SQL*Net message from client          ##########     ##########
 ##########   ##########

########## SQL*Net message to client            ##########     ##########
 ##########   ##########

SQL>

REFERENCE:   IXORA

http://www.ixora.com.au/q+a/waits.htm#end