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
How to clear up Dead/Inactive Sessions with DB
-
- Posts: 11
- Joined: Thu Jul 26, 2007 8:01 am
- Location: Pakistan
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
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
Who is online
Users browsing this forum: No registered users and 1 guest