How to increase Oracle Session

Check the existing processes and sessions limit using the following query.

SQL> select count(*) from v$session;
SQL> select * from v$resource_limit;

To increase run the following query:

(change the number according to your need)

Connect AS SYSDBA;
SQL> ALTER system SET sessions= 200 scope=spfile;

SQL> ALTER system SET processes = 200 scope=spfile;

Restart the Oracle server.