Max Sessions

[ramji_1123]

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.

[yanban]

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

[SANJAY_G]

Increase processes parameter