VIEW: SYS.INT$DBA_HIST_SYSMETRIC_SUMMARY

Source

View Text - Preformatted

select m.snap_id, m.dbid, m.instance_number,
       begin_time, end_time, intsize,
       m.group_id, m.metric_id, mn.metric_name, mn.metric_unit,
       num_interval, minval, maxval, average, standard_deviation, sum_squares,
       decode(m.con_dbid, 0, m.dbid, m.con_dbid),
       0 con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_SYSMETRIC_SUMMARY m, WRH$_METRIC_NAME mn
  where     m.group_id         = mn.group_id
        and m.metric_id        = mn.metric_id
        and m.dbid             = mn.dbid
        and sn.snap_id         = m.snap_id
        and sn.dbid            = m.dbid
        and sn.instance_number = m.instance_number

View Text - HTML Formatted

SELECT M.SNAP_ID
, M.DBID
, M.INSTANCE_NUMBER
, BEGIN_TIME
, END_TIME
, INTSIZE
, M.GROUP_ID
, M.METRIC_ID
, MN.METRIC_NAME
, MN.METRIC_UNIT
, NUM_INTERVAL
, MINVAL
, MAXVAL
, AVERAGE
, STANDARD_DEVIATION
, SUM_SQUARES
, DECODE(M.CON_DBID
, 0
, M.DBID
, M.CON_DBID)
, 0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SYSMETRIC_SUMMARY M
, WRH$_METRIC_NAME MN
WHERE M.GROUP_ID = MN.GROUP_ID
AND M.METRIC_ID = MN.METRIC_ID
AND M.DBID = MN.DBID
AND SN.SNAP_ID = M.SNAP_ID
AND SN.DBID = M.DBID
AND SN.INSTANCE_NUMBER = M.INSTANCE_NUMBER