I like that. :) -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 4/13/07, Tanel Poder <tanel.poder.003@xxxxxxx> 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). 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.