Re: KIll Session in - RAC DB

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_at_mail.ee> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of rjamya
> Sent: Friday, April 13, 2007 20:25
> To: WLJohnson_at_tycoelectronics.com
> Cc: kaygopal_at_gmail.com; shivaswamykr_at_gmail.com; 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_at_tycoelectronics.com> 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
--
http://www.freelists.org/webpage/oracle-l