Re: KIll Session in - RAC DB

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: tanel.poder.003@xxxxxxx
  • Date: Fri, 13 Apr 2007 19:49:47 -0400

I think scheduling a job that runs ALTER SYSTEM KILL SESSION on a
specific instance is a more elegant solution.

On 4/13/07, Tanel Poder <tanel.poder.003@xxxxxxx> wrote:



Hi,

Write a pl/sql daemon which runs in every instance, wakes up once per minute
and scans for a shared table for insance, sid and serial# combination to
kill. If it finds anything matching local instance ID, it kills that
session(s).

So if you need to kill something, you insert the instance_id, sid and
serial# to the shared table, commit and wait for a minute :)

Tanel.


 ________________________________
 From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of rjamya
Sent: Friday, April 13, 2007 20:25
To: WLJohnson@xxxxxxxxxxxxxxxxxxx
Cc: kaygopal@xxxxxxxxx; shivaswamykr@xxxxxxxxx; Oracle-L Freelists
Subject: Re: KIll Session in - RAC DB


That you can do simply by selecting from gv$session. Killing session on
_other_ instance is a different story, and is not possible until 11g.

rjamya


On 4/13/07, Johnson, William L (TEIS) <WLJohnson@xxxxxxxxxxxxxxxxxxx> wrote:
> I do know that Quest's TOAD software shows you all sessions
> in a RAC environment while using their session browser utility...
>





--
Best regards,
Alex Gorbachev

http://www.oracloid.com
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2007