dbashashi

 Profile Answers by dbashashi 

• Dec 2nd, 2010

 

You can take advantage of db_cache_advice in the parameter file. you can also use
v$db_cache_advice.
When using db_cache_advice = On; a proper caution is adviced as it can take some memory from Shared_pool will be affected which otherwise meant for same purpose