DBA_LOGSTDBY_PARAMETERS

• MAX_SGA - System global area (SGA) allocated for the log apply services cache (in megabytes)

• MAX_SERVERS - Number of processes used by SQL Apply services

• 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

• MAX_EVENTS_RECORDED - Number of events stored in the DBA_LOGSTDBY_EVENTS view

• RECORD_SKIP_ERRORS - Indicates records that are skipped

• RECORD_SKIP_DDL - Indicates skipped DDL statements

• RECORD_APPLIED_DDL - Indicates applied DDL statements

• RECORD_UNSUPPORTED_OPERATIONS - Shows whether SQL Apply will capture information about transactions that did unsupported operations at the primary database in the DBA_LOGSTDBY_EVENTS view

• EVENT_LOG_DEST - Indicates where SQL Apply records the occurrence of an interesting event

• LOG_AUTO_DELETE - Shows whether SQL Apply will automatically delete remote archived logs received from the primary database, once the contents of the logs are applied at the logical standby database.

• LOG_AUTO_DEL_RETENTION_TARGET - How many minutes a remote archived log received from the primary database will be retained at the logical standby database, once the contents of the log are applied by SQL Apply.

• PRESERVE_COMMIT_ORDER - Shows whether transactions are committed at the logical standby database in the same order that they were committed at the primary database

• SYSTEM - Parameter value was not explicitly set by the user. However, the user can change it with an appropriate call to the APPLY_SET procedure.

• USER - Parameter value was explicitly set by the user

NO if setting the parameter requires that SQL Apply be stopped