Hello,
we have upgraded our oracle server to 128GB RAM. What is the best size to set SHMALL and SHMMAX? We only have one db instance running and oracle can use up to 112GB so that 16GB are left for the OS linux. The oracle DB is 11.2.0.4 and the OS is Redhat Enterprise 7.2.
I set SHMMAX to 112GB and SHMALL to SHMMAX/PAGESIZE in /etc/sysctl.conf:
kernel.shmmax = 120259084288
kernel.shmall = 29360128
The pagesize is 4096.
Are these good values for 128GB RAM or is there anything I overlook?
I want to use automatic memory management in Oracle and as far as I know I have to set memory_target to the same size as memory_max_size. Is there nothing to be said against setting the size to 112GB?
What about the values for sga_max_size and sga_target?