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

How to increase PROCESSES initialization parameter : 

Check Current Setting of Parameters

1)show parameter sessions

2)show parameter processes

3)show parameter transactions


A basic formula for determining  these parameter values is as follows below:





These paramters can’t be modified in memory. You have to modify the spfile only (scope=spfile) and close the instance.

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

SQL> alter system set sessions = 342 scope = spfile;

SQL> alter system set transactions = 376 scope = spfile;

We need to close the database:

SQL> shutdown immediate;

SQL> startup;

Check parameter values :

SQL> select name, value
  2  from v$parameter
  3  where name in ('processes', 'sessions', 'transactions');




Then completed


About baranyildiz

I am Computer Engineer. Oracle & SQL Server Database,Goldengate,Guardium,Tableau , Exadata Machine administrator 6 years.I took part in many different projects in energy sector and customer information systems. I worked on sql server, oracle consolidation,migration, upgrade projectsMail : [email protected]

Leave a Reply

Your email address will not be published. Required fields are marked *