GV$SYSMETRIC_HISTORY definition in Oracle Database 11.2
GV$SYSMETRIC_HISTORY

SELECT
  inst_id,                                 -- INST_ID NUMBER
  begtime,                                 -- BEGIN_TIME DATE
  endtime,                                 -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  groupid,                                 -- GROUP_ID NUMBER
  metricid,                                -- METRIC_ID NUMBER
  name,                                    -- METRIC_NAME VARCHAR2(64)
  value,                                   -- VALUE NUMBER
  unit                                     -- METRIC_UNIT VARCHAR2(64)
FROM
  x$kewmdrmv
WHERE
  groupid in (2,3)

home |  up