Database Tuning (MOSC)

MOSC Banner

Linux semaphore and ulimit settings for Oracle "processes" parameter

edited May 9, 2012 8:03PM in Database Tuning (MOSC) 5 commentsAnswered


Hi,

we have a 11g R2 RAC database running on Oracle Linux 5 X64 5.5
Here are the current Semaphores settings

more /proc/sys/kernel/sem
250     32000   100     128

[root@node2 ~]# ipcs -ls

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767


Here are the ulimit settings

[oracle@enode1 ~]$ ulimit -Ha

core file size          (blocks, -c) unlimited
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 135167
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 65536
pipe size            (512 bytes, -p) 8

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center