Re: Please Help: Maximum number of processes exceed

Yes, the default of PROCESSES is 25 which is found in the INIT.ORA. Keep in mind that the number you specify isn't really the number of users that can connect. Background processes will subtract users from this number. There are like 6 background processes, another process is for logon. So, 25 really means like 18 or so users. Also, if you have the dispatcher configured or if GC_LCK_PROCS is set to a non-zero value you will have to subtract even more from that number.

Enjoy!
Kevin

James Petts wrote:

> On Thu, 05 Nov 1998 12:21:55 +0200, Rene <rene_at_webhost.co.za> wrote:
>
> >PROBLEM:
> >--------
> > - After a certain amount of users have connected (50, I think), I get
> >the following error, when trying to get into SQL*PLUS:
> >ERROR:ORA-00020: maximum number of processes (50) exceeded
>
> SOLUTION:
> ---------
> - Increase the number of available processes by adjusting the
> PROCESSES parameter in the init.ora file. You will need to
> bounce the database before this will take effect.
>
> James
Received on Thu Nov 05 1998 - 00:00:00 CST