| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
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 |
|
 Copyright © 2002, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
