Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-10
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

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.