Hidden Parameters in Oracle AI Database 26ai H.3 In-Memory (255)

 

Name	Type	Value	At default?	Level	PDB	RAC inst.	Flags	Description
_imado_cdbmem_threshold	Integer	95	yes	SESSION	Y	Y		CDB Memory threshold percent for CDB-AIM action
_imado_diagtasks_log_period	Integer	5	yes	SYSTEM imm.	Y	Y		IM-ADO diagnostic tasks logging period (in seconds)
_imado_diagtasks_purge_period	Integer	30	yes	SYSTEM imm.	Y	Y		IM diagnostic tasks purge older than X days
_imado_disable_bg	Boolean	FALSE	yes	SESSION	Y	Y		Disable AIM background task for testing
_imado_disable_cdbaim	Boolean	FALSE	yes	SESSION	Y	Y		Disable CDB AIM
_imado_dml_const	Integer	100	yes	SESSION	Y	Y		AIM DML model overhead constant
_imado_enable_coloptim	Boolean	TRUE	yes	SESSION	Y	Y		Enable AIM Column level optimizations
_imado_enable_imadv	Boolean	TRUE	yes	SESSION	Y	Y		Enable IM Size Advisor View
_imado_enhancements	Integer	0	yes	SESSION	Y	Y		AIM enhancements
_imado_evict_sf	Integer	2	yes	SESSION	Y	Y		AIM evict safety factor
_imado_mem_threshold	Integer	98	yes	SESSION	Y	Y		Memory threshold percent for AIM action
_imado_optim_algo	String	GREEDY	yes	SESSION	Y	Y		Optimization algorithm for AIM
_imado_optimize_period	Integer	0	yes	SESSION	Y	Y		IM-store optimize period for AIM (in minutes)
_imado_sysaux_usage_limit	Integer	90	yes	SYSTEM imm.	Y	Y		SYSAUX usage percent limit for storing AIM diagnostics
_imado_verification	Integer	0	yes	SESSION	Y	Y		AIM verification state
_imu_pools	Integer	3	yes	STATIC	N	N		in memory undo pools
_inmemory_64k_percent	Integer	30	yes	STATIC	N	N		percentage of in-memory area for 64k pools
_inmemory_adg_batched_flush	Boolean	TRUE	yes	SYSTEM imm.	N	Y		If true, batched flush is performed
_inmemory_adg_initial_grow_size	Integer	200	yes	SYSTEM imm.	N	Y		IMA ADG autogrow initial grow size in MB
_inmemory_adg_journal_quota	Boolean	FALSE	yes	SYSTEM imm.	N	Y		If true, throttled mining is performed under space pressure
_inmemory_adg_parallel_flush	Boolean	TRUE	yes	SYSTEM imm.	N	Y		If true, parallel flush is performed
_inmemory_adg_periodic_sort	Boolean	FALSE	yes	SYSTEM imm.	N	Y		If true, periodic sort is performed
_inmemory_adg_quiesce_timeout	Integer	2	yes	SYSTEM imm.	Y	Y		timeout for getting ZQ enq
_inmemory_adjust_overprovisioning	Integer	1	yes	SYSTEM imm.	N	Y		IMA background overprovisioning shrink
_inmemory_analyzer_optimize_for	Integer	0	yes	SESSION	Y	N		inmemory analyzer optimize for
_inmemory_area_autotune	Boolean	TRUE	yes	SYSTEM imm.	N	Y		if TRUE, allow imc to grow/shrink in broker's auto tuning.
_inmemory_auto_distribute	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		If true, enable auto distribute
_inmemory_autodist_2safe	Boolean	FALSE	yes	SYSTEM imm.	N	Y		If true, enable auto distribute with 2safe
_inmemory_bf_disable_threshold	Integer	0	yes	SESSION	Y	Y		Threshold to disable IM bloom filter
_inmemory_bg_max_growstep	Big integer	134217728	yes	SYSTEM imm.	N	Y		max grow step size for im grow in bg
_inmemory_bg_resize_frequency	Integer	4	yes	SYSTEM imm.	N	Y		IMA background resize task frequency in minutes
_inmemory_bg_resize_limit	Integer	64	yes	SYSTEM imm.	N	Y		IMA background resize per task limit in GB
_inmemory_bg_resize_target_sga_percent	Integer	50	yes	SYSTEM imm.	Y	Y		IMA max background resize target as SGA percent
_inmemory_buffer_waittime	Integer	100	yes	SYSTEM imm.	Y	Y		wait interval for one SMU or IMCU to be freed
_inmemory_check_prot_meta	Boolean	FALSE	yes	STATIC	Y	N		If true, marks SMU area read only to prevent stray writes
_inmemory_checksum	Boolean	FALSE	yes	SYSTEM imm.	N	Y		If true, checksums in-memory area to detect stray writes
_inmemory_crclone_buffer_size	Integer	131072	yes	SYSTEM imm.	Y	Y		In-memory CR Clone buffer size
_inmemory_crclone_min_clones	Integer	6	yes	SYSTEM imm.	Y	Y		In-memory CR Clone minimum number of clones
_inmemory_crclone_min_space_percent	Integer	50	yes	SYSTEM imm.	Y	Y		In-memory CR Clone minimum space percentage
_inmemory_crclone_threshold_rows	Integer	100	yes	SYSTEM imm.	Y	Y		In-memory CR Clone threshold rows
_inmemory_credential	Integer	0	yes	SESSION	Y	Y		Enable in-memory resource principals
_inmemory_cu_checksum	Boolean	FALSE	yes	STATIC	N	N		If true, checksums CU to detect stray writes
_inmemory_cudrop_timeout	Integer	1000	yes	SYSTEM imm.	Y	Y		maximum wait time for IMCU to be freed during drop
_inmemory_dbg_retry_ext	Boolean	FALSE	yes	SESSION	Y	Y		Debug retry load inmemory extern table
_inmemory_dbg_scan	Integer	0	yes	SESSION	Y	Y		In-memory scan debugging
_inmemory_deepvec_transform	String	DISABLED	yes	SESSION	Y	Y		Enable plan transformation for in-memory deep vectorization
_inmemory_default_flags	Integer	8459	yes	SESSION	Y	Y		Default flags based on inmemory_clause_default
_inmemory_default_new	Boolean	FALSE	yes	SESSION	Y	Y		Force in-memory on new tables
_inmemory_default_svc	Integer	0	yes	SESSION	Y	Y		Default In-Memory distribute service type for new tables
_inmemory_default_svcname	String		yes	SESSION	Y	Y		Default In-Memory distribute service name for new tables
_inmemory_delta_population	Integer	0	yes	SYSTEM imm.	Y	Y		Control Delta IMCU population
_inmemory_direct_reads	Integer	1	yes	SYSTEM imm.	Y	Y		direct-reads for SMUs population repopulation
_inmemory_disable_alter_imco_cycle	Boolean	FALSE	yes	SESSION	Y	Y		in-memory disable alter imco cycle
_inmemory_disable_selective_vircols	Boolean	FALSE	yes	STATIC	N	N		disable selective columns for VCs/IMEs
_inmemory_distribute_ondemand_timeout	Integer	300	yes	SYSTEM imm.	N	Y		On demand timeout for redistribute
_inmemory_distribute_timeout	Integer	300	yes	SYSTEM imm.	N	Y		If true, enable auto distribute with 2safe
_inmemory_drcancel_cu_percent	Integer	80	yes	SYSTEM imm.	N	Y		IMCU percentage threshold to switch from DR to BC
_inmemory_dynamic_scan_disable_threshold	Integer	20	yes	SESSION	Y	Y		Inmemory dynamic scan disable threshold
_inmemory_dynamic_scans	String	AUTO	yes	SESSION	Y	Y		Enable IM Dynamic Scans
_inmemory_dynamic_scans_analyze_batch_size	Integer	5	yes	SESSION	Y	Y		Inmemory dynamic scan analyze batch size
_inmemory_dynamic_scans_batch_size	Integer	500	yes	SESSION	Y	Y		Number of steady state outstanding tasks
_inmemory_dynamic_scans_dbg	Integer	0	yes	SESSION	Y	Y		Inmemory dynamic scans debug
_inmemory_dynamic_scans_result_buffers	Integer	5000	yes	SESSION	Y	Y		No. of LWT allocated result buffers per thread
_inmemory_enable_bg_resize	Integer	0	yes	SYSTEM imm.	N	Y		IMA enable background resize operation
_inmemory_enable_bg_step_grow	Integer	0	yes	SYSTEM imm.	N	Y		IMA enable background resize step grow
_inmemory_enable_population_verify	Integer	1	yes	SESSION	Y	Y		verify in-memory population
_inmemory_enable_readonly	Boolean	TRUE	yes	SESSION	Y	Y		Enable Inmemory on read only DB instance
_inmemory_enable_shrink	Integer	1	yes	SYSTEM imm.	N	Y		IMA enable shrink support
_inmemory_enable_stat_alert	Boolean	FALSE	yes	SESSION	Y	Y	deprecated	dump in-memory stats in alert log file
_inmemory_enable_sys	Boolean	FALSE	yes	SYSTEM imm.	N	Y		enable in-memory on system tablespace with sys user
_inmemory_enable_tiny_im	Boolean	FALSE	yes	SYSTEM imm.	N	Y		IMA enable tiny IM support
_inmemory_enabled	Boolean	FALSE	yes	STATIC	N	N		enable in-memory
_inmemory_exclto_timeout	Integer	100	yes	SYSTEM imm.	Y	Y		maximum wait time to pin SMU for cleanout
_inmemory_expression_count	Integer	20	yes	SYSTEM imm.	Y	Y		IME number of expressions to lookup from the ESS
_inmemory_expressions_area_percent	Integer	10	yes	SYSTEM imm.	Y	Y		percentage of in-memory area for IMEUs
_inmemory_expressions_mark_unused	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Mark cold IME expressions unused instead of no inmemory
_inmemory_ext_roarea	Big integer	0	yes	SYSTEM imm.	N	Y		size in bytes of inmemory rw extension area
_inmemory_ext_rwarea	Big integer	0	yes	SYSTEM imm.	N	Y		size in bytes of inmemory rw extension area
_inmemory_external_table	Boolean	TRUE	yes	SESSION	Y	Y		Enable inmemory extern table
_inmemory_faststart_control_flags	Big integer	0	yes	SYSTEM imm.	Y	Y		in-memory faststart control flags
_inmemory_force_fs	Boolean	FALSE	yes	STATIC	N	N		in-memory faststart force
_inmemory_force_fs_tbs	String	SYSAUX	yes	STATIC	N	N		in-memory faststart force tablespace
_inmemory_force_fs_tbs_size	Big integer	1073741824	yes	STATIC	N	N		in-memory faststart force tablespace size
_inmemory_force_jgca_resizing	Integer	0	yes	SESSION	Y	Y		Inmemory Force Join Group Code Array Resizing
_inmemory_force_non_engineered	Boolean	FALSE	yes	STATIC	N	N		force non-engineered systems in-memory behavior on RAC
_inmemory_format_compatible	String	23.7.0.0.0	yes	SYSTEM imm.	Y	Y		In-memory format compatibility parameter
_inmemory_fs_blk_inv_blk_percent	Integer	50	yes	SYSTEM imm.	Y	Y		in-memory faststart CU invalidation threshold(blocks)
_inmemory_fs_blk_inv_blkcnt	Boolean		yes	SYSTEM imm.	Y	Y		in-memory faststart CU invalidation threshold(blocks)
_inmemory_fs_dmlverify_read_ahead_cnt	Integer	10	yes	SYSTEM imm.	Y	Y		in-memory faststart dmlverify read ahead count
_inmemory_fs_enable	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		in-memory faststart enable
_inmemory_fs_enable_blk_lvl_inv	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		in-memory faststart enable block level invalidation
_inmemory_fs_imco_timeout	Integer	120000	yes	SESSION	Y	Y		InMemory FastStart IMCO wait timeout in Gen-0
_inmemory_fs_nodml	Boolean	FALSE	yes	SESSION	Y	Y		in-memory faststart assumes no dmls while populating
_inmemory_fs_prune_pct	Integer	10	yes	SYSTEM imm.	Y	Y		in-memory faststart out of mem prune percent
_inmemory_fs_raise_error	Boolean	FALSE	yes	SESSION	Y	Y		in-memory faststart raise error
_inmemory_fs_tbsmaxsz	Big integer		yes	SYSTEM imm.	Y	Y		in-memory faststart tablespace maximum size
_inmemory_fs_test_flags	Integer	0	yes	SESSION	Y	Y		InMemory FastStart testing flags
_inmemory_fs_verify	Boolean	FALSE	yes	SESSION	Y	Y		in-memory faststart verify
_inmemory_fsdw_cnt	Integer	2147483647	yes	SYSTEM imm.	Y	Y		in-memory faststart defer writes per cycle
_inmemory_fsdw_enable	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		in-memory faststart deferwrite enable
_inmemory_fsdw_inline	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		in-memory faststart deferwrite inline
_inmemory_fsdw_maxcnt	Integer	10	yes	SYSTEM imm.	Y	Y		in-memory faststart max defer writes per cycle
_inmemory_fsdw_maxmem	Big integer	104755200	yes	SYSTEM imm.	Y	Y		in-memory faststart max defer writes memory cap
_inmemory_fsdw_on_populate	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		in-memory faststart deferwrite on populate
_inmemory_fsdw_penalty_threshold	Big integer	20	yes	SYSTEM imm.	Y	Y		in-memory faststart deferwrite penalty threshold
_inmemory_fsdw_populate_threshold_multiplier	Big integer	10	yes	SYSTEM imm.	Y	Y		in-memory faststart deferwrite populate threshold multiplier
_inmemory_fsdw_priority_penalty_percent	Integer	10	yes	SYSTEM imm.	Y	Y		In-memory faststart defer write percent priority for penalized
_inmemory_fsdw_priority_population_percent	Integer	100	yes	SYSTEM imm.	Y	Y		In-memory faststart defer write percent priority for population
_inmemory_fsdw_priority_repopulation_percent	Integer	90	yes	SYSTEM imm.	Y	Y		In-memory faststart defer write percent priority for repopulation
_inmemory_fsdw_schedlrtm	Big integer	1	yes	SYSTEM imm.	Y	Y		in-memory faststart defer write scheduler cycle (sec)
_inmemory_fsdw_scheduler_dedicated	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		in-memory faststart defer write dedicated scheduler
_inmemory_fsdw_task_timeout	Big integer	20	yes	SYSTEM imm.	Y	Y		in-memory faststart defer writes task timeout (sec)
_inmemory_fsdw_threshold	Integer	300	yes	SYSTEM imm.	Y	Y		In-memory faststart defer write minimum interval (millisec)
_inmemory_gd_sym_dict_flags	Integer	1	yes	SESSION	Y	Y		Inmemory GD symbol dictionary flags
_inmemory_granule_size	Big integer	134217728	yes	SYSTEM imm.	N	Y		In-memory granule size
_inmemory_graph_pop_fg	Boolean	FALSE	yes	SESSION	Y	Y		If true, all graph populations are performed in foreground
_inmemory_grpcolinv_buffer_size	Integer	131072	yes	SYSTEM imm.	Y	Y		In-memory grpcolinv buffer size
_inmemory_grpcolinv_granularity	Integer	1	yes	SYSTEM imm.	Y	Y		In-memory grpcolinv blks per colmap
_inmemory_hpk4sql_debug	Integer	0	yes	SESSION	Y	Y		In-Memory HPK4SQL debug
_inmemory_hpk4sql_filter_threshold	Integer	1	yes	SESSION	Y	Y		In-Memory HPK4SQL filter threshold
_inmemory_hpk4sql_flags	Integer	0	yes	SESSION	Y	Y		In-Memory HPK4SQL flags
_inmemory_hpk4sql_kv_seg_size	Integer	21	yes	SESSION	Y	Y		In-Memory HPK4SQL kv segment size
_inmemory_hpk4sql_partbuf_maxrow	Integer	1024	yes	SESSION	Y	Y		In-Memory HPK4SQL partbuf maxrow
_inmemory_hpk4sql_partbuf_minrow	Integer	8	yes	SESSION	Y	Y		In-Memory HPK4SQL partbuf minrow
_inmemory_hpk4sql_pushdown_level	Integer	65535	yes	SESSION	Y	Y		In-Memory HPK4SQL maximun pushdown level
_inmemory_hwm_expand_percent	Integer	20	yes	SYSTEM imm.	N	Y		max blks percent can exceed in hwmimcu
_inmemory_hwm_expansion	Integer	1	yes	SYSTEM imm.	Y	Y		If 0, the highwatermark CU is dropped when expanded
_inmemory_hwm_expansion_rac	Integer	0	yes	STATIC	Y	N		If 0, the highwatermark CU is dropped when expanded
_inmemory_hwm_inv_blocks_threshold	Integer	64	yes	SYSTEM imm.	Y	Y		If 0, expansion will occur even for very small hwm imcu
_inmemory_hybrid_selectivity_threshold	Integer	37	yes	SESSION	Y	Y		Selectivity threshold for a qualifying query to enable hybrid IM scans
_inmemory_hybridexa_enable	Boolean	TRUE	yes	SESSION	Y	Y		Inmemory Hybrid Exa Enabled
_inmemory_imco_cycle	Integer	120	yes	SYSTEM imm.	N	Y		IMCO cycle in seconds (sleep period)
_inmemory_imcu_align	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Enforce 8M IMCU alignment
_inmemory_imcu_populate_minbytes	Big integer	5242880	yes	SYSTEM imm.	N	Y		minimum free space in IMA for populating IMCU
_inmemory_imcu_source_analyze_bytes	Integer	134217728	yes	SYSTEM imm.	N	Y		number of source analyze bytes per IMCU
_inmemory_imcu_source_blocks	Integer	0	yes	SYSTEM imm.	N	Y		number of source blocks per IMCU
_inmemory_imcu_source_extents	Integer	0	yes	SYSTEM imm.	N	Y		number of source extents per IMCU
_inmemory_imcu_source_maxbytes	Integer	0	yes	SYSTEM imm.	N	Y		IMCU maximum source size in bytes
_inmemory_imcu_source_minbytes	Integer	1048576	yes	SYSTEM imm.	N	Y		number of minimum source bytes per IMCU
_inmemory_imcu_target_bytes	Integer	0	yes	SYSTEM imm.	N	Y		IMCU target size in bytes
_inmemory_imcu_target_maxrows	Integer	8388608	yes	SYSTEM imm.	N	Y		IMCU maximum target number of rows
_inmemory_imcu_target_rows	Integer	0	yes	SYSTEM imm.	N	Y		IMCU target number of rows
_inmemory_ime_increpop_threshold	Integer	1	yes	SYSTEM imm.	Y	Y		Invalidation threshold for IME incremental repopulation
_inmemory_incremental_repopulation	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		If true, incremental repopulation of IMCU will be attempted
_inmemory_invalidate_cursors	Boolean	TRUE	yes	SESSION	Y	Y		In-memory populate enable cursor invalidations
_inmemory_jgbvt_slotsz	Integer	6	yes	SESSION	Y	Y		Inmemory Join Group Bit Vector Table Segment Slot Size Exp
_inmemory_journal_check	Integer	0	yes	SESSION	Y	Y		Depending on value does one of the DML verifications
_inmemory_journal_cla_stride	Integer	4	yes	STATIC	N	N		inmemory journal format cla stride
_inmemory_journal_format	Integer	1	yes	STATIC	N	N		inmemory journal format options
_inmemory_journal_row_logging	Boolean	FALSE	yes	STATIC	N	N		If true, log the entire row into the in-memory journal
_inmemory_journal_scan	Integer	0	yes	SESSION	Y	Y		inmemory journal scan enable
_inmemory_journal_scan_format	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		If true, the set journal format will be used for scan
_inmemory_lock_for_smucreate	Boolean	FALSE	yes	STATIC	Y	N		take object lock during smu creation
_inmemory_log_level	Integer	0	yes	SESSION	Y	Y		in-memory log level
_inmemory_max_delta	Integer	5	yes	SYSTEM imm.	Y	Y		Inmemory max number of deltas per CU
_inmemory_max_expressions_table	Integer	50	yes	SYSTEM imm.	Y	Y		IME maximum number of SYS_IME VCs in a table
_inmemory_max_pga_usage_percent	Integer	50	yes	SYSTEM imm.	Y	Y		Allowed PGA usage for IME creation as a percent of hard maximum
_inmemory_max_pga_usage_percol	Integer	20	yes	SYSTEM imm.	Y	Y		Allowed PGA usage (in MB) for IME creation per column
_inmemory_max_populate_retry	Integer	3	yes	SYSTEM imm.	N	Y		IM populate maximum number of retry
_inmemory_max_queued_tasks	Integer	0	yes	SYSTEM imm.	N	Y		Maximum queued populating tasks on the auxiliary queue
_inmemory_memprot	Boolean	FALSE	yes	STATIC	N	N		enable or disable memory protection for in-memory
_inmemory_metadata_pct	Integer	0	yes	STATIC	N	N		controls the pct of IM metadata space
_inmemory_min_delta_blocks	Integer	50	yes	SYSTEM imm.	Y	Y		Inmemory minimum blocks per delta
_inmemory_min_delta_rows	Integer	255	yes	SYSTEM imm.	Y	Y		Inmemory minimum rows per delta
_inmemory_min_ima_defersize	Big integer	0	yes	SYSTEM imm.	N	Y		Defer in-memory area allocation beyond this size
_inmemory_num_hash_latches	Integer	256	yes	STATIC	N	N		Maximum number of latches for IM buffers
_inmemory_opaque_contig_space_percent	Integer	80	yes	SYSTEM imm.	Y	Y		Contiguous memory for opaque VC as a percent of hard maximum
_inmemory_optimized_date_options	Integer	6	yes	SESSION	Y	Y		Creates hidden virtual columns for accelerating date queries
_inmemory_parallel_jghj_enabled	Boolean	TRUE	yes	SESSION	Y	Y		Inmemory Parallel Join Group aware HJ
_inmemory_parallel_load_ext	Boolean	TRUE	yes	SESSION	Y	Y		Parallel load inmemory extern table
_inmemory_partrowlock_threshold	Integer	10	yes	SYSTEM imm.	Y	Y		Number of committed rows that stay not cleaned out
_inmemory_patch_background_blocks	Integer	200	yes	SYSTEM imm.	N	Y		In-memory SMU patch threshold blocks to start background tasks
_inmemory_patch_commit_path	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		If true, enable the SMU patching from DML path
_inmemory_patch_threshold_blocks	Integer	25	yes	SYSTEM imm.	N	Y		In-memory SMU patch threshold blocks
_inmemory_pct_inv_blocks_invalidate_imcu	Integer	100	yes	SESSION	Y	Y		In-memory percentage invalid blocks for IMCU invalidation
_inmemory_pct_inv_rows_invalidate_imcu	Integer	50	yes	SESSION	Y	Y		In-memory percentage invalid rows for IMCU invalidation
_inmemory_pga_per_server	Big integer	536870912	yes	SYSTEM imm.	N	Y		minimum pga needed per inmemory populate server
_inmemory_pin_hist_mode	Integer	16	yes	SYSTEM imm.	Y	Y		settings for IM pinned buffer history
_inmemory_populate_blocks_threshold	Integer	8	yes	SYSTEM imm.	Y	Y		If 0, scan triggers populate for any missing blocks
_inmemory_populate_fg	Boolean	FALSE	yes	STATIC	N	N		populate in foreground
_inmemory_populate_grow_trigger_percent	Integer	10	yes	SYSTEM imm.	N	Y		IMA trigger for populate size grow as percent of available space
_inmemory_populate_task_self_exec	Integer	0	yes	SESSION	Y	Y		In-Memory racgd populate tasks self execution
_inmemory_populate_test_flags	Integer	0	yes	SYSTEM imm.	Y	Y		In-memory populate test flags
_inmemory_populate_wait	Boolean	FALSE	yes	SESSION	Y	Y		wait for population to complete
_inmemory_populate_wait_max	Integer	600	yes	SYSTEM imm.	N	Y		maximum wait time in seconds for segment populate
_inmemory_prefer_xmem_memcompress	String		yes	STATIC	N	N		Prefer to store tables with given memcompress levels in xmem
_inmemory_prefer_xmem_priority	String		yes	STATIC	N	N		Prefer to store tables with given priority levels in xmem
_inmemory_prefix_encode_dsbs	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Prefix-encode the DSB-dictionary
_inmemory_prepopulate	Boolean	TRUE	yes	SYSTEM imm.	N	Y		Enable inmemory populate by IMCO
_inmemory_prepopulate_fg	Integer	0	yes	SYSTEM imm.	N	Y		Force prepopulate of in-memory segment in foreground
_inmemory_private_journal_aonumbkts	Integer	16	yes	SYSTEM imm.	Y	Y		Number of priv jrnl anchor object ht bkts
_inmemory_private_journal_dynamic	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		If true, dynamic sizing will be enabled
_inmemory_private_journal_grplen	Integer	64	yes	SYSTEM imm.	Y	Y		Number of blocks per PJ group
_inmemory_private_journal_maxexts	Integer	5000000	yes	SYSTEM imm.	Y	Y		Max number of extents per PJ
_inmemory_private_journal_numbkts	Integer	2048	yes	SYSTEM imm.	Y	Y		Number of priv jrnl ht bkts
_inmemory_private_journal_numgran	Integer	32	yes	SYSTEM imm.	Y	Y		Number of granules per HT node
_inmemory_private_journal_quota	Integer	100	yes	SYSTEM imm.	N	Y		quota for transaction in-memory private journals
_inmemory_private_journal_sharedpool_quota	Integer	20	yes	SYSTEM imm.	N	Y		quota for transaction in-memory objects
_inmemory_pruning	String	ON	yes	SESSION	Y	Y		In-memory pruning
_inmemory_query_check	Integer	0	yes	SESSION	Y	Y		In-memory query checking
_inmemory_query_fetch_by_rowid	Boolean	FALSE	yes	SESSION	Y	Y		In-memory fetch-by-rowid enabled
_inmemory_query_scan	Boolean	TRUE	yes	SESSION	Y	Y		In-memory scan enabled
_inmemory_racgd_flags	Integer	0	yes	SESSION	Y	Y		Inmemory distributed GD flags
_inmemory_racgd_msg_threshold	Integer	60	yes	SESSION	Y	Y		In-Memory Racgd add message threshold
_inmemory_racgd_verify_populate	Boolean	FALSE	yes	SESSION	Y	Y		Inmemory RACGD Populate Verify
_inmemory_relimcusz_thresh	Integer	25	yes	SYSTEM imm.	Y	Y		in-memory relative imcusz thresh for direct reads
_inmemory_repopulate_disable	Integer	2	yes	SESSION	Y	Y		disable In-memory repopulate
_inmemory_repopulate_flags	Integer	2	yes	SYSTEM imm.	Y	Y		In-memory repopulate decision flags
_inmemory_repopulate_invalidate_rate_percent	Integer	0	yes	SESSION	Y	Y		In-memory repopulate invalidate rate percent
_inmemory_repopulate_optimize	Boolean	TRUE	yes	SYSTEM imm.	Y	Y		If true, itl transfer will be attempted during repopulation of IMCU
_inmemory_repopulate_priority_scale_factor	Integer	100	yes	SESSION	Y	Y		In-memory repopulate priority threshold scale factor
_inmemory_repopulate_priority_threshold_block	Integer	320	yes	SESSION	Y	Y		In-memory repopulate priority threshold block
_inmemory_repopulate_priority_threshold_row	Integer	160	yes	SESSION	Y	Y		In-memory repopulate priority threshold row
_inmemory_repopulate_threshold_blocks	Integer		yes	SESSION	Y	Y		In-memory repopulate threshold number of modified blocks
_inmemory_repopulate_threshold_blocks_percent	Integer	10	yes	SESSION	Y	Y		In-memory repopulate threshold blocks invalid percentage
_inmemory_repopulate_threshold_mintime	Integer	0	yes	SESSION	Y	Y		In-memory repopulate minimum interval (millisec)
_inmemory_repopulate_threshold_mintime_factor	Integer	5	yes	SESSION	Y	Y		In-memory repopulate minimum interval (N*timetorepop)
_inmemory_repopulate_threshold_rows	Integer		yes	SESSION	Y	Y		In-memory repopulate threshold number of modified rows
_inmemory_repopulate_threshold_rows_percent	Integer	5	yes	SESSION	Y	Y		In-memory repopulate threshold rows invalid percentage
_inmemory_repopulate_threshold_scans	Integer	0	yes	SESSION	Y	Y		In-memory repopulate threshold number of scans
_inmemory_retention_time	Integer	120	yes	SYSTEM imm.	Y	Y		maximum retention time of imcu after repopulation
_inmemory_rows_check_interrupt	Integer	1000	yes	SYSTEM imm.	N	Y		Number of rows buffered before interrupt check
_inmemory_rw_pool	Integer	5	yes	STATIC	N	N		controls the use of the IM rw pool
_inmemory_scan_invalid_percent	Integer	30	yes	SYSTEM imm.	Y	Y		Inmemory scan invalid percentage
_inmemory_scan_override	Boolean	FALSE	yes	SESSION	N	N		In-memory scan override
_inmemory_servers_throttle_pgalim_percent	Integer	55	yes	SYSTEM imm.	N	Y		In-memory populate servers throttling pga limit percentage
_inmemory_shared_journal_maxexts	Integer	1024	yes	SYSTEM imm.	Y	Y		Max number of extents per SJ
_inmemory_shared_journal_minexts_repop	Integer	256	yes	SYSTEM imm.	Y	Y		min number of extents per SJ to trigger repop
_inmemory_shrink	Integer	0	yes	SESSION	Y	Y		In-memory shrink
_inmemory_shrink_cleanout_timeout	Integer	180	yes	SESSION	Y	Y		IMCO shrink cleanout timeout
_inmemory_shrink_control_flags	Integer	0	yes	SYSTEM imm.	Y	Y		In-memory shrink control flags
_inmemory_shrink_gc_retries	Integer	3	yes	SYSTEM imm.	Y	Y		In-memory shrink gc retries
_inmemory_shrink_test_flags	Integer	0	yes	SYSTEM imm.	Y	Y		In-memory shrink test flags
_inmemory_size_enable_shrink	Boolean	TRUE	yes	SYSTEM imm.	N	Y		if TRUE, allow broker to shrink imc during auto tuning.
_inmemory_small_segment_threshold	Big integer	65536	yes	SYSTEM imm.	N	Y		In-memory small segment threshold (must be larger for in-memory)
_inmemory_smu_patch_options	Integer	7	yes	SYSTEM imm.	Y	Y		Inmemory SMU patching options
_inmemory_strdlxid_timeout	Integer	0	yes	SYSTEM imm.	Y	Y		max time to determine straddling transactions
_inmemory_subcu_histsize	Integer	0	yes	SESSION	Y	Y		In-memory subCU Histogram size
_inmemory_subcusize	Integer	512	yes	SESSION	Y	Y		In-memory subCU size
_inmemory_succesive_bg_rsz_interval	Integer	9000	yes	SYSTEM imm.	N	Y		broker inmemory resize success intervals .
_inmemory_suppress_vsga_ima	Boolean	FALSE	yes	SESSION	Y	Y		Suppress inmemory area in v$sga
_inmemory_test_verification	Integer	0	yes	SESSION	Y	Y		In-memory verification testing
_inmemory_transaction_options	Integer	10998	yes	SYSTEM imm.	Y	Y		in-memory transaction performance options
_inmemory_trickle_populate	Boolean	TRUE	yes	SESSION	Y	Y		Enable inmemory trickle populate
_inmemory_trickle_repopulate	Boolean	TRUE	yes	SESSION	Y	Y		Enable inmemory trickle repopulate
_inmemory_trickle_repopulate_fg	Integer	0	yes	SYSTEM imm.	N	Y		Trickle Repopulate in the Foreground
_inmemory_trickle_repopulate_min_interval	Integer	300	yes	SYSTEM imm.	N	Y		IMCO Trickle Repopulate Interval
_inmemory_trickle_repopulate_threshold_dirty_ratio	Integer	0	yes	SYSTEM imm.	N	Y		IMCO Trickle Repopulate threshold dirty ratio
_inmemory_txn_checksum	Integer	0	yes	SYSTEM imm.	Y	Y		checksum for SMUs and private journals
_inmemory_txnpjrnl_debug	Integer	0	yes	SESSION	Y	Y		txn priv jrnl debugging parameter
_inmemory_validate_fetch	Boolean	FALSE	yes	SYSTEM imm.	N	Y		If true, validate single-row fetch between in-memory and disk
_inmemory_vector_encode_override	Boolean	FALSE	yes	SYSTEM imm.	Y	Y		Populate and use DSBs for Vector Encode columns
_inmemory_waitinvis_count	Integer	8	yes	SYSTEM imm.	Y	Y		in-memory waitinvisible retry count
_inmemory_xmem_size	Big integer	0	yes	SYSTEM imm.	Y	Y		size in bytes of in-memory xmem area
_inmemory_xt_virtual_columns	String	DISABLE	yes	SYSTEM imm.	Y	Y		Controls which user-defined VCs in external tables are stored in-memory