Max Sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Max Sessions

  1. #1
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Unhappy Max Sessions

    We are using Oracle 8i with max sessions set at 200. The number

    of users are 100. Quiet frequently the problem of max

    sessions reached is encountered and we are forced to kill the

    sessions. Please let me know how i can increase the sessions

    without shutting down the database.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    You can not increase the SESSION parameter without bouncing the DB.

    On the other hand you might want to add the following line in your sqlnet.ora so that dead sessions get disconnected (after 5 minutes in that case):
    SQLNET.EXPIRE_TIME = 5
    If there is no solution, it is because there is no problem - Shadok -

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Increase processes parameter
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width