国内最全IT社区平台 联系我们 | 收藏本站
华晨云阿里云优惠2
您当前位置:首页 > 数据库 > 数据库应用 > 【翻译自mos文章】在RAC database中怎么独立于instance来kill session?

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

来源:程序员人生   发布时间:2015-03-23 08:23:43 阅读次数:3716次

来源于:
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.

 

生活不易,码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
程序员人生
------分隔线----------------------------
分享到:
------分隔线----------------------------
关闭
程序员人生