作者:mobiledu2502887833 | 来源:互联网 | 2023-05-18 07:13
SELECTG.TARGET||||S.MACHINE||||ceil((G.LAST_UPDATE_TIME-G.START_TIME)*86400) FROMV$SESSION
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;