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.