Hi
According to Oracle doc if I query
select SIZE_FOR_ESTIMATE, BUFFERS_FOR_ESTIMATE, STD_PHYSICAL_READS
from v$db_cache_advice
where name='DEFAULT'
and block_size=(select values v$parameter where name='db_block_size')
and advice_status='ON';
it will allow me to predict buffer pool for various cache size.
But block_size and advice_status is not a valid column in v$db_cache_advice view. What to do????????
2ndly If I query only
select SIZE_FOR_ESTIMATE, BUFFERS_FOR_ESTIMATE, STD_PHYSICAL_READS
from v$db_cache_advice
where name='DEFAULT';
the I am always getting value "0" for STD_PHYSICAL_READS
columns. How to get non zero , actual , values.
Can anybody help me.
Thanks