What parameters should be modified after upgrading RAM memory in Oracle server I have a linux server (rhel4) with oracle 9i (9.2.0.8) to which we have recently upgraded the RAM memory from 4G to 16G. I would like to know what server parameters I should modify and even more what Oracle parameters should I modify to make use of this new configuration from memory, thank you very much for your answers.
In 9i, multiple parameters are used for sizing components of the SGA. Below is a typical (but not complete) list:
DB_CACHE_SIZE
JAVA_POOL_SIZE
LARGE_POOL_SIZE
SHARED_POOL_SIZE
And SGA_MAX_SIZE, if set.
Also I assume for simplicity that you use automatic PGA management, so for PGA:
PGA_AGGREGATE_TARGET