DBA_LOGSTDBY_PARAMETERS

DBA_LOGSTDBY_PARAMETERS contains the list of parameters used by the log apply services for logical standby databases.

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 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