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 |