GV$WAITCLASSMETRIC_HISTORYSELECT inst_id, -- INST_ID NUMBER begtime, -- BEGIN_TIME DATE endtime, -- END_TIME DATE intsize_csec, -- INTSIZE_CSEC NUMBER wait#, -- WAIT_CLASS# NUMBER wait_id, -- WAIT_CLASS_ID NUMBER average_waiter_count, -- AVERAGE_WAITER_COUNT NUMBER dbtime_in_wait, -- DBTIME_IN_WAIT NUMBER time_waited, -- TIME_WAITED NUMBER wait_count -- WAIT_COUNT NUMBER FROM x$kewmevmv WHERE GROUPID = 1