ORA-00020: Maximum number of processes (%s) exceeded

    You have reached the maximum number of processes the database is allowed to create.


    Every dedicated connection attempt will create a new thread (Windows) or startup a new process (Unix).

    This can have an impact on the server, especially when resources are sparse.


    In order to mimimise the risk of exhausted resources, you can specify the PROCESSES parameter in your pfile or spfile.


    In order to be able to make new connections, you can choose to close unneeded connections, or augment the PROCESSES parameter.


    If you choose to change the parameter, a database bounce (stop/start) is required.


Adverteren bij Daisycon
Forum Messages
13-FEB-2008 07:22:15What is the max. number (parameter) of process which can be declared for oracle 9i?Abhishek Reply
What is the max. number of process parameter which can be declared for oracle 9i? At the parameter 350 i get the oracle error. So what is the maximum value or preferred value so that the error doesnt come again.
: ->  13-FEB-2008 08:52:34DependsDbMotive Reply
It all depends on how many sessions you concurrently expect and on how big the load is your machine can handle.
Every process takes some resources (memory, handles, ...) so of you only have 1Gb of memory, the number of processes handled will be lower than if you have 4Gb of memory for instance.

If you have a lot of simultaneous connections, all for a short period of time, you might want to consider configuring MTS (Multi-threaded server)

Add your message for ORA-00020
Name:email:
Validation Code:ckj00y4x6f6frbdiy
Enter Code above:
Title:
State your problem: