oracle查看锁表及解锁

发布时间：2020-12-12 13:12:56 所属栏目：百科来源：网络整理

导读：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 ‘ SID,SERIAL# ‘ ;

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 ‘SID,SERIAL#‘;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!