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: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Fri, 13 Apr 2007 22:28:53 +0800
Message-id: <011f01c77dd8$0ffa2c50$6701a8c0@windows01>


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...

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 13 2007 - 09:28:53 CDT

Original text of this message

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