LINUX Kernel Parameter

[Marcin Bartoszek]

You can find collectl and doc here:
http://collectl.sourceforge.net/

M.

[Zinky]

Jojo Sir,

Glance is universally available for most UNIX and UNIX like platforms sir -- Linux included of course.

Using it is a good skill set to have.

And yes you can monitor most kernel params with it.

But to answer thine question on what kernel parms to monitor (or set properly) for Oracle -- well aside from teh recommended settings for shmmax and various SHM/SEG tunables - I pay particular attention to:

nproc (monitor vis plain ole ps)
nofile (monitor via lsof)

ipcs -l (to monitor current settingd for SHM and SEM)

kernel.sem SEMMSL SEMMNS SEMOPM SEMMNI

SEMMNS - value should be greater than the total of "ipcs -s" nsems column. Generally it should be 1.5x than the sum of all Oracle DB's PROCESSES params. You will know you are getting close to kernel SEMMNS limits by simply doing a count of all Oracle processes (background and foreground -- simple ps)

HTH .

[Jojo Castro]

thanks

[dirk dierickx]

i just want to add that you will find these parameters in the guides of the oracle version you are using.