查看其它 42 个回答wwhalxj的回答
可以根据
select AGENT_ID, substr(STMT_TEXT,1,60) as STMT_TEXT, STMT_ELAPSED_TIME_MS from table (SNAPSHOT_STATEMENT('sample', -1)) as B where AGENT_ID in (select AGENT_ID_HOLDING_LK from table (SNAPSHOT_LOCKWAIT('SAMPLE',-1))as A order by LOCK_WAIT_START_TIME ASC FETCH FIRST 20 ROWS ONLY) order by STMT_ELAPSED_TIME_MS DESC
查找引发死锁的sql。
select AGENT_ID, substr(STMT_TEXT,1,60) as STMT_TEXT, STMT_ELAPSED_TIME_MS from table (SNAPSHOT_STATEMENT('sample', -1)) as B where AGENT_ID in (select AGENT_ID_HOLDING_LK from table (SNAPSHOT_LOCKWAIT('SAMPLE',-1))as A order by LOCK_WAIT_START_TIME ASC FETCH FIRST 20 ROWS ONLY) order by STMT_ELAPSED_TIME_MS DESC
查找引发死锁的sql。
浏览1375