Re: Killing Oracle Sessions

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 29 Feb 2004 08:00:18 -0800
Message-ID: <1ac7c7b3.0402290800.7ba41507@posting.google.com>

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:<4041c4bc$0$4227$afc38c87_at_news.optusnet.com.au>...
> "Nicola Lamarca" <nicola.lamarca4_at_virgilio.it> wrote in message
> news:sNi0c.54039$IT2.1632517_at_news4.tin.it...
> > Hi all,
> > in day-by-day activities sometimes it happen that an Oracle session
> > intiated by a user/program has to be killed. While it is pretty simple to
> > have a dump of Oracle sessions (select * from V$SESSION ...), do you know a
> > way to kill one of them ?
>
> Anything wrong with
> "alter system kill session"?

yeah.
on win32 it takes too long to clean things up.

orakill.

the only limitation with using orakill.exe is that it has to be invoked from the OS of the oracle server.

Pd Received on Sun Feb 29 2004 - 10:00:18 CST