JZTXT

达梦查看阻塞会话

发布时间 2023-03-29 16:52:57作者: 刚好遇见Mysql

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;