| Column Name
| Description
|
| APPLIED_SCN (DBA_LOGSTDBY_PROGRESS)
| All transactions with a commit SCN <= this value have been applied
|
| APPLIED_SCN (DBA_CAPTURE)
| Everything up to this SCN has been applied
|
| CAPTURED_SCN (DBA_CAPTURE)
| Everything up to this SCN has been captured
|
| COMMIT_SCN (DBA_LOGSTDBY_EVENTS)
| SCN for the commit record of the transaction
|
| CURRENT_SCN (DBA_LOGSTDBY_EVENTS)
| Change vector SCN for the change
|
| DICTIONARY_SCN (V$LOGMNR_DICTIONARY)
|
|
| DICTIONARY_SCN (GV$LOGMNR_DICTIONARY)
|
|
| EARLIEST_SCN (DBA_SUBSCRIPTIONS)
|
|
| EARLIEST_SCN (ALL_SUBSCRIPTIONS)
|
|
| EARLIEST_SCN (USER_SUBSCRIPTIONS)
|
|
| END_SCN (GV$LOGMNR_PARAMETERS)
|
|
| END_SCN (V$LOGMNR_PARAMETERS)
|
|
| FLASHBACK_SCN (DBA_REPEXTENSIONS)
| Flashback_scn for export or change-based recovery for replication extension
|
| HIGH_SCN (GV$LOGSTDBY)
|
|
| HIGH_SCN (V$LOGSTDBY)
|
|
| IGNORE_SCN (DBA_APPLY_INSTANTIATED_OBJECTS)
| SCN lower bound for messages that will be considered for apply
|
| INSTANTIATION_SCN (DBA_APPLY_INSTANTIATED_OBJECTS)
| Point in time when the object was instantiated at source
|
| LAST_REFRESH_SCN (USER_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
| LAST_REFRESH_SCN (USER_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
| LAST_REFRESH_SCN (ALL_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
| LAST_REFRESH_SCN (DBA_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
| LAST_REFRESH_SCN (DBA_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
| LAST_REFRESH_SCN (ALL_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
| LATEST_SCN (USER_SUBSCRIPTIONS)
|
|
| LATEST_SCN (ALL_SUBSCRIPTIONS)
|
|
| LATEST_SCN (DBA_SUBSCRIPTIONS)
|
|
| LOW_SCN (GV$LOGMNR_LOGS)
|
|
| LOW_SCN (V$LOGMNR_LOGS)
|
|
| NEWEST_SCN (DBA_LOGSTDBY_PROGRESS)
| The most recent SCN available on standby.
|
| NEXT_SCN (GV$LOGMNR_LOGS)
|
|
| NEXT_SCN (V$LOGMNR_LOGS)
|
|
| OLDEST_REFRESH_SCN (ALL_REFRESH_DEPENDENCIES)
| The oldest scn of a dependent materialized view
|
| READ_SCN (DBA_LOGSTDBY_PROGRESS)
| All log data less than this SCN has been preserved in the database
|
| REQUIRED_CHECKPOINT_SCN (DBA_CAPTURE)
| the safe SCN at which the meta-data for the capture process can be purged
|
| RESET_SCN (GV$LOGMNR_LOGS)
|
|
| RESET_SCN (V$LOGMNR_DICTIONARY)
|
|
| RESET_SCN (V$LOGMNR_LOGS)
|
|
| RESET_SCN (GV$LOGMNR_DICTIONARY)
|
|
| RESET_SCN_TIME (GV$LOGMNR_DICTIONARY)
|
|
| RESET_SCN_TIME (GV$LOGMNR_LOGFILE)
|
|
| RESET_SCN_TIME (GV$LOGMNR_LOGS)
|
|
| RESET_SCN_TIME (V$LOGMNR_DICTIONARY)
|
|
| RESET_SCN_TIME (V$LOGMNR_LOGS)
|
|
| RESET_SCN_TIME (V$LOGMNR_LOGFILE)
|
|
| SCN (ALL_SUMDELTA)
| SCN when the bulk DML occurred
|
| SCN (DBA_CAPTURE_PREPARED_TABLES)
| SCN from which changes can be captured
|
| SCN (DBA_FGA_AUDIT_TRAIL)
| SCN of the query
|
| SCN (GV$LOGMNR_CONTENTS)
|
|
| SCN (V$LOGMNR_CONTENTS)
|
|
| SCN (ALL_CAPTURE_PREPARED_TABLES)
| SCN from which changes can be captured
|
| SCN_NEEDED (V$RECOVERY_STATUS)
|
|
| SCN_NEEDED (GV$RECOVERY_STATUS)
|
|
| SOURCE_COMMIT_SCN (ALL_APPLY_ERROR)
| Original commit SCN for the transaction at the source database
|
| SOURCE_COMMIT_SCN (DBA_APPLY_ERROR)
| Original commit SCN for the transaction at the source database
|
| START_SCN (ALL_CAPTURE)
| The SCN from which capturing will be resumed
|
| START_SCN (V$LOGMNR_PARAMETERS)
|
|
| START_SCN (GV$LOGMNR_PARAMETERS)
|
|
| START_SCN (DBA_CAPTURE)
| The SCN from which capturing will be resumed
|