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

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processes integer 150

SQL> select count(*) from v$process;

COUNT(*)
----------
149

SQL> alter system set processes=300 scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processes integer 300

Thank you
Osama mustafa

9 thoughts on “ORA-00020: maximum number of processes (%s) exceeded

  1. I came across a post saying if we increase Proccesses then we also need to increase sessions and transactions.Is that true.Do we need to do that?

    Like

  2. this queries are written in SQL but I can't enter in SQL because of this ORA-00020: maximum number of processes (%s) exceeded errorhow can I solve this problem?????

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.