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@xxxxxxxxx> 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/ -- //www.freelists.org/webpage/oracle-l