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

Part Number B14237-04
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

DBA_LOGSTDBY_PROGRESS

DBA_LOGSTDBY_PROGRESS displays the progress of log apply services on the logical standby database. This view is for logical standby databases only.

Column Datatype NULL Description
APPLIED_SCN NUMBER   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_THREAD# NUMBER   Thread number for the log file containing the APPLIED_SCN
APPLIED_SEQUENCE# NUMBER   Sequence number for the log file containing the APPLIED_SCN
APPLIED_TIME DATE   Estimate of the time and date of the APPLIED_SCN
READ_SCN NUMBER   All log data less than this SCN has been read and saved
READ_THREAD# NUMBER   Thread number for a log file containing the READ_SCN
READ_SEQUENCE# NUMBER   Sequence number for a log file containing the READ_SCN
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_THREAD# NUMBER   Thread number for a log containing the NEWEST_SCN
NEWEST_SEQUENCE# NUMBER   Sequence number for a log containing the NEWEST_SCN
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.