COLUMN name format a7

COLUMN block_size format 99,999 heading "Block|Size"

COLUMN size_for_estimate format 999,999,999,999 heading "Size|For|Estimate"

COLUMN size_factor format 99.99 heading "Size|Factor"

COLUMN estd_physical_reads format 999,999,999,999,999 heading "Estimated|Physical|Reads|(Smaller|is Better)"

COLUMN estd_physical_read_factor format 99.99 heading "Estimated|Physical|Read|Factor|(Smaller|is Better)"

SELECT NAME, block_size, size_for_estimate, size_factor,

estd_physical_reads, estd_physical_read_factor,

estd_physical_read_time

FROM v$db_cache_advice

WHERE NAME = 'DEFAULT'

ORDER BY size_for_estimate;