Modify the default maximum number of connections in Oracle.

Modify the default maximum number of connections in Oracle.

The maximum number of connections in oracle is 100 by default, and the default value is 150 when creating a database,

It is mainly subject to the processes system parameter (it should also be subject to operating system restrictions ),

This is a static parameter. After modification, the database must be restarted to take effect. If the permission is insufficient, you must log on as an administrator.

 

Alter system set processses = 200 scope = spfile;