column sfe8   heading "Cache Size|(8kb)  (M)"
column sfe16  heading "Cache Size|(16kb) (M)"
column sfe32  heading "Cache Size|(32kb) (M)"
column sf8    heading "Size Factor|(8kb)"
column sf16   heading "Size Factor|(16kb)"
column sf32   heading "Size Factor|(32kb)"
column eprf8  heading "Estd Read|Factor (8k)"
column eprf16 heading "Estd Read|Factor(16k)"
column eprf32 heading "Estd Read|Factor(32k)"
column epr8   heading "Phys Reads|(8k)"
column epr16  heading "Phys Reads|(16k)"
column epr32  heading "Phys Reads|(32k)"

SELECT ca8.size_for_estimate          sfe8, ca16.size_for_estimate          sfe16, ca32.size_for_estimate          sfe32,
       ca8.size_factor                 sf8, ca16.size_factor                 sf16, ca32.size_factor                 sf32,
       ca8.estd_physical_read_factor eprf8, ca16.estd_physical_read_factor eprf16, ca32.estd_physical_read_factor eprf32,
       ca8.estd_physical_reads        epr8, ca16.estd_physical_reads        epr16, ca32.estd_physical_reads        epr32,
       ca8.estd_physical_reads            + ca16.estd_physical_reads             + ca32.estd_physical_reads    totalreads
  FROM V$DB_CACHE_ADVICE ca8,               v$db_cache_advice ca16,                v$db_cache_advice ca32
 where ca8.block_size = 8192            and ca16.block_size = 16384            and ca32.block_size = 32768
   and ca8.size_for_estimate              + ca16.size_for_estimate               + ca32.size_for_estimate < &avail_mem+1000
   and ca8.size_for_estimate              + ca16.size_for_estimate               + ca32.size_for_estimate > &avail_mem-1000
  and (ca8.estd_physical_reads            + ca16.estd_physical_reads             + ca32.estd_physical_reads)
       <= (select sum(estd_physical_reads) from v$db_cache_advice where estd_physical_read_factor = 1)
order by totalreads desc
/
