如果是winNt或win2000 先找到serial# select serial# from v$session / alter system kill session '[sid], [serial#]';如果sid=20, serial#=120 则: alter system kill session '20, 120';
SELECT s.Sid AS "Sid", s.Serial# AS "Serial#", p.spid AS "ThreadID", s.OSUser AS "OSUser", s.Program AS "Program" FROM V$Process p, V$session s WHERE p.addr=s.paddr(+) ORDER BY s.SidSample Output: Sid Serial# ThreadID OSUser Program --- ------- -------- ------ ------- ... 10 809 102 User01 Prog.exe 11 345 333 SeUser App.exe 15 719 422 User01 Prge.exe 20 345 123 SeUs Acco.exe 555 324then: orakill InstanceName ThreadNumber
先找到serial#
select serial# from v$session
/
alter system kill session '[sid], [serial#]';如果sid=20, serial#=120 则:
alter system kill session '20, 120';
SELECT s.Sid AS "Sid",
s.Serial# AS "Serial#",
p.spid AS "ThreadID",
s.OSUser AS "OSUser",
s.Program AS "Program"
FROM V$Process p, V$session s
WHERE p.addr=s.paddr(+)
ORDER BY s.SidSample Output: Sid Serial# ThreadID OSUser Program
--- ------- -------- ------ -------
...
10 809 102 User01 Prog.exe
11 345 333 SeUser App.exe
15 719 422 User01 Prge.exe
20 345 123 SeUs Acco.exe
555
324then:
orakill InstanceName ThreadNumber