Originally posted by newcomer

But block_size and advice_status is not a valid column in v$db_cache_advice view. What to do????????
Yes, they are:

SQL> desc v$db_cache_advice
Name
------------------------------------
ID
NAME
BLOCK_SIZE
ADVICE_STATUS
SIZE_FOR_ESTIMATE
BUFFERS_FOR_ESTIMATE
ESTD_PHYSICAL_READ_FACTOR
ESTD_PHYSICAL_READS