NAME

VARCHAR2(30)

Name of the parameter:

• 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 table
• 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 applying 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.

VALUE

VARCHAR2(2000)

Value of the parameter