GV$EVENTMETRIC

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
FROM
x$kewmevmv 
WHERE
flag1 = 1 AND GROUPID = 0
home |  up  |  mailbox