Re: jdbc connection to db don't die.

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.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: Jared Still
  INET: jkstill_at_cybcon.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).