Database Administration (MOSC)

MOSC Banner

ORA-00020: maximum number of processes (%s)

edited Feb 15, 2010 12:56AM in Database Administration (MOSC) 9 commentsAnswered
 Hi Guys,

I would like to hear any suggestion regarding to solve the problem "ORA-00020: maximum number of processes (%s) "

My first instinct is to inrease the process parameter and restart the database.

Is there any other way for me to solve this without any database restart ?

Is killing inactive session will help me to release the process that currently used ?

Thank.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center