达梦数据库查询锁等待的会话,执行alter的时候看一下哪些会话有等待
select * from from v$sessions where trx_id in (select wait_for_id from v$trxwait);
杀等待会话
sp_close_session(sess_id);