VIEW: SYS.INT$DBA_HIST_DB_CACHE_ADVICE

Source

View Text - Preformatted

select db.snap_id, db.dbid, db.instance_number,
       bpid, buffers_for_estimate,
       name, block_size, advice_status, size_for_estimate,
       size_factor, physical_reads, base_physical_reads,
       actual_physical_reads, estd_physical_read_time,
       decode(db.con_dbid, 0, db.dbid, db.con_dbid),
       0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_DB_CACHE_ADVICE db
where      db.snap_id          = sn.snap_id
      and  db.dbid             = sn.dbid
      and  db.instance_number  = sn.instance_number

View Text - HTML Formatted

SELECT DB.SNAP_ID
, DB.DBID
, DB.INSTANCE_NUMBER
, BPID
, BUFFERS_FOR_ESTIMATE
, NAME
, BLOCK_SIZE
, ADVICE_STATUS
, SIZE_FOR_ESTIMATE
, SIZE_FACTOR
, PHYSICAL_READS
, BASE_PHYSICAL_READS
, ACTUAL_PHYSICAL_READS
, ESTD_PHYSICAL_READ_TIME
, DECODE(DB.CON_DBID
, 0
, DB.DBID
, DB.CON_DBID)
, 0 CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_DB_CACHE_ADVICE DB WHERE DB.SNAP_ID = SN.SNAP_ID
AND DB.DBID = SN.DBID
AND DB.INSTANCE_NUMBER = SN.INSTANCE_NUMBER