Re: Trivial question:PROCESS parameter

Another potential gotcha with changing the value for processes is that the default values for various other parameters such as enqueue_resources are derived from the processes value. However, if these values have been set explicitly, there will be no corresponding increase when you double the value of 'processes'.

Steve Adams

On Mon, 05 May 1997 22:46:32 -0400, oracle <oracle_at_nightmare.com> wrote:
>
>P.M.Wong wrote:
>
>> Being a new sysadmin of Oracle, i would like to ask some trivial
>> questions:
>> it's about the paramter PROCESS in the initsid.ora file.
>>
>> 1. What limit does it impose, e.g. how many users connecting to
>> Oracle (But how does it count for one user)
>>
>> 2. We use the default value (i.e. PROCESS=50).
>> Now if i am to change it to 100, what things do i have to watch out
>> e.g. do i have to change other parameters as well or they are
>> taken care of by ORACLE itself
>>
>> __
>> / \_/ ) __ Pui Ming WONG (E-mail: pm_at_hkbu.edu.hk)
>> / ( ------------- } System Support Programmer,
>> ( =l=ll===============__} Computing & Telecomm. Services Centre
>> \ _ ( Hong Kong Baptist University
>> \_/ \__) 224 Waterloo Road, Hong Kong
>
> Depending on the OS you most likely would have to increase "SEMMNS".
>You want "SEMMNS" to be 10% larger than all the "processes" values of
>the instances on the system. That is if you have two instances each
>having 100 processes in the init<sid>.ora then you want at least 220 for
>SEMMNS. I generally make the "SEMMNS" parameter extremely large since
>it will only grab what it needs anyway. Some operating systems use
>post-wait calls instead of semaphores so you do not worry about SEMMNS
>for platforms such as IBM AIX.
>
Received on Wed May 07 1997 - 00:00:00 CDT