【翻譯自mos文章】在RAC database中怎麼獨立於instance來kill session？，mosrac

【翻譯自mos文章】在RAC database中怎麼獨立於instance來kill session？，mosrac

來源於：
How to Kill a Session on RAC Database In Instance Independent Fashion. (文檔 ID 869777.1)

適用於：
Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

目標：
你可以在RAC database中來kill session，而不用考慮該session是從哪個intance上產生的。這是11g的新特性。

解決方案：

To kill a session in RAC database use the following syntax.

sql> conn / as sysdbasql> alter system kill session 'sid, serial#, @inst_id';

 

For Example :

SQL@racdb1> select inst_id,sid,serial#,username from gv$session where username is not null and username not like 'SYS%'; INST_ID SID SERIAL# USERNAME ---------- ---------- ---------- ------------------------------ 1                123        76       DBSNMP 1 rows selected. SQL@racdb2> conn scott/tiger Connected. SQL@racdb1> select inst_id,sid,serial#,username from gv$session where username is not null and username not like 'SYS%'; INST_ID SID SERIAL# USERNAME ---------- ---------- ---------- ------------------------------ 2                115    17816        SCOTT 1                123         76         DBSNMP 2 rows selected. SQL@racdb1> alter system kill session '115,17816,@2'; System altered. SQL@racdb1> conn scott/tiger Connected. SQL@racdb1> select inst_id,sid,serial#,username from gv$session where username is not null and username not like 'SYS%'; INST_ID SID SERIAL# USERNAME ---------- ---------- ---------- ------------------------------ 1                110      45316         SCOTT 1                123            76         DBSNMP 2 rows selected. sql> alter system kill session '110,45316,@1';System altered.