V$SYSMETRIC_HISTORY definition in Oracle Database 11.2

V$SYSMETRIC_HISTORY

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)
  value,                                   -- VALUE NUMBER
  metric_unit                              -- METRIC_UNIT VARCHAR2(64)
FROM
  gv$sysmetric_history
WHERE
  inst_id = USERENV('INSTANCE')

home | up