Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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