oracle 11g: increasing buffer cache with AMM

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

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

cx_Oracle high memory use

Updated June 07, 2019 15:06 PM