GV$SESSION_WAIT_HISTORY definition in Oracle 10g / www.oracledba.ru
GV$SESSION_WAIT_HISTORY
select
s.inst_id, -- INST_ID NUMBER
s.ksusehsnum, -- SID NUMBER
s.ksusehwnum, -- SEQ# NUMBER
s.ksusehopc, -- EVENT# NUMBER
s.ksusehname, -- EVENT VARCHAR2(64)
s.ksusehp1text, -- P1TEXT VARCHAR2(64)
s.ksusehp1, -- P1 NUMBER
s.ksusehp2text, -- P2TEXT VARCHAR2(64)
s.ksusehp2, -- P2 NUMBER
s.ksusehp3text, -- P3TEXT VARCHAR2(64)
s.ksusehp3, -- P3 NUMBER
round -- WAIT_TIME NUMBER
(s.ksusehwtm/10000),
s.ksusehcnt -- WAIT_COUNT NUMBER
from
x$ksuseh s