记一次达梦DM8数据库锁处理记录

查询具体得锁语句：

SELECT * FROM V$LOCK WHERE TABLE_ID = (SELECT OBJECT_ID FROM DBA_OBJECTS WHERE OBJECT_NAME = 'DATABASECHANGELOG' AND OWNER = 'HERMES');

输出结果：

查询详细的锁信息，包括会话和事务信息

SELECT 
    vlock.*, 
    vsess.SESS_ID,
    vsess.SQL_TEXT,
    vsess.TRX_ID,
    vsess.STATE,
    vsess.CREATE_TIME
FROM V$LOCK vlock
JOIN V$SESSIONS vsess ON vlock.TRX_ID = vsess.TRX_ID
WHERE vlock.TABLE_ID = (
    SELECT OBJECT_ID FROM DBA_OBJECTS 
    WHERE OBJECT_NAME = 'DATABASECHANGELOG' AND OWNER = 'HERMES'
);

根据查询结果生成KILL语句

SELECT 'SP_CLOSE_SESSION(' || vsess.SESS_ID || ');' AS KILL_COMMAND
FROM V$LOCK vlock
JOIN V$SESSIONS vsess ON vlock.TRX_ID = vsess.TRX_ID
WHERE vlock.TABLE_ID = (
    SELECT OBJECT_ID FROM DBA_OBJECTS 
    WHERE OBJECT_NAME = 'DATABASECHANGELOG' AND OWNER = 'HERMES'
)
AND vlock.LMODE IN ('X', 'IX'); 

输出：

根据执行结果进行删锁处理：

正常执行删除命令：