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')