Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> jdbc connection to db don't die.

jdbc connection to db don't die.

From: Denham Eva <EvaD_at_TFMC.co.za>
Date: Thu, 10 Jan 2002 23:42:44 -0800
Message-ID: <F001.003ED6E2.20020110231519@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US