GV$SERVICE_WAIT_CLASS
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 -- TIME_WAITED NUMBER (s.kswsclstim / 10000) from x$kswsclstab s where s.kswsclswts != 0

home |  up  |  mailbox