RE: KIll Session in - RAC DB
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: rjamya@xxxxxxxxx, WLJohnson@xxxxxxxxxxxxxxxxxxx
- Date: Fri, 13 Apr 2007 22:28:53 +0800
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of rjamya
Sent: Friday, April 13, 2007 20:25
To: WLJohnson@xxxxxxxxxxxxxxxxxxx
Cc: kaygopal@xxxxxxxxx; shivaswamykr@xxxxxxxxx; 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@xxxxxxxxxxxxxxxxxxx> wrote:
I do know that Quest's TOAD software shows you all sessions
in a RAC environment while using their session browser utility...
Other related posts:
