Knowledgebase

Oracle - SUN kernel resources configuration

The following should be specified in /etc/system file for Oracle database.
After changing the server needs to be restarted.

minimum recomended values:
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

SEMMNS ?.. total numbers of semaphores ?.. recommended value is sum of amount of processes for all oracle instances + maximum number from amount of processes for all Oracle instances + 10 for each instance

SEMMSL number of semaphores in one semaphore set ?.. should be at least the maximum number of processes for instance.

More information on
http://technet.oracle.com/doc/solaris/server.805/install/2pre.htm#775341