GV$SESSION_WAIT_CLASS

select
s.inst_id,               -- INST_ID NUMBER
s.kslcssid,              -- SID NUMBER
s.kslcsser,              -- SERIAL# NUMBER
s.kslcsclsid,            -- WAIT_CLASS_ID NUMBER
s.kslcscls,              -- WAIT_CLASS# NUMBER
s.kslcsclsname,          -- WAIT_CLASS VARCHAR2(64)
s.kslcswts,              -- TOTAL_WAITS NUMBER
round                    -- TIME_WAITED NUMBER
  (s.kslcstim / 10000) 
from
x$kslcs s 
where
s.kslcswts != 0
home |  up  |  mailbox