。[email protected]> col sid for [email protected]> col serial# for [email protected]> col spid for [email protected]> col OSUSER for [email protected]> col program for [email protected]> 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,那麼方法如下:[email protected]> host orakill secooler 2300Kill of thread id 2300 in instance secooler successfully signalled.
secooler
09.11.30-- The End --