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: Removing KILLED / SNIPED session

Re: Removing KILLED / SNIPED session

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 29 Oct 2002 08:08:52 -0800
Message-ID: <336da121.0210290808.77d2ee99@posting.google.com>


"Scot" <scot.drylie_at_ntlworld.com> wrote in message news:<26Eu9.12272$Af5.506630_at_newsfep2-win.server.ntli.net>...
> Hi all
> Can anyone please tell me how to remove a session once it has ben killed or
> sniped and also release objects held by such sessions.
> I am using Oracle 8.1.7
> Any replies appreciated.
> Scot

The best way would be to kill dedicated server process of this session. You can find it using v$process and v$session virtual tables. Received on Tue Oct 29 2002 - 10:08:52 CST

Original text of this message

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