Solaris Kernel Configuration - Oracle

Solaris Kernel Configuration - Oracle

Sample Kernel Configuration:
Parameter Description Formula Value
SHMMAX Maximum Shared Memory Segment Size - 4,294,967,295
SHMMIN Minimum Shared Memory Segment Size - 1
SHMMNI Maximum Number of Shared Memory Identifers - 100
SHMSEG Maximum Number of Shared Memory Segments a user process can attach - 10
SEMMNI Maximum Number of Semaphore Identifiers - 100
SEMMSL Maximum Number of Semaphores in a Set 10 + max(P[db1],P[db2],…,P[dbn]) = 10 + max(350,35) = 10+ 350 = 360
SEMMNS Maximum Number of Semaphores in a System (P[db1] + P[db2] + … + P[dbn]) + max(P[db1],P[db2],…,P[dbn]) + 10 * count(P[db1],P[db2],…,P[dbn])
= (350+35) + max(350,35) + 10(2) = 385 + 350 + 20 = 755
SEMOPM Maximum Number of Operations per SEMOP call - 100
SEMVMX Semaphore Maximum Value - 32,767


Sample Databases:
Processes Value
P[db1] 350
P[db2] 35


Sample of /etc/system Parameter:
************************************************************************************
* B E G I N O R A C L E C O N F I G U R A T I O N
************************************************************************************

set shmsys: shminfo_shmmax = 4294967295

*
* Shared Memory Parameters - Static
*
set shmsys: shminfo_shmmin = 1
set shmsys: shminfo_shmmni = 100
set shmsys: shminfo_shmseg = 10
*
* Semaphore parameters - semmsl & semmns are dynamic:
*
* semmsl := 10 + max(P[db1],P[db2],...,P[dbn])
* semmns := (P[db1]+P[db2]+...+P[dbn]) + max(P[db1],P[db2],...,P[dbn]) + 10 * count (P[db1],P[db2],...,P[dbn])
*
* where P[dbX] is the processes parameter set for an Oracle database X
*
set semsys: seminfo_semmni = 100
set semsys: seminfo_semmsl = 360
set semsys: seminfo_semmns = 755
set semsys: seminfo_semopm = 100
set semsys: seminfo_semvmx = 32767

*
* Increase file descriptor limits (large databases)
*
set rlim_fd_max=8192
set rlim_fd_cur=1024

************************************************************************************
* E N D O R A C L E C O N F I G U R A T I O N
************************************************************************************




--------------------------------------------------------------------------------
OCPdba.Net