-
MAX_SGA - System global area (SGA) allocated for the log apply services cache (in megabytes)
-
MAX_SLAVES - Number of parallel query servers specifically reserved for log apply services
-
MAX_EVENTS_RECORDED - Number of events stored in the DBA_LOGSTDBY_EVENTS view
-
TRANSACTION_CONSISTENCY - Shows the level of transaction consistency maintained (FULL, READ_ONLY, or NONE)
-
RECORD_SKIP_ERRORS - Indicates records that are skipped
-
RECORD_SKIP_DDL - Indicates skipped DDL statements
-
RECORD_APPLIED_DDL - Indicates applied DDL statements
-
FIRST_SCN - SCN at which log transport services will begin reading redo information
-
PRIMARY - Database ID of the database to which logs are being applied
-
LMNR_SID - LogMiner Session ID. This internal value indicates which LogMiner session is in use.
-
UNTIL_SCN - SCN value at which the log apply services will shut down all transactions that have been applied
-
END_PRIMARY_SCN - During a switchover, this value indicates the last SCN applied by the new primary from the old primary
-
NEW_PRIMARY_SCN - During a switchover, this value indicates the starting SCN for the new primary database
-
COMPLETED_SESSION - Indicates that the log apply services session has concluded. The value will indicate SWITCHOVER or FAILOVER, as appropriate.
-
PREPARE_SERVERS - Controls the number of parallel execution servers used to prepare changes
-
APPLY_SERVERS - Controls the number of parallel execution servers used to apply changes
-
APPLY_SCN - SCN value after which apply servers will begin applying redo information