select wait_class_id, -- WAIT_CLASS_ID NUMBER wait_class#, -- WAIT_CLASS# NUMBER wait_class, -- WAIT_CLASS VARCHAR2(64) total_waits, -- TOTAL_WAITS NUMBER time_waited, -- TIME_WAITED NUMBER total_waits_fg, -- TOTAL_WAITS_FG NUMBER time_waited_fg -- TIME_WAITED_FG NUMBER from gv$system_wait_class where inst_id = USERENV('Instance')