VIEW: SYS.INT$DBA_HIST_SERVICE_STAT

Source

View Text - Preformatted

select st.snap_id, st.dbid, st.instance_number,
       st.service_name_hash, sv.service_name,
       nm.stat_id, nm.stat_name, value,
       decode(st.con_dbid, 0, st.dbid, st.con_dbid),
       con_dbid_to_id(decode(st.con_dbid, 0, st.dbid, st.con_dbid)) con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_SERVICE_STAT st,
       WRH$_SERVICE_NAME sv, WRH$_STAT_NAME nm
  where    st.service_name_hash = sv.service_name_hash
      and  st.dbid              = sv.dbid
      and  st.stat_id           = nm.stat_id
      and  st.dbid              = nm.dbid
      and  st.snap_id           = sn.snap_id
      and  st.dbid              = sn.dbid
      and  st.instance_number   = sn.instance_number
      and  st.con_dbid          = sv.con_dbid

View Text - HTML Formatted

SELECT ST.SNAP_ID
, ST.DBID
, ST.INSTANCE_NUMBER
, ST.SERVICE_NAME_HASH
, SV.SERVICE_NAME
, NM.STAT_ID
, NM.STAT_NAME
, VALUE
, DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)
, CON_DBID_TO_ID(DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SERVICE_STAT ST
, WRH$_SERVICE_NAME SV
, WRH$_STAT_NAME NM
WHERE ST.SERVICE_NAME_HASH = SV.SERVICE_NAME_HASH
AND ST.DBID = SV.DBID
AND ST.STAT_ID = NM.STAT_ID
AND ST.DBID = NM.DBID
AND ST.SNAP_ID = SN.SNAP_ID
AND ST.DBID = SN.DBID
AND ST.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
AND ST.CON_DBID = SV.CON_DBID