SELECT
begin_time, -- BEGIN_TIME DATE
end_time, -- END_TIME DATE
intsize_csec, -- INTSIZE_CSEC NUMBER
event#, -- EVENT# NUMBER
event_id, -- EVENT_ID NUMBER
num_sess_waiting, -- 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
gv$eventmetric
WHERE
inst_id = USERENV('INSTANCE')