V$SYSMETRIC_SUMMARY definition in Oracle Database 11.2
V$SYSMETRIC_SUMMARY

SELECT
  begin_time,                              -- BEGIN_TIME DATE
  end_time,                                -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  group_id,                                -- GROUP_ID NUMBER
  metric_id,                               -- METRIC_ID NUMBER
  metric_name,                             -- METRIC_NAME VARCHAR2(64)
  num_interval,                            -- NUM_INTERVAL NUMBER
  maxval,                                  -- MAXVAL NUMBER
  minval,                                  -- MINVAL NUMBER
  average,                                 -- AVERAGE NUMBER
  standard_deviation,                      -- STANDARD_DEVIATION NUMBER
  metric_unit                              -- METRIC_UNIT VARCHAR2(64)
FROM
  gv$sysmetric_summary
WHERE
  inst_id = USERENV('INSTANCE')

home |  up