Hidden Parameters in Oracle AI Database 26ai H.17 Data Guard (33)

 

Name	Type	Value	At default?	Level	PDB	RAC inst.	Flags	Description
_adg_adt_redirect_apply_lag_threshold	Integer	12000	yes	SYSTEM imm.	N	Y		Maximum centi-seconds of apply lag threshold
_adg_adt_redirect_catchup_wait_time	Integer	12000	yes	SYSTEM imm.	N	Y		Maximum centi-seconds for standby to catch up
_adg_auto_close_pdb	Boolean	TRUE	yes	SYSTEM imm.	N	Y		ADG recovery auto close PDB upon PDB drop/unplug/rename marker
_adg_count_beyond_limit	Integer	0	yes	SYSTEM imm.	N	Y		Count the total number of objects if beyond redo marker length.
_adg_defer_segstat	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Defer the segment statistics update on standby.
_adg_distributed_lockmaster	Boolean	FALSE	yes	STATIC	N	N		standby runs under ADG distributed lockmaster mode
_adg_influx_qscn_gap	Integer	0	yes	SYSTEM imm.	N	Y		maximum time gap between influx scn and qscn update in seconds
_adg_instance_recovery	Boolean	TRUE	yes	STATIC	N	N		enable ADG instance recovery
_adg_objectlock_attempts	Integer	2	yes	SYSTEM imm.	N	Y		Maximum attempts for objectlock get on ADG
_adg_objectlock_maxnum	Integer	1000	yes	SYSTEM imm.	N	Y		The maximum limit of the objectlock number on ADG
_adg_objectlock_timeout	Integer	0	yes	SYSTEM imm.	N	Y		timeout for objectlock get on ADG in centiseconds
_adg_parselock_holder_throttle_timeout	Integer	10	yes	SESSION	Y	Y		number of seconds ADG parse lock holders timeout on long waits
_adg_parselock_timeout	Integer	0	yes	SYSTEM imm.	N	Y		timeout for parselock get on ADG in centiseconds
_adg_parselock_timeout_sleep	Integer	100	yes	SYSTEM imm.	N	Y		sleep duration after a parselock timeout on ADG in milliseconds
_adg_redirect_upd_to_primary_max_retries	Integer	500	yes	SYSTEM imm.	N	Y		max retries for ADT redirect to Primary from ADG
_dg_broker_trace_level	String		yes	SYSTEM imm.	N	Y		data guard broker trace level
_dg_cf_check_timer	Integer	15	yes	SYSTEM imm.	N	Y		Data Guard controlfile check timer
_dg_corrupt_redo_log	Integer	0	yes	SYSTEM imm.	N	Y		Corrupt redo log validation during archivals
_dgb_dgpdb_appst	String		yes	SYSTEM imm.	N	N		DGPDBs with apply state off
_dgpdb_auto_task_defaults	String	enable_feature	yes	SYSTEM imm.	N	Y		options for DGPDB initialization
_dgpdb_cf_retention	Integer	10080	yes	SYSTEM imm.	N	Y		number of minutes to keep the control file copy made during role change to primary
_dgpdb_file_name_convert	String		yes	SYSTEM imm.	Y	Y		datafile name convert patterns and strings for per PDB standby
_dgpdb_pcf_cf_apply_time	Integer	600	yes	SYSTEM imm.	N	Y		DGPDB pcf to cf mark apply time in seconds
_dgpdb_pcf_cf_sync_time	Integer	43200	yes	SYSTEM imm.	N	Y		DGPDB pcf to cf sync time in seconds
_dgpdb_rc_notify_check_interval	Integer	5	yes	SYSTEM imm.	N	Y		number of minutes between attempts to send role change notifications to their prior primary site
_dgpdb_standby_controlfile_name	String	dgpdb_stdby_cf_pdbid_%u_%u_%u.cf	yes	STATIC	N	N		a name template with three %u's for DGPDB standby controlfile
_standby_auto_flashback	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Standby automatic flashback when primary flashed back
_standby_causal_heartbeat_timeout	Integer	2	yes	STATIC	N	N		readable standby causal heartbeat timeout
_standby_flush_mode	String	SLFLUSH	yes	STATIC	N	N		standby flush mode
_standby_implicit_rcv_timeout	Integer	3	yes	SYSTEM imm.	N	Y		minutes to wait for redo during standby implicit recovery
_standby_newkey_keystore_location	String		yes	SYSTEM imm.	N	Y		Location of keystore on standby having new key
_standby_switchover_timeout	Integer	120	yes	SYSTEM imm.	N	Y		Number of secords for standby switchover enqueue timeout
_standby_temp_file_management	String	AUTO	yes	SYSTEM imm.	N	Y		tempfile management on standby databases