GV$EVENTMETRICSELECT inst_id, -- INST_ID NUMBER begtime, -- BEGIN_TIME DATE endtime, -- END_TIME DATE intsize_csec, -- INTSIZE_CSEC NUMBER wait#, -- EVENT# NUMBER wait_id, -- EVENT_ID NUMBER nsess_wait, -- NUM_SESS_WAITING NUMBER time_waited, -- TIME_WAITED NUMBER wait_count -- WAIT_COUNT NUMBER FROM x$kewmevmv WHERE flag1 = 1 AND GROUPID = 0