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