Database Administration (MOSC)

MOSC Banner

Max session exceeded

edited Jan 29, 2011 3:02AM in Database Administration (MOSC) 11 commentsAnswered
  In the init.ora file, we have the setting
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center