Monitorar Processos - RMAN - Oracle

select sid,
serial#,
context,
sofar,
totalwork,
round(sofar/totalwork*100,2) porcentagem
from
v$session_longops
where
opname like 'RMAN%'
and opname not like '%aggregate%'
and totalwork != 0
and sofar <> totalwork