oracle kernel parameter requirement

[Joseph Bague]

Hi to all

We have a l-class server with 2GB of memory and 2 processor we use this as oracle application server (QA). We are planning to install another oracle database into it, our dba require as to update the kernel parameter of that server.

My current kernel setting is:

shmmax 536870912 bytes
shmmni 512
shmseg 120
semmi 4096
semmns 8192
max_thread_proc 64

dba requirement:

shmmax 1Gb
max_thread_proc 256

Any advice if this may affect my current setting.

Joseph

[Ravi_8]

Hi, joseph

http://docs.oracle.com/HTML_Storage/a90357/toc.htm

[Tore_1]

I dont know about semaphore settings, but if shmmax 1GB reuirement, your old setting seem to be only half of that.

Other parameters that need to be set high is :

nfile
maxfiles
nproc
maxuprc

Also make sure you have allocated enough swap space, that is swapspace (75%* mem + device swap) is > sga + user processes mem req (see top).