Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-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 Go to next page
View PDF

DBA_LOGSTDBY_PROGRESS

DBA_LOGSTDBY_PROGRESS describes the progress of log apply services on the logical standby database.

Column Datatype NULL Description

APPLIED_SCN

NUMBER

Shows the newest SCN at which all changes have been applied. The values in the APPLIED_SCN and NEWEST_SCN columns will match if all available redo log data has been processed.

APPLIED_TIME

DATE

Estimate of the time and date of the APPLIED_SCN

READ_SCN

NUMBER

All log data greater than this SCN has been read and saved

READ_TIME

DATE

Estimate of the time and date of the READ_SCN

NEWEST_SCN

NUMBER

Most recent SCN available on the standby system. If no more logs are being shipped, then changes could be applied to this SCN. The values in the APPLIED_SCN and NEWEST_SCN columns will match if all available redo log data has been processed.

NEWEST_TIME

DATE

Estimate of the time and date of the NEWEST_SCN


Note:

The SCN values shown in this view correlate to the SCN values shown in the DBA_LOGSTDBY_LOG view.