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: rjamya <rjamya_at_gmail.com>
Date: Fri, 13 Apr 2007 13:11:22 -0400
Message-ID: <9177895d0704131011u7d4520a4j79fd271c82801a19@mail.gmail.com>


so, I can put in sid,serial for pmon or smon into the table and watch fun 8:)

rjamya

On 4/13/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> I like that. :)
>
>
> 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).
> >
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 13 2007 - 12:11:22 CDT

Original text of this message

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