[20211210]swc.sql如何使用.txt

来源：这里教程网时间：2026-03-03 17:18:36 作者：

[20211210]swc.sql如何使用.txt --//简单记录一下tpt swc.sql脚本的使用。 1.环境： SCOTT@book> @ ver1 PORT_STRING VERSION BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production 2.测试： SCOTT@book> @ spid SID SERIAL# PROCESS SERVER SPID PID P_SERIAL# C50 ---------- ---------- ------------------------ --------- ------ ------- ---------- -------------------------------------------------- 4 1615 7760 DEDICATED 7761 24 138 alter system kill session '4,1615' immediate; SCOTT@book> select * from deptx where rownum=1 for update; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK --//再打开2个会话执行相同语句。 SYS@book> @ swc sid||','||SERIAL#||',@'||inst_id 1=1 SESSIONS PATH ---------- -------------------------------------------------------------------------------- 1 -> 32,723,@1 1 -> 323,1667,@1 1 -> 32,723,@1 -> 4,1615,@1 1 -> 323,1667,@1 -> 4,1615,@1 --//可以确定罪魁祸首是4,1615,@1。 SYS@book> @killix sid=4 COMMANDS_TO_VERIFY_AND_RUN ------------------------------------------------------------------------------------------------- alter system kill session '4,1615,@1' immediate -- SCOTT@xxxxxdg4 (sqlplus@xxxxxdg4 (TNS V1-V3)); SYS@book> alter system kill session '4,1615,@1' immediate -- SCOTT@xxxxxdg4 (sqlplus@xxxxxdg4 (TNS V1-V3)); System altered. SYS@book> @ swc sid||','||SERIAL#||',@'||inst_id 1=1 SESSIONS PATH ---------- -------------------------------------------------------------------------------- 1 -> 32,723,@1 -> 323,1667,@1 1 -> 32,723,@1 SYS@book> @ killix sid=323 COMMANDS_TO_VERIFY_AND_RUN --------------------------------------------------------------------------------------------------- alter system kill session '323,1667,@1' immediate -- SCOTT@xxxxxdg4 (sqlplus@xxxxxdg4 (TNS V1-V3)); --//继续问题解决。