该sql同样适用于长时间执行未结束的sql，需要查询v$session_longops

select inst_id,sid,serial#,opname,COMPLETE,
trunc(((to_char(last_update_time,'dd')-to_char(start_time,'dd'))*60*24+(to_char(last_update_time,'hh24')-to_char(start_time,'hh24'))*60 +(to_char(last_update_time,'mi')-to_char(start_time,'mi')))*(100-complete)/complete) min from
(
SELECT inst_id,
sid,
serial#,
opname,
ROUND(SOFAR / TOTALWORK * 100, 2) COMPLETE,
LAST_UPDATE_TIME,
START_TIME
FROM gV$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
--AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK
) t

结果输出

   INST_ID        SID    SERIAL# OPNAME                                                             COMPLETE        MIN
---------- ---------- ---------- ---------------------------------------------------------------- ---------- ----------
         1       1084          1 RMAN: full datafile restore                                           82.62        124
         1       1083          1 RMAN: full datafile restore                                           81.01        127
         1       1085          5 RMAN: full datafile restore                                           95.42        107
         1       1086         28 RMAN: aggregate input                                                   100        102