Re: LINUX Kernel Parameters

"Dave Hau" <davehau-no-spam-123_at_no-spam.netscape.net> wrote in message news:<fDyHa.652$km4.61670622_at_newssvr21.news.prodigy.com>...
> You can *install* more than 1 instance on the same machine, but at any given
> time, you're only going to *run* one instance I assume. Why would you ever
> want to run more than 1 instance of Oracle on the same machine?

Separate DEV and TEST instances, More then one Oracle versions, Leveraging resources on one machine to run multiple processes... just to name a few.

> OS: Red Hat Advanced Server 2.1
> DB: Oracle 9.2
>
> I followed the instructions in the installation manual, and was able
> to install the 9.2 database. My question is that after having created
> the 1st instance, I would like to add additional instances.
>
> The installation document only gives the kernel parameter values for
> one instance. Should I simply multiply the values by number of
> instances and adjust the values upwards.
>
> I know UNIX enough to find my way around, however not to the level as
> to make sense of how and what effects these kernel parameters would
> have on database processing on LINUX.

Adding another instance does not automatically mean that you have to double up on *all* the kernel parameters. You would have to see individually which one may need adjustment because of extra load. e.g semmns should be adjusted according to the number of instances (and processes) for each instance.

Regards
/Rauf Sarwar Received on Tue Jun 17 2003 - 12:25:43 CDT