-- -- Display DB Cache Advice in Readable Format -- -- Note that a + number in the PCT columns is the pct increase. -- A - number in the PCT columns is the pct decrease. -- col SIZE_FOR_ESTIMATE head SIZE_FOR|EST_MB col SIZE_FACTOR head SIZE|FACTOR format 99.99 col ESTD_PHYSICAL_READ_FACTOR head EST_PHY|READ_FACT format 99.99 col ESTD_PCT_OF_DB_TIME_FOR_READS head ESTD_PCT|DB_TIME set linesize 132 select SIZE_FOR_ESTIMATE as "Cache Size in MB" ,SIZE_FACTOR * 100 as "Pct of Current Buffer Cache" ,floor((ESTD_PHYSICAL_READ_FACTOR * 100)-100) as "Pct Increase/Decrease in Physical Reads" ,ESTD_PCT_OF_DB_TIME_FOR_READS as "Pct Increase/Decrease in Time of Physical Reads" from V$DB_CACHE_ADVICE WHERE name = 'DEFAULT' AND block_size = (SELECT value FROM V$PARAMETER WHERE name = 'db_block_size') AND advice_status = 'ON' order by 1 /