Tuning of kernel.shmmax variable + Linux CentOS + Oracle 11gR2

Nov 24, 2009 10:23PM

Hello all,

I have a question regarding our Production Installation of Oracle 11gR2 :

we currently have the following settings in the / etc/sysctl.conf file:

# Controls the maximum shared segment size, in bytes

#kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages

#kernel.shmall = 4294967296

# Xscores Team

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

#kernel.shmmax = 536870912

kernel.shmmax = 1610612736

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

[root@db4 etc]#

I had my Team change to above shmmax value: Oracle Guidelines say that the

Database Tuning (MOSC)