非常简单,总结如下
第一步:查找未结束的事务id
SELECT O.OBJECT_NAME , L.*
FROM ALL_OBJECTS O , V$LOCKED_OBJECT L
WHERE O.OBJECT_ID = L.OBJECT_ID
第二步:查找事务id所对应的进程id
SELECT TO_CHAR(SID) || ',' || TO_CHAR(SERIAL#)
FROM V$SESSION
WHERE SID in ('143')
第三步:杀死进程id
ALTER SYSTEM KILL session '143,58104';