Max session exceeded
processes =2100
sessions = 2000
SQL> select count(*) from v$session;
COUNT(*)
----------
1948
SQL> select * from v$resource_limit;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL
------------------------------ ------------------- --------------- ----------
LIMIT_VALU
----------
processes 1092 1239 2100
2100
sessions 1948 2315 2315
2315
Today, alll of the sudden we are getting
ora 604: Error occurred at recursive SQL 1 Level.
ora 00018: Maximum number of sessions exceeded.
There is no error in the alert log and I can even log in as system.
I have searched on the site that to resolve this I should increase the processes and sessions parameter in the pfile and bounce the database.