✦

Technology Geek

18+ YEARS AMONG THE CLOUDS

✦ TRANSMISSION

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 responses to “ORA-00020: maximum number of processes (%s) exceeded”

  1. Ajith Kumar Jain

    can i set number of processes to 700

    Like

    Reply
  2. Osama Mustafa

    Depend on what you need

    Like

    Reply
  3. Anonymous

    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

    Reply
  4. Anand Bharti

    Yes! calculate the sessions & transactions as per formula – processes=x sessions=x*1.1+5 transactions=sessions*1.1

    Like

    Reply
  5. JB

    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

    Reply
  6. Osama Mustafa

    did yo follow the above solutions ?

    Like

    Reply
  7. 熊英

    You can kill the database relative processes first then try to log on sqlplus with sys user.

    Like

    Reply
  8. imran khan

    first I can't log on with sqlplus / as sysdba

    Like

    Reply
  9. Osama Mustafa

    Then Set your Environment Variable correctly

    Like

    Reply

Leave a comment

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