RE: jdbc connection to db don't die.

We get this problem on solaris. The best way I have found to persuade the sessions to go away is to query v$process for the pid and kill the o/s process rather than the oracle session. Don't know whether you can do the same on windows (and its probably not so easy if you're using MTS)

--
David Lord

-----Original Message-----
Sent: 11 January 2002 07:15
To: Multiple recipients of list ORACLE-L


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 message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
email.helpdesk_at_hays.plc.uk
Any information, statements or opinions contained in this message


(including any attachments) are given by the author.  They are not 

given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lord, David - C&S
  INET: David.Lord_at_hayscsg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).