Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Killing sessions

Re: Killing sessions

From: Tim Witort <trwAT_at_ATmedicalert.DOTorg>
Date: 1997/07/09
Message-ID: <33C40FBD.24BB@ATmedicalert.DOTorg>#1/1

Martin Drautzburg wrote:
>
> Oracle 7.1.3 under solaris 2.4
>
> How can I kill and oracle session. I tried svrmgrm, but sometimes I
> get a message "cannot.... session marked for kill". In situations like
> these I kill the unix process which seems to fix the problem. Still I
> wonder:
>
> 1. What trouble am I looking for, when I kill the unix process
> 2. Is there a cleaner way to kill a session ?

Well, under normal circumstances, using the server manager or session manager to kill a session works fine. But if the session is in a bad state (please don't ask me to elaborate on that), then you will get the message you got about the session just being "marked." At that point, you have no option but to kill it at the operating system level. This is not ideal, but it will get the results you want - the session's user gets the "connection closed" message and the RDBMS will (eventually) realize that the session is no longer there. No corruption of the database will happen - at least of the several hundred times I know of this being done on several RDBMSs on several different platforms (how's that for covering my bases?).

Received on Wed Jul 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US