达梦数据库查询锁等待的会话,执行alter的时候看一下哪些会话有等待

select * from from v$sessions where trx_id in (select wait_for_id from v$trxwait);

 

杀等待会话

sp_close_session(sess_id);