In this article i will show how we leveraged DB Cache Advice Statistics in tuning our Buffer Pool. We had to size the SGA/Buffer Pool for a huge conversion activity which we had to perform, based on buffer pool stats you can make a decision on sizing(approx) your buffer pool.
Below is an example of DB_CACHE_ADVICE data
select size_for_estimate,
estd_physical_reads
from v$db_cache_advice
In the above example you can notice that by increasing the Buffer Pool size from 1.2G to 2.6G the Estimated Physical reads reduced from 91M to 49M which is approx 50%. However note that this is the not the end of tuning this is one of the step in tuning your instance.
References
