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
`TYPE`	`VARCHAR2(64)`	Type of recovery operation being performed
`ITEM`	`VARCHAR2(32)`	Item being measured
`SOFAR`	`NUMBER`	Amount of work done so far
`TOTAL`	`NUMBER`	Total amount of work expected

See Also:

Oracle Database Backup and Recovery Advanced User's Guide