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