GV$RECOVERY_PROGRESS select INST_ID, -- INST_ID NUMBER OPNAME, -- TYPE VARCHAR2(64) TARGET_DESC, -- ITEM VARCHAR2(32) SOFAR, -- SOFAR NUMBER TOTALWORK -- TOTAL NUMBER from GV$SESSION_LONGOPS