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




oracle 11g: increasing buffer cache with AMM

Updated October 11, 2018 14:06 PM

Oracle 12c Database swapping after set up huge pages

Updated August 29, 2018 08:06 AM

How do I limit Oracle's memory use?

Updated June 29, 2015 16:02 PM