oracle 11g: increasing buffer cache with AMM

by GID   Last Updated October 11, 2018 15:06 PM

On a 2-node RAC we have enabled Automatic Memory Management. The advisor views indicate that increasing the buffer cache by 4G will halve the physical reads, and we have 4G to give. How must we do this? By increasing memory_target and letting Oracle grab more memory for the buffer cache? Or by explicitly setting a value for db_cache_size (which now is zero)?

Tags : oracle memory

Related Questions

Updated March 01, 2018 06:06 AM

Updated May 04, 2015 21:02 PM

Updated October 11, 2018 14:06 PM

Updated August 29, 2018 08:06 AM

Updated June 29, 2015 16:02 PM