-
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