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
`SOFAR`	`NUMBER`	Amount of work done so far
`TOTAL`	`NUMBER`	Total amount of work expected
`TIMESTAMP`	`DATE`	Timestamp