Shared Memory requirements on Unix

From: Ashok Sharma <Ashok.Sharma_at_poports.com.au>
Date: Wed, 09 Dec 1998 16:21 +1000

     Hello Managers
     
           I am running Oracle 7.3.4 on Digital Unix 4.0D
     with 900MB of Memory with Oracle SGA of 140MB.
     I am interested in what other sites with similar
     configuration have setup their ipc kernel parameter.
     Is it better for Oracle to grap a single large segment
     or multiple small segments?
     
     Current my settings are as follows:
     
     ipc:
     msg-max = 8192
     msg-mnb = 16384
     msg-mni = 64
     msg-tql = 2100
     shm-max = 52428800
     shm-min = 1
     shm-mni = 128
     shm-seg = 32
     sem-mni = 16
     sem-msl = 25
     sem-opm = 10
     sem-ume = 10
     sem-vmx = 32767
     sem-aem = 16384
     num-of-sems = 60
     max-kernel-ports = 29399
     port-hash-max-num = 1469950
     port-reserved-max-num = 29399
     set-max-num = 3333
     ssm-threshold = 8388608
     ssm-enable-core-dump = 1
     #
     
     Thanks in advance
     
     Ashok
Received on Wed Dec 09 1998 - 05:27:49 NZDT