。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 --