Oracle 10g Maximum number of session expired

Question

We have Oracle 10 g databse and we are getting message as ORA-00018: maximum number of sessions exceeded . we configure the parameter as below;

Session 600 process : 600

and its a shared Server Mode. We update this to Session :900 and Process : 750. and right now Oracle is running,but i need to know is this help us to go on or i need to do some other changes also to avoid the error "ORA-00018: maximum number of sessions exceeded"

Can anybody help plz Your response is Highly appreciated

Regards Joseph

Answer 1

You may have users taking sessions and not releasing them at all, or holding them for a long time. See if there are any long-running transactions when you get that exception.

Answer 2

Best way to know this is to connect to database and dump v$session table every after 5-10 minutes. In this way you can come to know that at times what all processes/applications were holding connection to the database. It could be a bug where a long running process/daemon/service which is not releasing the session at all. A simple script if you can run as a cron job to dump v$session table, it could become visible.