SELECT * FROM v$session_wait;
SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SECONDS_IN STATE
---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- -------- ---------------------------------------------------------------- ---------- -------- ---------------------------------------------------------------- ---------- -------- ---------- ---------- -------------------
1 47117 pmon timer duration 300 0000012C 0 00 0 00 0 22 WAITING
2 1100 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 105 WAITING
3 1205 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 135 WAITING
6 26 rdbms ipc message timeout 180000 0002BF20 0 00 0 00 0 1306 WAITING
4 2125 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 0 WAITING
5 3876 smon timer sleep time 300 0000012C failed 0 00 0 00 0 77 WAITING
9 29 SQL*Net message from client driver id 1111838976 42455100 #bytes 1 00000001 0 00 -2 0 WAITED UNKNOWN TIME