WITH A AS (SELECT SESS_ID AS WAITOR_SESSID,SQL_TEXT AS WAITOR_SQL,ID AS WAITOR,WAIT_FOR_ID,WAIT_TIME FROM SYS."V$SESSIONS" V,V$TRXWAIT T WHERE TRX_ID=ID),B AS(SELECT SESS_ID AS WAIT_FOR_SESSID,SQL_TEXT AS WAIT_FOR_SQL,ID AS WAITOR FROM SYS."V$SESSIONS" V,V$TRXWAIT T WHERE TRX_ID=WAIT_FOR_ID)SELECT A.*,B.WAIT_FOR_SESSID,B.WAIT_FOR_SQL FROM A,B WHERE A.WAITOR=B.WAITOR;
select datediff(ss,last_recv_time,sysdate) ss,dbms_lob.substr(sf_get_session_sql(sess_id)),sess_id,substr(clnt_ip,8,13) from v$sessions where state='ACTIVE' order by 1 desc;
达梦数据库中可以查询下是不是有阻塞，看看当前正在执行哪些SQL