Summary: Help needed for Kernel Fine Tuning for Oracle

From: Ju-Lien Lim (julienlim@rocketmail.com)
Date: Mon Nov 03 1997 - 22:00:13 CST


My thanks to Glenn Satchell glenn@uniq.com.au for
his insight into tuning Unix for Oracle:

The kernel is pretty much self tuning based on memory
size and hardware type in 2.5 and above. 'nproc' is
the maximum number of processes, maxup is the maximum
number of processes that can run under a single user
id. These are all dynamically tuned and you shouldn't
need to worry about them.

Original Question:
------------------
I read somewhere that the following parameters are
also important for fine tuning Solaris for Oracle:

> > nproc
> > nqueue
> > maxup
> > ptycount
> > percentbuf
> >
Does anyone have any suggestions what I should set
these at for a machine running 2.5 and has 1 Gig of
RAM? In addition, what other parameters should I set?

Right now, I also have the following parameters set
in relations to the Oracle DB we're running:
> >
> > shminfo_shmmax 1073741824
> > shminfo_shmmin 1
> > shminfo_shmmni 600
> > shminfo_shmseg 100
> > shminfo_semmap 2924
> > shminfo_semmni 2922
> >
> > seminfo_semmns 5844
> > seminfo_semmnu 1461
> > seminfo_semume 100
> > seminfo_semmsl 100
> > seminfo_semopm 100
> >
> > msginfo_msgmap 1024
> > msginfo_msgmax 8192
> > msginfo_msgmnb 65535
> > msginfo_msgmni 1024
> > msginfo_msgssz 2048
> > msginfo_msgtql 1024
> > msginfo_msgseg 4096

Thanks again!

Ju
julienlim@rocketmail.com

_____________________________________________________________________
Sent by RocketMail. Get your free e-mail at http://www.rocketmail.com



This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:12:07 CDT