v$session_event


select * from v$session_event order by SID, TIME_WAITED desc;

SID EVENT                          TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
--- ------------------------------ ----------- -------------- ----------- ------------
  1 pmon timer                             819            819      245761   300.074481
  2 db file sequential read                 10              0           0            0
  2 control file sequential read            65              0           1   .015384615
  2 db file parallel write                   3              0          15            5
  2 rdbms ipc message                      823            819      245687   298.526124
  3 log file sequential read                 4              0           0            0
  3 db file sequential read                 10              0           0            0
  3 control file sequential read            23              0           1   .043478261
  3 log file parallel write                  4              0          10          2.5
  3 log file single write                    4              0          13         3.25
  3 db file single write                    10              0          18          1.8
  3 control file parallel write             16              0          66        4.125
  3 rdbms ipc message                      824            819      245629   298.093447
  4 db file scattered read                  37              0          23   .621621622
  4 db file sequential read                 56              0          24   .428571429
  4 smon timer                              11              8      240447   21858.8182
  5 db file sequential read                  2              0           4            2
  5 rdbms ipc message                        3              3      186300        62100
  6 SQL*Net message to client              322              0           0            0
  6 log file sync                            1              0           1            1
  6 SQL*Net break/reset to client           21              0           3   .142857143
  6 db file sequential read                201              0         110   .547263682
  6 SQL*Net message from client            321              0      243405   758.271028


SQL> desc v$session_event;
 Name                            Null?    Type
 ------------------------------- -------- ----
 SID                                      NUMBER
 EVENT                                    VARCHAR2(64)
 TOTAL_WAITS                              NUMBER
 TOTAL_TIMEOUTS                           NUMBER
 TIME_WAITED                              NUMBER
 AVERAGE_WAIT                             NUMBER

set heading on
set pagesize 10000
set feedback on
column EVENT format A30;
column TOTAL_WAITS format 999999999
column TOTAL_TIMEOUTS format 999999999
column TIME_WAITED format 999999999
column AVERAGE_WAIT format 999999999.99
column sid format 999
select * from v$session_event order by SID, TIME_WAITED desc;


Questions or comments ? Send a note to khailey@fr.oracle.com