V$SESSION_WAIT definition in Oracle Database 11.2
V$SESSION_WAIT
select
sid, -- SID NUMBER
seq#, -- SEQ# NUMBER
event, -- EVENT VARCHAR2(64)
p1text, -- P1TEXT VARCHAR2(64)
p1, -- P1 NUMBER
p1raw, -- P1RAW RAW(8)
p2text, -- P2TEXT VARCHAR2(64)
p2, -- P2 NUMBER
p2raw, -- P2RAW RAW(8)
p3text, -- P3TEXT VARCHAR2(64)
p3, -- P3 NUMBER
p3raw, -- P3RAW RAW(8)
wait_class_id, -- WAIT_CLASS_ID NUMBER
wait_class#, -- WAIT_CLASS# NUMBER
wait_class, -- WAIT_CLASS VARCHAR2(64)
wait_time, -- WAIT_TIME NUMBER
seconds_in_wait, -- SECONDS_IN_WAIT NUMBER
state, -- STATE VARCHAR2(19)
wait_time_micro, -- WAIT_TIME_MICRO NUMBER
time_remaining_micro, -- TIME_REMAINING_MICRO NUMBER
time_since_last_wait_micro -- TIME_SINCE_LAST_WAIT_MICRO NUMBER
from
gv$session_wait
where
inst_id = USERENV('Instance')