GV$SESSION_WAIT_CLASSselect 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