v$session_wait


select SID, SEQ#, EVENT, P1, P1TEXT, rawtohex(P1RAW) P1R, P2TEXT, P2,
          rawtohex(P2RAW) P2R, P3TEXT, P3, rawtohex(P3RAW) P3R, WAIT_TIME TIME,
          SECONDS_IN_WAIT SECS, STATE from v$session_wait;

SID SEQ# EVENT                         P1 P1TEXT     P1R              P2TEXT   P2 P2R              P3T  P3 P3R TIME  SECS STATE
--- ---- -------------------- ----------- ---------- ---------------- ------- --- ---------------- --- --- --- ---- ----- -------------------
  1  731 pmon timer                   300 duration   000000000000012C           0 00                     0 00     0  2191 WAITING
  2  812 rdbms ipc message            300 timeout    000000000000012C           0 00                     0 00     0  2164 WAITING
  3  807 rdbms ipc message            300 timeout    000000000000012C           0 00                     0 00     0  2170 WAITING
  5    6 rdbms ipc message         180000 timeout    000000000002BF20           0 00                     0 00     0  2128 WAITING
  4  102 smon timer                   300 sleep time 000000000000012C failed    0 00                     0 00     0    87 WAITING
  6  813 SQL*Net message from  3226733312 driver id  00000000C0540B00 #bytes    1 0000000000000001       0 00     2     0 WAITED KNOWN TIME
          client

SQL> 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_TIME                                NUMBER
SECONDS_IN_WAIT                          NUMBER
STATE                                    VARCHAR2(19)

set heading on
set pagesize 100
set linesize 150
set feedback on

column SECS format 9999
column TIME format 999
column SEQ#   format 999
column SID    format 99
column P1     format 9999999999
column P1TEXT format A10
column P1R    format A16
column P2     format 99
column P2R    format A16
column P2TEXT format A7
column P3     format 99
column P3R    format A3
column P3TEXT format A3
column EVENT  format A20


select SID,
          SEQ#,
          EVENT,
          P1,
          P1TEXT,
          rawtohex(P1RAW) P1R,
          P2TEXT,
          P2,
          rawtohex(P2RAW) P2R,
          P3TEXT,
          P3,
          rawtohex(P3RAW) P3R,
          WAIT_TIME TIME,
          SECONDS_IN_WAIT SECS,
          STATE
from
           v$session_wait;


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