DBA_LOGSTDBY_PARAMETERS displays the list of parameters used by SQL apply for logical standby databases. This view is for logical standby databases only.

Column Datatype NULL Description
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 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

VALUE VARCHAR2(2000)   Value of the parameter