select
SID||'-'||OPNAME SID_OPNAME,
100-round((sofar/totalwork) * 100,2) pct_left
from
v$session_longops
where
totalwork > sofar
AND
opname NOT LIKE '%aggregate%'
AND
opname like 'RMAN%';
SID_OPNAME PCT_LEFT
-------------------------------------- --------
3119-RMAN: incremental datafile backup 79.77
3135-RMAN: incremental datafile backup 79.87
3123-RMAN: incremental datafile backup 79.79
3143-RMAN: incremental datafile backup 79.92
3127-RMAN: incremental datafile backup 79.82
3159-RMAN: incremental datafile backup 78.28
3120-RMAN: incremental datafile backup 79.91
3136-RMAN: incremental datafile backup 78.16
3146-RMAN: incremental datafile backup 79.86
3183-RMAN: incremental datafile backup 85.29
3152-RMAN: incremental datafile backup 78.10
3151-RMAN: incremental datafile backup 79.74
3111-RMAN: incremental datafile backup 80.00
3124-RMAN: incremental datafile backup 79.74
3139-RMAN: incremental datafile backup 79.68
15 rows selected
