Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> jdbc connection to db don't die.
Hi Guru's
Please help, I am running Oracle 8.1.7 on Windows 2000. The problem is a third party product runs a jdbclient connection to the database, but it does not seem to disconnect. So over time we have a build up of connected sessions using jdbcuser (Osuser). I have tried killing the sessions with TOAD, but the remain connected with a status of KILLED. They never drop - until the database is shutdown and restarted.
As you can imagine the database quickly reaches MAX NUMMBER OF SESSIONS EXCEEDED and I really cann't keep stopping starting the db.
I am managing to hold out by killing the idle users.
Please has anyone else experienced this and is there some solution?
TIA
Denham
This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal -
For more information please visit
<A
href="http://www.marshalsoftware.com">www.marshalsoftware.com
Received on Fri Jan 11 2002 - 01:42:44 CST
![]() |
![]() |