V$EVENTMETRIC definition in Oracle Database 11.2
V$EVENTMETRIC

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')

home |  up