GV$RECOVERY_PROGRESS

select
USERENV ('Instance'),    -- INST_ID NUMBER
OPNAME,                  -- TYPE VARCHAR2(64)
TARGET_DESC,             -- ITEM VARCHAR2(32)
SOFAR,                   -- SOFAR NUMBER
TOTALWORK                -- TOTAL NUMBER
from
V$SESSION_LONGOPS 
where
opname like '% Recovery'
home |  up  |  mailbox