Kill a Oracle Session in RAC

Have you ever wondered, how to kill a oracle session on a different node than you currently logged into in a Oracle RAC cluster environment ?

Here is how to do that

SQL> alter system kill session ‘sid, serial#, @inst_id’ ;

for e.g to kill a session with sid 401, Serial# 31307 on RAC node 2, run below command

SQL> alter system kill session ‘401,31307,@2’;

Leave a Reply

Your email address will not be published. Required fields are marked *