处理达梦数据库长时间锁表、死锁问题方案
查出锁表session
--查出锁表session
select * from v$sessions where trx_id in (select trx_id from V$LOCK)
AND sql_text LIKE '%表名%';
关闭锁表session
sp_close_session(sess_id);
处理达梦数据库长时间锁表、死锁问题方案
查出锁表session
--查出锁表session
select * from v$sessions where trx_id in (select trx_id from V$LOCK)
AND sql_text LIKE '%表名%';
关闭锁表session
sp_close_session(sess_id);