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: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Thu, 12 Apr 2007 17:37:19 -0700
Message-ID: <3b0f44a10704121737r5b7977a9pb94aea88b3600cf2@mail.gmail.com>


Shiva,

You may have to wait for another year (approx) to have this in the database. It is going be a 11g(!) feature.

-Gopal

On 4/12/07, Shivaswamy Raghunath <shivaswamykr_at_gmail.com> wrote:
> Hello.
>
> We do not seem to have a switch INST_ID for ALTER SYSTEM KILL SESSION
> command. So, if I need to kill the session, I necessarily need to login to
> the same instance in RAC.
>
> Has any of you have any other method so that you can kill the session from
> any of the instance of the RAC database?
>
> Thanks,
> Shiva
>
>
>

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 12 2007 - 19:37:19 CDT

Original text of this message

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