Cacher is the code snippet organizer for pro developers

select status || ':' || to_char(sequence#) 
       || ' (' || to_char(decode(status, 'APPLYING_LOG', trunc(100*block#/greatest(1,blocks)), 0)) || '%)'
       as status
from v$managed_standby
where process = 'MRP0'
and rownum=1 ;