VIEW: SYS.INT$DBA_HIST_SYSSTAT

Source

View Text - Preformatted

select s.snap_id, s.dbid, s.instance_number,
       s.stat_id, nm.stat_name, value,
       decode(s.con_dbid, 0, s.dbid, s.con_dbid),
       0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SYSSTAT s, WRH$_STAT_NAME nm
where      s.stat_id          = nm.stat_id
      and  s.dbid             = nm.dbid
      and  s.snap_id          = sn.snap_id
      and  s.dbid             = sn.dbid
      and  s.instance_number  = sn.instance_number

View Text - HTML Formatted

SELECT S.SNAP_ID
, S.DBID
, S.INSTANCE_NUMBER
, S.STAT_ID
, NM.STAT_NAME
, VALUE
, DECODE(S.CON_DBID
, 0
, S.DBID
, S.CON_DBID)
, 0 CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_SYSSTAT S
, WRH$_STAT_NAME NM WHERE S.STAT_ID = NM.STAT_ID
AND S.DBID = NM.DBID
AND S.SNAP_ID = SN.SNAP_ID
AND S.DBID = SN.DBID
AND S.INSTANCE_NUMBER = SN.INSTANCE_NUMBER