How do we find zombie/orphon/defunct database connection .
Seems like applicaton is down but even we see some connection coming from application.
so we need to figure out even when application is up or down that what are this zombie connection which exists on database doing nothing ( obviously ) but not on client or application.
In our environment, the weblogic/websphere keeps the connection pool.
even if the application is down, also in cluster web environment, I have
seen this problem.
The best thing is to remove connection fromt the source.The dba should
monitor that this is actually happening.
would you explain ,remove from the source ( database or application )
But, my question is how to find such zombies when application is up with some good connection and some such zombies ? In that scenario we want to remove such connection but root question is how to find from database side.
Waht could be the cause of such zombies ? anything with application weblogic/Web/app server or database ?
We know in other RDBMS like Oracle / Sybase we can do that.
1. Remove from source ==== at the apps/web server.
2. Best way to find is the snapshot at the application at database.. It usually shows the connect time/status change time.
3. At the weblogic/websphere , they have scripts to start and stop the server.
Make sure that when ever the apps server stopped. all the connection
also gone at the database.
4. Tune the connection pool parameter. it has connection alive time/initial no of connections etc.Refer to the web/apps documentation.