topic Re: oracle kernel parameter requirement in Operating System - HP-UX

oracle kernel parameter requirement

Joseph Bague — Tue, 07 Jan 2003 11:47:34 GMT

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

Re: oracle kernel parameter requirement

Ravi_8 — Tue, 07 Jan 2003 11:51:54 GMT

Hi, joseph

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

Re: oracle kernel parameter requirement

Tore_1 — Tue, 07 Jan 2003 12:40:34 GMT

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).