Hidden Parameters in Oracle AI Database 26ai H.19 Auto-maintained __ parameters (61)

 

Name	Type	Value	At default?	Level	PDB	RAC inst.	Flags	Description
__alter_adg_redirect_behavior	Integer	1	yes	SYSTEM imm.	Y	Y		Alter ADG's Redirection behavior - internal
__asm_max_connected_clients	Integer	3	yes	SYSTEM imm.	N	Y		The high water mark value for connected clients
__bct_last_dba_buffer_size	Big integer	0	yes	SESSION	Y	Y		Last running dynamically resized dba buffer size, in bytes
__cnf	Integer	100	yes	SYSTEM imm.	Y	Y		CNF
__data_transfer_cache_size	Big integer	0	no (was 0)	SYSTEM imm.	N	Y		Actual size of data transfer cache
__datamemory_area_size	Big integer	0	no (was 0)	SYSTEM imm.	N	Y		Actual total size in bytes of inmemory area
__db_16k_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended cache metadata for 16k buffer pool
__db_2k_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended cache metadata for 2k buffer pool
__db_32k_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended cache metadata for 32k buffer pool
__db_4k_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended cache metadata for 4k buffer pool
__db_8k_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended cache metadata for 8k buffer pool
__db_cache_size	Big integer	1761607680	no (was 0)	SYSTEM imm.	N	Y		Actual size of DEFAULT buffer pool for standard block size buffers
__db_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended memory metadata of DEFAULT buffer pool for standard block size buffers
__db_keep_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended cache metadata of KEEP buffer pool for standard block size buffers
__db_lost_write_protect	Integer	3	yes	SYSTEM imm.	Y	Y		enable lost write detection - internal
__db_pmem_direct_map_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of PMEM memory metadata of DEFAULT buffer pool for standard block size buffers
__db_recycle_cache_xmem_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended memory metadata of recycle buffer pool for standard block size buffers
__dg_broker_service_names	String		yes	SYSTEM imm.	N	Y		service names for broker use
__inmemory_ext_roarea	Big integer	0	no (was 0)	SYSTEM imm.	N	Y		Actual size in bytes of inmemory ro extension area
__inmemory_ext_rwarea	Big integer	0	no (was 0)	SYSTEM imm.	N	Y		Actual size in bytes of inmemory rw extension area
__inmemory_size	Big integer	0	yes	SYSTEM imm.	N	Y		unused inmemory size dummy param for compatibility
__java_pool_size	Big integer	251658240	no (was 0)	SYSTEM imm.	N	Y		Actual size in bytes of java pool
__kstrc_qa_credentials	String		yes	SYSTEM imm.	Y	Y		KSTRC credentials for QA mode
__large_pool_size	Big integer	16777216	no (was 0)	SYSTEM imm.	N	Y		Actual size in bytes of large pool
__latch_test_param	Integer	0	yes	STATIC	N	N		latch test parameter
__log_committime_block_cleanout	Integer	2	yes	SYSTEM imm.	Y	Y		Log commit-time block cleanout - internal
__maintenance_is_planned	Integer	0	yes	SYSTEM imm.	N	Y		Is maintenance scheduled soon?
__managed_recovery_last_error	String		yes	SYSTEM imm.	Y	Y		Last error stack when managed recovery ends
__memoptimize_xmem_pool_size_metadata	Big integer	0	yes	SYSTEM imm.	N	Y		Size of extended cache metadata of MEMOPTIMIZE buffer pool for standard block size buffers
__oracle_base	String	/u01/app/oracle	no (was )	STATIC	N	N		ORACLE_BASE
__persistent_cl2_slave_size	Big integer	0	yes	STATIC	N	N		Actual size of slave cluster flash cache for default block size
__pga_aggregate_target	Big integer	1056964608	no (was 0)	SYSTEM imm.	N	Y		Current target size for the aggregate PGA memory consumed
__pre_update_rolling_rrp_compatibility	Big integer		yes	SYSTEM imm.	N	Y		pre update rrp enabled bug list
__previous_rolling_rrp_compatibility	Big integer		yes	SYSTEM imm.	N	Y		previous rrp enabled bug list
__reload_lsnr	String	0	yes	SYSTEM imm.	Y	Y		reload listener
__rolling_list_int_param_spare1	Big integer		yes	SYSTEM imm.	N	Y		list spare param 1
__rolling_list_int_param_spare2	Big integer		yes	SYSTEM imm.	N	Y		list spare param 2
__rolling_list_string_param_spare3	String	default	yes	SYSTEM imm.	N	Y		string list spare param 3
__rolling_rrp_boolean_param_spare1	Boolean	FALSE	yes	SYSTEM imm.	N	Y		spare boolean param 1
__rolling_rrp_compatibility	Big integer		yes	SYSTEM imm.	N	Y		rrp enabled bug list
__rolling_rrp_compatibility_homogeneity_check	Big integer		yes	SYSTEM imm.	N	Y		Enabled bugs are same in cluster
__rolling_rrp_disabled	Big integer		yes	SYSTEM imm.	N	Y		list of explicitly disabled rrp
__rolling_rrp_exceptions	Big integer		yes	SYSTEM imm.	N	Y		Exception rrp bug list
__rolling_rrp_int_spare1	Integer	0	yes	SYSTEM imm.	N	Y		Int spare param 1
__rolling_rrp_int_spare2	Integer	0	yes	SYSTEM imm.	N	Y		Int spare param 2
__rolling_rrp_intent_to_rollback	Boolean	FALSE	yes	SYSTEM imm.	N	Y		Record intent to rollback
__rolling_rrp_last_enable_version	String	23.1.0	yes	SYSTEM imm.	N	Y		VSNNUM where enable_all changed param
__rolling_rrp_previous_last_enable_version	String		yes	SYSTEM imm.	N	Y		previous last_enable param value
__rolling_rrp_simulate_binary_rrp	Integer	0	yes	SYSTEM imm.	N	Y		Test param to simulate binary RRP
__rolling_rrp_simulate_binary_rrp_with_cb	Integer	0	yes	SYSTEM imm.	N	Y		Test param to simulate binary RRP with callback
__rolling_rrp_simulate_one_off_rrp	Big integer		yes	SYSTEM imm.	N	Y		Test param to simulate rrp one-off list
__rolling_rrp_string_spare1	String		yes	SYSTEM imm.	N	Y		string spare param 1
__rolling_rrp_string_spare2	String		yes	SYSTEM imm.	N	Y		string spare param 2
__sess_template_test_attrs	Boolean	FALSE	yes	STATIC	N	N		session template: include test attributes
__sga_current_size	Big integer	0	yes	SYSTEM imm.	Y	Y		Current size for PDB SGA
__sga_target	Big integer	3154116608	no (was 0)	STATIC	N	N		Actual size of SGA
__shared_io_pool_size	Big integer	134217728	no (was 0)	SYSTEM imm.	N	Y		Actual size of shared IO pool
__shared_pool_size	Big integer	956301312	no (was 0)	SYSTEM imm.	N	Y		Actual size in bytes of shared pool
__streams_pool_size	Big integer	0	no (was 0)	SYSTEM imm.	N	Y		Actual size in bytes of streams pool
__unified_pga_pool_size	Big integer	0	no (was 0)	SYSTEM imm.	N	Y		Actual size in bytes of unified pga pool
__wait_test_param	Integer	0	yes	STATIC	N	N		wait test parameter