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 PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
