Re: help on killing sessions in oracle

From: Richard Ramirez <ou79138_at_deere.com>
Date: 1996/01/17
Message-ID: <DLBx66.ME1_at_deere.com>#1/1


urass_at_urmama.com (thx1179) wrote:
>I could use some help and/or advice on killing sessions in Oracle 7.1.
>
>Here's the setup:
>Oracle 7.1 NT server
>Windows NT 3.51 Workstation running in server mode
>Several Win 3.11 clients
>(we're a small QA group and don't have access to a "real" network system)
>
>The problem:
>We're in the process of developing a PB4 app. Every now and then, the app
>will crash, leaving a session active in Oracle. Now, NT Workstation is
>limited 10 TCP/IP connections running as a server. Once we crash so many
>times, all of the ports fill up and no one can log in until I use Session
>Manager to disconnect a few sessions. I've also started using Server Manager
>to do this. I noticed that even though I disconnect a session, it stills
>remains active (but disconnected) until that user of that session tried to
>query the database again. That is in agreement with the Oracle docs I have
>handy. Since it was an unexpected application crash that caused this, here's
>no way to connect to that exact session again to REALLY kill it. (Clear
>enough???)
>
>The question:
>Is it possible to really KILL (and I mean KILL) a session from Oracle, like
>completely remove it from existance without shutting down the entire DB
>(which I find myself doing once or twice a day).
>
>Like I mentioned before, we're a small QA group that doesn't have the
>resources for a real server and this 10 connection limits coupled with the
>crashing is eating my lunch.
>
>Thanks in advance for any help.
>

Have you tried
  ALTER SYSTEM KILL SESSION 'x,y';
You get x,y from V$SESSION. I think one is session id and the other user id or something like that. E-mail me if this is what you need.

Richard Received on Wed Jan 17 1996 - 00:00:00 CET

Original text of this message