RE: KIll Session in - RAC DB

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