GV$SYSTEM_WAIT_CLASS

select
s.inst_id,               -- INST_ID NUMBER
s.kslscsclsid,           -- WAIT_CLASS_ID NUMBER
s.kslscscls,             -- WAIT_CLASS# NUMBER
s.kslscsclsname,         -- WAIT_CLASS VARCHAR2(64)
s.kslscswts,             -- TOTAL_WAITS NUMBER
round                    -- TIME_WAITED NUMBER
  (s.kslscstim / 10000) 
from
x$kslscs s 
where
s.kslscswts != 0
home |  up  |  mailbox