人大金仓数据库修改表或删除表卡死问题解决方案

锁冲突原因：其他会话持有该表的锁，导致操作被阻塞

解决方案：

-- 查看当前锁情况

SELECT * FROM sys_locks WHERE relation IN (SELECT oid FROM sys_class WHERE relname='表名');

-- 杀死阻塞进程

SELECT sys_terminate_backend(pid) FROM sys_stat_activity WHERE pid IN (SELECT pid FROM sys_locks WHERE relation IN (SELECT oid FROM sys_class WHERE relname='表名'));