V$LOGSTDBY_PROGRESS

V$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

All the transactions with COMMIT SCN lower than or equal to this SCN have been applied

APPLIED_TIME

DATE

The time and date of APPLIED_SCN

RESTART_SCN

NUMBER

During an apply restart, LogMiner does not read any log file with a NEXT_CHANGE# lower than this SCN.

RESTART_TIME

DATE

The time and date of RESTART_SCN

LATEST_SCN

NUMBER

The highest SCN of all redo records that Logical Standby has encountered

LATEST_TIME

DATE

The time and date of LATEST_SCN

MINING_SCN

NUMBER

The SCN of the latest redo record processed by the builder process

MINING_TIME

DATE

The time and date of MINING_SCN

RESETLOGS_ID

NUMBER

A redo branch is identified by resetlogs SCN and resetlogs timestamp. The RESETLOGS_ID column contents are the same as resetlogs timestamp converted to a number.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data