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’;