Oracle杀死用户进程命令kill,【orakill】使用Oracle的orakill命令彻底杀死Windows环境下Oracle线程...

。sys@secooler> col sid for 9999sys@secooler> col serial# for 9999sys@secooler> col spid for 99999sys@secooler> col OSUSER for a20sys@secooler> col program for a30sys@secooler> select s.sid, s.serial#, p.spid, s.osuser, s.program from v$process p, v$session s where p.addr=s.paddr order by s.sid;SID SERIAL# SPID    OSUSER               PROGRAM

----- ------- ------- -------------------- --------------------

147       9 2300    BJSECDB\Housw        sqlplus.exe

149       2 5904    SYSTEM               ORACLE.EXE (q001)

151       2 3096    SYSTEM               ORACLE.EXE (q000)

155       9 2884    SYSTEM               ORACLE.EXE (QMNC)

158      17 5588    SYSTEM               ORACLE.EXE (J000)

159       3 1088    BJSECDB\Housw        sqlplus.exe

160       1 4776    SYSTEM               ORACLE.EXE (MMNL)

161       1 4308    SYSTEM               ORACLE.EXE (MMON)

162       1 3224    SYSTEM               ORACLE.EXE (CJQ0)

163       1 5780    SYSTEM               ORACLE.EXE (RECO)

164       1 2272    SYSTEM               ORACLE.EXE (SMON)

165       1 2804    SYSTEM               ORACLE.EXE (CKPT)

166       1 2696    SYSTEM               ORACLE.EXE (LGWR)

167       1 4876    SYSTEM               ORACLE.EXE (DBW0)

168       1 5668    SYSTEM               ORACLE.EXE (MMAN)

169       1 4644    SYSTEM               ORACLE.EXE (PSP0)

170       1 1112    SYSTEM               ORACLE.EXE (PMON)17 rows selected.数据库的实例名字是“secooler”，我们打算杀死SPID是“2300”这个session，那么方法如下：sys@secooler> host orakill secooler 2300Kill of thread id 2300 in instance secooler successfully signalled.

secooler

09.11.30-- The End --