ERPstuff - Oracle EBS Community

Dear All

I am facing a v.serious issue at my oracle environment.

That I am unable to login to oracle until few users log out.

Any one pls let me know if there is any script thru which i can clear up the inactive/dead connections in my DB. OR a script that can properly logout all dead/inactive sessions.

I Will appreciate any suggestion/comment/advice/ technique

Regards

Hi, first you need to increase the no. of sessions and processes in your database. these two parameters are in init.ora file.
by default processes are 400 -- double the the value to 800
and sessions are 200 -- double the value to 400

whereas about your query, you can kill inactive or dead sessions from enterprise manager , but you won't require it if you increase the value of above two parameters.

Do let me know when your issue is resolved