Solaris Kernel Configuration - Oracle

OCPdba.Net

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