GV$SYSMETRIC_SUMMARY definition in Oracle Database 11.2
GV$SYSMETRIC_SUMMARY

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)
  numintv,                                 -- NUM_INTERVAL NUMBER
  max,                                     -- MAXVAL NUMBER
  min,                                     -- MINVAL NUMBER
  avg,                                     -- AVERAGE NUMBER
  std,                                     -- STANDARD_DEVIATION NUMBER
  unit                                     -- METRIC_UNIT VARCHAR2(64)
FROM
  x$kewmsmdv
WHERE
  groupid = 2

home |  up