On Windoze you can use the 'orakill' command. You kill by thread# and SID. The thread# is found in the same column as the OS process on unix versions.
Jared On Friday 11 January 2002 01:05, Lord, David - C&S wrote: > 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: Jared Still 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).
