GV$SESSION_WAIT_HISTORY definition in Oracle Database 11.2
GV$SESSION_WAIT_HISTORY

select
  s.inst_id,                               -- INST_ID NUMBER
  s.kslwhsid,                              -- SID NUMBER
  s.kslwhridx,                             -- SEQ# NUMBER
  s.kslwhevt,                              -- EVENT# NUMBER
  s.kslwhetext,                            -- EVENT VARCHAR2(64)
  s.kslwhp1text,                           -- P1TEXT VARCHAR2(64)
  s.kslwhp1,                               -- P1 NUMBER
  s.kslwhp2text,                           -- P2TEXT VARCHAR2(64)
  s.kslwhp2,                               -- P2 NUMBER
  s.kslwhp3text,                           -- P3TEXT VARCHAR2(64)
  s.kslwhp3,                               -- P3 NUMBER
  round(s.kslwhstime/10000),               -- WAIT_TIME NUMBER
  s.kslwhstime,                            -- WAIT_TIME_MICRO NUMBER
  s.kslwhltime                             -- TIME_SINCE_LAST_WAIT_MICRO NUMBER
from
  x$kslwh s

home |  up