select s.inst_id, -- INST_ID NUMBER s.kswsclstabnm, -- SERVICE_NAME VARCHAR2(64) s.kswsclstabnmh, -- SERVICE_NAME_HASH NUMBER s.kswsclsid, -- WAIT_CLASS_ID NUMBER s.kswsclsnum, -- WAIT_CLASS# NUMBER s.kswsclsname, -- WAIT_CLASS VARCHAR2(64) s.kswsclswts, -- TOTAL_WAITS NUMBER round(s.kswsclstim / 10000) -- TIME_WAITED NUMBER from x$kswsclstab s where s.kswsclswts != 0