Re: LINUX Kernel Parameters

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Tue, 17 Jun 2003 19:31:06 GMT
Message-ID: <3EEF6C76.7020303@nospam_netscape.net>

Rauf Sarwar wrote:
> "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.

I'm okay with the second reason. First reason is, maybe. But third reason: leveraging resources on one machine to run multiple processes???   Isn't that what dedicated server is for? You get a separate process for each session anyways. Come on. ;-)

Cheers,
Dave

>
>

>>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 - 14:31:06 CDT