GV$EVENTMETRIC definition in Oracle Database 11.2
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
  time_waited_fg,                          -- TIME_WAITED_FG NUMBER
  wait_count_fg                            -- WAIT_COUNT_FG NUMBER
FROM
  x$kewmevmv
WHERE
  flag1 = 1 AND GROUPID = 0

home |  up