--查看锁对应的SID, SERIAL#
SELECT S.SID,
S.SERIAL#,
L.ORACLE_USERNAME,
L.OS_USER_NAME,
O.OBJECT_NAME,
L.LOCKED_MODE
FROM V$LOCKED_OBJECT L
JOIN V$SESSION S
ON L.SESSION_ID = S.SID
JOIN DBA_OBJECTS O
ON L.OBJECT_ID ON O.OBJECT_ID;
--根据SID, SERIAL#,把SESSION KILL掉
ALTER SYSTEM KILL SESSION '145,77';
--不能马上生效时加上IMMEDIATELY
ALTER SYSTEM KILL SESSION '145,77' IMMEDIATELY;
SELECT * FROM SYS.V_$LOCKED_OBJECT;--V$LOCKED_OBJECT
SELECT * FROM SYS.V_$SESSION;--V$SESSION
SELECT * FROM DBA_OBJECTS;
查看oracle锁,kill掉对应session
最新推荐文章于 2021-04-08 09:07:31 发布