SELECT 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 time_waited_fg, -- TIME_WAITED_FG NUMBER wait_count_fg -- WAIT_COUNT_FG NUMBER FROM x$kewmevmv WHERE flag1 = 1 AND GROUPID = 0