Database Administration (MOSC)

MOSC Banner

ORA-00020: maximum number of processes exceeded

edited May 2, 2020 4:24PM in Database Administration (MOSC) 6 commentsAnswered ✓

Hello,

Since today morning I'm getting follwing notification:

ORA-00020: No more process state objects available

ORA-20 errors will not be written to the alert log for  the ORA-20 errors.

ORA-00020: maximum number of processes 500 exceeded

ORA-20 errors will not be written to the alert log for  the ORA-20 errors.

I have 500 processes set up as a parameter. I expanded this value to 600 and bounced db.

From application side they asked me about setting timout so that old connections can close themselves if idle.

In the list of sessions I saw 462 following lines:

webapp     5756  CUST 7258 '168,20682'  04/10 09:00:38 04/10 11:21:32 USER   httpd@web01 (TNS V1-V3)

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