达梦查看阻塞会话

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;

查询等待时间最长的事务对应的WAIT_FOR_ID，通过下面sql查对应的事务详细信息

select * from v$trx where id = WAIT_FOR_ID

结果中找到事务对应的会话SESS_ID，通过下面sql查询会话的详细信息

select * from v$sessions where sess_id = SESS_ID