oracle查看被锁的表及解除锁
2021-7-27 小木 数据库
oracle查看被锁的表及解除锁
-- 查看被锁对象
SELECT OBJECT_NAME, MACHINE, S.SID, S.SERIAL#
FROM V$LOCKED_OBJECT L,DBA_OBJECTS O,V$SESSION S
WHERE L.OBJECT_ID = O.OBJECT_ID
AND L.SESSION_ID = S.SID;
--杀死进程
ALTER SYSTEM KILL SESSION '24,111'; (其中24,111分别是上面查询出的SID,SERIAL#)
标签: oracle查看被锁的表及解除锁 oracle查看锁表解除锁 oracle锁表