Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
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 contains the list of parameters used by the log apply services for logical standby databases.

Column Datatype NULL Description



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 of the parameter