select s.sess_id,s.SQL_TEXT,s.RUN_STATUS from v$sessions s , v$lock l where l.tid=s.trx_Id and l.blocked=1;
P_CLOSE_SESSION(SESS_ID)来关闭对应的会话
select 'SP_CLOSE_SESSION(' ||s.sess_id||')' from v$sessions s,v$lock l where s.trx_id=l.tid and l.blocked=1;
查看那些事务处于等待状态
select * from v$trx where status ='LOCK WAIT';
select * from v$trxwait;
标签:trx,lock,阻塞,会话,达梦,where,id,select From: https://www.cnblogs.com/omsql/p/17269539.html