Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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
COMMENTS VARCHAR2(208) Miscellaneous notes; currently displays the SCN for the last applied redo