SELECT G.TARGET || ‘ ‘ || S.MACHINE || ‘ ‘ || ceil((G.LAST_UPDATE_TIME - G.START_TIME)*86400)
FROM V$SESSION_LONGOPS G, V$SESSION S
WHERE G.SID = S.SID
AND G.SERIAL# = S.SERIAL#
AND G.SOFAR <> G.TOTALWORK
AND s.state <> ‘INACTIVE‘
AND G.OPNAME NOT LIKE ‘RMAN:%‘
and G.TARGET <> ‘TD_USERS‘
and rownum <2;
监控慢SQL
原文：https://www.cnblogs.com/liang545621/p/9410702.html
