-- 正在执行的sql且时间大于2秒 SELECT * FROM (SELECT SESS_ID, SQL_TEXT, DATEDIFF(SS, LAST_RECV_TIME, SYSDATE) Y_EXETIME, SF_GET_SESSION_SQL(SESS_ID) FULLSQL, CLNT_IP FROM V$SESSIONS WHERE STATE = 'ACTIVE') WHERE Y_EXETIME >= 2; --把你想干掉的那条SQL 的sess_id 填入 call sp_close_session(sess_id);
09-06
1190
09-05
1172