Re: Trivial question:PROCESS parameter

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 Mon May 05 1997 - 00:00:00 CDT