While I have not tried to kill a session from the second node of a RAC environment, I do know that Quest's TOAD software shows you all sessions in a RAC environment while using their session browser utility... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of K Gopalakrishnan Sent: Thursday, April 12, 2007 8:37 PM To: shivaswamykr@xxxxxxxxx Cc: Oracle-L Freelists Subject: Re: KIll Session in - RAC DB 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 -- //www.freelists.org/webpage/oracle-l