Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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