VIEW: SYS.INT$DBA_HIST_MEM_TGT_ADVICE

Source

View Text - Preformatted

select mem.snap_id, mem.dbid, mem.instance_number,
       memory_size, memory_size_factor,
       estd_db_time, estd_db_time_factor, version,
       decode(mem.con_dbid, 0, mem.dbid, mem.con_dbid),
       0 con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_MEMORY_TARGET_ADVICE mem
  where     sn.snap_id         = mem.snap_id
        and sn.dbid            = mem.dbid
        and sn.instance_number = mem.instance_number

View Text - HTML Formatted

SELECT MEM.SNAP_ID
, MEM.DBID
, MEM.INSTANCE_NUMBER
, MEMORY_SIZE
, MEMORY_SIZE_FACTOR
, ESTD_DB_TIME
, ESTD_DB_TIME_FACTOR
, VERSION
, DECODE(MEM.CON_DBID
, 0
, MEM.DBID
, MEM.CON_DBID)
, 0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_MEMORY_TARGET_ADVICE MEM
WHERE SN.SNAP_ID = MEM.SNAP_ID
AND SN.DBID = MEM.DBID
AND SN.INSTANCE_NUMBER = MEM.INSTANCE_NUMBER