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
home |  up  |  mailbox