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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: KIll Session in - RAC DB

Re: KIll Session in - RAC DB

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 13 Apr 2007 10:07:50 -0700
Message-ID: <bf46380704131007o60a96aaahd6bbee6434ba8df3@mail.gmail.com>


I like that. :)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


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.
>
-- http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 13 2007 - 12:07:50 CDT

Original text of this message

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