数据库锁表问题解决清单

达梦数据库锁表问题解决

--查看锁表sql
select * from v$sessions where trx_id in (select trx_id from V$LOCK where lmode = 'X' and table_id <> 0) 
		--	and state='ACTIVE' 
		--	and trx_id='27547033'
			order by create_time desc;

select * from v$sessions where trx_id in (select trx_id from V$LOCK);
sp_close_session('140588692281064');

--查看已锁表的信息
select * from v$lock where lmode = 'X' and table_id <> 0;