Wednesday, March 9, 2011

Killing a session globally in Oracle 11gR2 RAC

Oracle has added a very useful option in 11gR2 RAC to kill a session on instance B from instance 1. They have added instance name as a parameter in kill session syntax

See following example

sys@ARAC> select username ,status,inst_id from gv$session where username='REMEDY';

USERNAME STATUS INST_ID
------------------------------ -------- ----------
REMEDY INACTIVE 2

sys@ARAC> alter system kill session '787,1113,@2' immediate;
System altered.

sys@ARAC> select username ,status,inst_id from gv$session where username='REMEDY';
no rows selected

thanks to my guru Javed Iqbal for telling me to RTFM

No comments:

Post a Comment