V$RECOVERY_PROGRESS

V$RECOVERY_PROGRESS can be used to track database recovery operations to ensure that they are not stalled, and also to estimate the time required to complete the operation in progress.

V$RECOVERY_PROGRESS is a subview of V$SESSION_LONGOPS.

Column Datatype Description
START_TIME DATE Start time of the recovery operation
TYPE VARCHAR2(64) Type of recovery operation being performed
ITEM VARCHAR2(32) Item being measured
UNITS VARCHAR2(32) The units of measurement for each item
SOFAR NUMBER Amount of work done so far
TOTAL NUMBER Total amount of work expected
TIMESTAMP DATE Timestamp of the last redo record applied