【翻译自mos文章】在RAC database中怎么独立于instance来kill session？

最新推荐文章于 2025-09-23 04:05:00 发布

翻译最新推荐文章于 2025-09-23 04:05:00 发布 · 1.1k 阅读

文章标签：

#oracle rac #kill session

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文详细介绍了如何在Oracle RAC数据库中独立于实例地杀死会话，包括使用特定语法和实例ID来定位和终止指定会话。通过示例展示了如何查询会话并使用ALTER SYSTEM KILL SESSION语句来执行操作。

来源于：
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 sysdba

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