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 theDBA_LOGSTDBY_LOG view.