windows下處理kill session不被釋放的鎖

select spid, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr and sid=sessionsid

SPID                   OSUSER
------------------------ --------------------------
PROGRAM
---------------------------------------------------
3760                   oracleplus

In windows CMD:

C:\>orakill ora92 3760

Kill of thread id 3760 in instance ora92 successfully signalled.

C:\>

ora92是你資料庫的sid.