unset avail_mem
SELECT ca8.size_for_estimate          sfe8, ca32.size_for_estimate          sfe32,
       ca8.size_factor                 sf8, ca32.size_factor                 sf32,
       ca8.estd_physical_read_factor eprf8, ca32.estd_physical_read_factor eprf32,
       ca8.estd_physical_reads        epr8, ca32.estd_physical_reads        epr32,
       ca8.estd_physical_reads            + ca32.estd_physical_reads    totalreads,
       ca8.size_for_estimate              + ca32.size_for_estimate      totalsize
  FROM V$DB_CACHE_ADVICE ca8,               v$db_cache_advice ca32
 where ca8.block_size = 8192            and ca32.block_size = 32768
   and ca8.size_for_estimate              + ca32.size_for_estimate < &&avail_mem+1000
   and ca8.size_for_estimate              + ca32.size_for_estimate > &&avail_mem-1000
  and (ca8.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
/
