select
  sid,                                     -- SID NUMBER
  seq#,                                    -- SEQ# NUMBER
  event#,                                  -- EVENT# NUMBER
  event,                                   -- EVENT VARCHAR2(64)
  p1text,                                  -- P1TEXT VARCHAR2(64)
  p1,                                      -- P1 NUMBER
  p2text,                                  -- P2TEXT VARCHAR2(64)
  p2,                                      -- P2 NUMBER
  p3text,                                  -- P3TEXT VARCHAR2(64)
  p3,                                      -- P3 NUMBER
  wait_time,                               -- WAIT_TIME NUMBER
  wait_time_micro,                         -- WAIT_TIME_MICRO NUMBER
  time_since_last_wait_micro               -- TIME_SINCE_LAST_WAIT_MICRO NUMBER
from
  gv$session_wait_history
where
  inst_id = USERENV('Instance')