Friday, May 18, 2012

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 comments:

  1. can i set number of processes to 700

    ReplyDelete
  2. 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?

    ReplyDelete
  3. Yes! calculate the sessions & transactions as per formula - processes=x
    sessions=x*1.1+5
    transactions=sessions*1.1

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

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

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

    ReplyDelete
    Replies
    1. Then Set your Environment Variable correctly

      Delete