2023-04-07

23c free - spfile parameter changes

In the newly Oracle version 23c (available - but not yet production ready) some spfile parameters appeared (and disappeared) in comparison to 21.9. 
Most of these parameters are undocumented, so it will take some time to understand their impact. 
Still I prefer to have this list available and visible, so it's easier to understand changes and their impact when analyzing them. 

843 new parameters are:

NAME DEFAULT_VALUE DESCRIPTION ISSES_MODIFIABLE ISSYS_MODIFIABLE ISPDB_MODIFIABLE ISINSTANCE_MODIFIABLE ISDEPRECATED ISBASIC
_NUMA_pool_reservation_trace FALSE Show NUMA pool reservations at startup FALSE FALSE FALSE FALSE FALSE FALSE
__bct_last_dba_buffer_size 0 Last running dynamically resized dba buffer size, in bytes TRUE IMMEDIATE TRUE TRUE FALSE FALSE
__cnf 100 CNF FALSE IMMEDIATE TRUE TRUE FALSE FALSE
__inmemory_size 0 Actual size in bytes of inmemory area FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__pre_update_rolling_rrp_compatibility   pre update rrp enabled bug list FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_list_int_param_spare1   list spare param 1 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_list_int_param_spare2   list spare param 2 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_list_string_param_spare3 default string list spare param 3 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_boolean_param_spare1 FALSE spare boolean param 1 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_compatibility   rrp enabled bug list FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_disabled   list of explicitly disabled rrp FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_int_spare1 0 Int spare param 1 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_int_spare2 0 Int spare param 2 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_intent_to_rollback FALSE Record intent to rollback FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_last_enable_version 23.1.0 VSNNUM where enable_all changed param FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_simulate_binary_rrp 0 Test param to simulate binary RRP FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_simulate_binary_rrp_with_cb 0 Test param to simulate binary RRP with callback FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_simulate_one_off_rrp   Test param to simulate rrp one-off list FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_string_spare1   string spare param 1 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
__rolling_rrp_string_spare2   string spare param 2 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_aco_disable_options 0 ACO feature disable options FALSE FALSE FALSE FALSE FALSE FALSE
_active_dgpdb FALSE active PDB dataguard FALSE FALSE FALSE FALSE FALSE FALSE
_active_dgpdb_qscn_count 20 active PDB dataguard query SCN service max count FALSE FALSE FALSE FALSE FALSE FALSE
_affected_row_threshold_for_dst_upgrade_using_dml 100 affected row threshold for DST upgrade using DML FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_all_sync_restrict_list   List of applications to ignore in all sync FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_cross_version_ddl 0 allow cross version DDL execution TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_cross_version_ddl 0 allow cross version DDL execution TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_cross_version_ddl 0 allow cross version DDL execution TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_fga_mixed_mode FALSE write FGA records to fga_log$ FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_imc_adaptive_grow TRUE if TRUE, allow imc to grow adaptively in broker's auto tuning. FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_allow_imc_adaptive_shrink TRUE if TRUE, allow imc to shrink adaptively in broker's auto tuning. FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_allow_modify_lockdown FALSE Allow restricted operations like set lockdown inside the PDB TRUE FALSE FALSE FALSE FALSE FALSE
_allow_same_cdb_refresh_switchover TRUE allow refresh switchover in one cdb TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_sysosenv_context FALSE Allow OS Environment Variable Application Context FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_traditional_audit_configuration FALSE allow traditional audit configuration TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_allow_unenc_ts_without_tde_master_key FALSE if TRUE, allow unencrypted tablespace creation
even when master key is not set,
 but encrypt_new_tablespace is set to always
if FALSE, throw 28361 error during tablespace creation 
if master key is not set and encrypt_new_tablespace is set to always
FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_allow_user$_col_update NONE List of user$ columns which are allowed to be updated FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_alter_table_modify_column_nop_flags 1 Alter table modify column NOP flags TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ansi_join_mv_rewrite_enabled TRUE enable/disable ansi join mv rewrite TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_aps_flush_enabled FALSE Enable/Disable APS Flushing functionality FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_aq_bufop_svc_create 1 create queue service for buffered operations FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_aq_deq_flowcontrol 0 Deq flow control TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_aq_scramble_deq 0 Scrambled Deq TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_aqsharded_cache_policy_lowmem 0 AQ: caching policy in low memory FALSE FALSE FALSE FALSE FALSE FALSE
_asm_asmb_exa_rcvto 30 Receive timeout for ASMB in exadata env in seconds TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_asm_bdbmr_max_ent_inprgrs 2000 Limit of BADFDA7A entries in progress of recovery TRUE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_checksum_migration_chunk_size 128 Number of asm metadata blocks for checksum migration in one batch TRUE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_disable_pstcard FALSE Disable pst cardinality layout checks FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_dynamic_timeout_interval 20 Dynamic timeout update intervals of 3 seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_enable_pstreloc_on_rm FALSE Enable pst layout relocation on rolling migration FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_identify_advisory_locks 2 enables ASM file identify advisory locks FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_quorum_hb FALSE Allow Quorum Disk Heartbeat TRUE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_read_cancel_dynamic_delta 20 Dynamic read timeout delta to multiply with median wait time FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_read_cancel_timeout_limit 15000 Timeout limit for dynamic read timeout update FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_read_cancel_timeout_min 5000 Minimum wait time for dynamic read timeout FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_reloc_restart_timeout 600 csecs before signaling ORA-15424 when waiting for orphans FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_write_cancel_dynamic_delta 30 Dynamic write timeout delta to multiply with median wait time FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_write_cancel_timeout_limit 90000 Timeout limit for dynamic write timeout update FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_asm_write_cancel_timeout_min 15000 Minimum wait time for dynamic write timeout FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_assert_invalidation 0 assert on invalidation of an object TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_audit_operator_access FALSE enable audit of Cloud Operator access TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_clustering FALSE enable auto clustering related processing TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_clustering_sqlset   SQL tuning set for auto clustering processing TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_db_lost_write_protect_fsfo_lag_limit_percent 67 FastStartFailoverLagLimit percent for auto lost write protection FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_auto_db_lost_write_protect_max_lag_secs 60 Max apply lag in seconds for auto lost write protection FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_auto_im_batch_size 10 Auto IM batch size TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_cache_join_opt FALSE Enable Autonomous Cached Join Optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_join_group FALSE Enable Autonomous Inmemory Join group TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_monitor_interval 1440 Auto IM Monitor Interval TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_optimized_arithmetic FALSE Enable Autonomous Inmemory Optimized Arithmetic TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_perf_threshold 10 Auto IM performance threshold TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_play_area 10 Auto IM play area TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_rac_enabled FALSE Enable Auto IM on RAC TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_im_task_mode 0 Enables Auto IM auto task to run in various modes TRUE FALSE FALSE FALSE FALSE FALSE
_auto_im_vector_gby_opt FALSE Enable Autonomous Vector Group By Optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_auto_manage_max_num_cells_offline 65535 Max. number of offline cells allowed TRUE IMMEDIATE FALSE TRUE FALSE FALSE
_auto_manage_remount_eligible_dg TRUE Periodically check for dismounte DGs, but they have in CRSthe attributes TARGET=ONLINE ENABLED=1 TRUE IMMEDIATE FALSE TRUE FALSE FALSE
_auto_temp_shrink_pdb_floor 0 auto temp tablespace shrink pdb floor FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_autocomp_move_max_mb 128 KDZADO UFC batch size TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_autoconf_mv_rewrite_metadata TRUE enable/disable mv metadata auto config logic TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_autoptn_config NONE DBMS_AUTO_PARTITION flags TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_autotbs_quota_override FALSE Override Auto TableSpace During Tablespace Quota DDLs TRUE FALSE FALSE FALSE FALSE FALSE
_awr_hub_autoimp_inline FALSE Enable/Disable AutoIMP in the same session handling requests FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_awr_hub_consumer_group ORA$AUTOTASK Setting of Hub Consumer Group FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_awr_hub_num_conc_imp 2 Setting for the number of concurrent IMP tasks at a Hub Server FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_awr_max_registrations 1024 maximum number of registered dbids in AWR FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_awr_sqltext_redaction FALSE Enable/Disable AWR SQL Text Redaction FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_awr_sqltext_redaction FALSE Enable/Disable AWR SQL Text Redaction FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_awr_sqltext_redaction FALSE Enable/Disable AWR SQL Text Redaction FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_awrextr_include_sqlmon FALSE Enable/disable including SQLMon data in AWR Extract TRUE FALSE FALSE FALSE FALSE FALSE
_backup_kgc_zstd_high_complevel 14 specifies compression (performance) level for ZSTD compression TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bct_auto_ctf_shrink FALSE allow change tracking file shrink on resize TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bct_dba_buffer_reap_threshold 2000 threshold for reaping changes per strand at a time TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bct_ext_alo_count 320 extent granule size to use during ctf resize TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bct_ext_min_count 320 min extents to allocate in change tracking file TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bct_wait_before_trace_dump 120 seconds after which BCT would dump traces for debugging TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bctab_max_system_chains 1024 blockchain table's maximum number of system chains FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_bctab_optimize_commit_performance FALSE optimize blockchain table commit performance TRUE FALSE FALSE FALSE FALSE FALSE
_bind_undotbs DISABLED Bind to undo tbs according to size TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_block_corruption_track_limit 1000 block corruption track limit TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_blockchain_immutable_table   blockchain/immutable table behavior FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_bloom_filter_multi_bit FALSE Multi-bit bloom filter TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bloom_pushing_folding_density 4 bloom filter pushing folding density lower bound pushing to sage TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_broker_imc_max_utilstep 95 max util percentage for imc by bg auto tuning. FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_cdb_view_serial_ok FALSE is serial OK for cross-container TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cell_iot_scan_enabled TRUE enable CELL processing of IOT FFS TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cell_trace_size 0 max trace size in bytes shipped back to server per filtering task TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cleanup_file_copy TRUE Enable file cleanup in Create PDB TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_client_ntfn_max_cleanup_interval 7200 max limit for cleanup interval FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_cloud_domain   internal domain name used for cloud deployments TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cloud_operator_user   list of Cloud Operator users FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_cloud_trace 0 send supported trace file types to the cloud TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cloud_trace_bucket_fill_percent 50 cloud trace bucket fill threshold TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cloud_trace_bucket_size 10485760 cloud trace bucket size TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cloud_trace_temp_table NONE cloud tracing temp table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_cloudops_common_users   List of common users to be treated as Cloud Ops FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_cloudops_sensitive_masking OFF Mask sensitive information in customer PDBs from Cloud Ops TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_con_number_reuse_threshold 2147483647 CON# begin reuse threshold FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_connection_broker_error_new_limit 100 connection broker error limit for new connections FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_containers_dop_use_remote FALSE should dop take into account PDBs open on a remote instance TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_controlfile_block_corruption_keep_records 4294967294 block corruption records to keep TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_controlfile_cache_bpb 4 Control file cache buffers per bucket FALSE FALSE FALSE FALSE FALSE FALSE
_controlfile_cache_bpp 32 Control file cache buckets per pool FALSE FALSE FALSE FALSE FALSE FALSE
_controlfile_cache_size 0 Size of control file cache in blocks FALSE FALSE FALSE FALSE FALSE FALSE
_controlfile_cache_timer 600 Control file cache buffers per bucket FALSE FALSE FALSE FALSE FALSE FALSE
_controlfile_enable_rdma_read TRUE enable controlfile rdma read FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_controlfile_validate_on_search FALSE Validate control file blocks on search FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_current_session_at_dbtimezone FALSE Set default session timezone to PDB timezone TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_current_time_at_dbtimezone FALSE use DB timezone when computing current time FALSE FALSE TRUE FALSE FALSE FALSE
_data_access_stats FALSE Track data access queries to collect stats TRUE FALSE FALSE FALSE FALSE FALSE
_data_guard_redo_statistics 31 Enable/Disable redo statistics FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_data_guard_val_redo 65537 Enable/Disable redo validation FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_datapump_net_transfer_size 0 data pump direct path network unload transfer size TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_db_active_prewarm_expiration 240 active prewarming file expiration interval FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_db_active_prewarm_interval 60 active prewarming interval FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_db_active_prewarm_spare1 0 active prewarming spare FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_db_active_prewarm_spare2 0 active prewarming spare 2 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_db_buffer_cache_percent 0 Buffer cache percent of sga FALSE FALSE FALSE FALSE FALSE FALSE
_db_lost_write_protect_timer_interval_secs 60 Lost write protection periodic tasks interval in seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_db_obj_cnt_for_file_ckpt 1000000 object count after that go for file checkpoint FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_db_obj_to_file_for_file_ckpt 10000 object to file ratio after that go for file checkpoint FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_db_open_links 0 Max allowed open dblinks for a pdb. FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_dblink_internal_gateway FALSE database link goes through Internal Gateway TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_dblink_multiple_address_transform FALSE Enable multiple address transformation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_dblink_rce_dns_proxy FALSE Enable RCE DNS Proxy for database link TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_dblink_topology TRUE Enable topology-driven database links FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_dbnest_pdb_network_ip   PDB network ip configuration FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_dbnest_pdb_network_ip   PDB network ip configuration FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_dbnest_pdb_network_ip   PDB network ip configuration FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_default_pdb_filecopy_dop 0 default pdb file copy degree of parallelism TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_del_qsvc_last_bufsub_drop FALSE delete queue service on last buffered subscriber drop FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_dgpdb_cf_retention 10080 number of minutes to keep the control file copy made during role change to primary FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_dgpdb_pcf_cf_apply_time 600 DGPDB pcf to cf mark apply time in seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_dgpdb_pcf_cf_sync_time 43200 DGPDB pcf to cf sync time in seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_diag_alert_log_enable_attention_prefix TRUE Enable/Disable attention prefix for alert log entries FALSE FALSE FALSE FALSE FALSE FALSE
_diag_dd_global_blockers_dump FALSE if TRUE enables Global blockers dump FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_diag_deadlock_detection_enabled TRUE Deadlock detection enabled in diag FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_diag_hang_analyze_elapsed_time_limit 1800 Diag Hang Analyze elapsed time limit in seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_disable_cross_shard_row_movement FALSE disable cross shard row movement TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_disable_flashback_data_archive FALSE disable pdb-level flashback archiving FALSE IMMEDIATE TRUE FALSE FALSE FALSE
_disable_flashback_data_archive FALSE disable pdb-level flashback archiving FALSE IMMEDIATE TRUE FALSE FALSE FALSE
_disable_flashback_data_archive FALSE disable pdb-level flashback archiving FALSE IMMEDIATE TRUE FALSE FALSE FALSE
_disable_hybrid_tg FALSE Disable Hybrid Transaction Guard TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_disable_mandatory_profile_for_import FALSE Disable Mandatory Profile check for IMPDP invocation inside a PDB FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_disable_mt_rfs FALSE disable MT RFS server FALSE IMMEDIATE FALSE FALSE FALSE FALSE
_disable_privilege_cache_in_auth_table FALSE disables caching privileges used in auth table FALSE FALSE TRUE FALSE FALSE FALSE
_disable_privilege_cache_in_auth_table FALSE disables caching privileges used in auth table FALSE FALSE TRUE FALSE FALSE FALSE
_disable_privilege_cache_in_auth_table FALSE disables caching privileges used in auth table FALSE FALSE TRUE FALSE FALSE FALSE
_disable_restricted_rac_rolling 0 Disable 2 Phase RAC Rolling Patch feature FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_disable_row_movement_auto_rollback FALSE disable row movement auto rollback TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_disable_sv_shared_mode FALSE Force exclusive instance lock acquire for ordered sequences TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_disallow_osu_edition_obj_in_pdb TRUE disallow oracle supplied edition objects in pdb TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_dixinv_flags 0 flags for invalidation of dependent objects during DROP INDEX TRUE FALSE TRUE FALSE FALSE FALSE
_duality_view_etag_required FALSE If true, etag will be required in input for updates TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_dump_diag_audrec_fail_tab FALSE Dump diagnostics on failure of audit record write to table FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_dump_scheduler_inmemory_trace_on_error TRUE autodump scheduler imt on error TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_dump_scheduler_inmemory_trace_on_timeout TRUE autodump scheduler imt on timeout TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_duplicate_database_key_to_omts TRUE if TRUE, duplicate DB key to OMTS if they do not have a key FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_eighteenth_spare_parameter   eighteenth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_eighth_spare_parameter   eighth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_eighty-first_spare_parameter NONE eighty-first spare parameter - string TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_eighty-fourth_spare_parameter NONE eighty-fourth spare parameter - string TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_eighty-second_spare_parameter NONE eighty-second spare parameter - string TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_asm_unified_auditing FALSE Enabling ALL auditing in ASM with Unified Auditing FALSE FALSE FALSE FALSE FALSE FALSE
_enable_auto_check_constraints_for_dst_upgrade TRUE enable/disable auto check constraints for DST upgrade FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_capture_select FALSE Parameter to enable capture of SELECT statements TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_concurrent_refresh TRUE enable/disable on-commit concurrent mv refresh TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_create_protected_profile FALSE Enable protected profile creation TRUE FALSE FALSE FALSE FALSE FALSE
_enable_json_uga_save_restore FALSE enable json uga save and restore during pdb switch TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_load_using_app_version TRUE Enables Oracle-supplied common object loading using app version TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_lock_down_on_mv_internal_ddls TRUE Enable Lock down on internal MV DDLs TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_meta_snap FALSE Is metadata snapshot allowed TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_noncdb_capture FALSE Parameter to enable capture in non-CDB FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_enable_ogg_online_ddl FALSE enable online ddl marker FALSE IMMEDIATE TRUE FALSE FALSE FALSE
_enable_pdc FALSE enable pmem direct commit FALSE FALSE FALSE FALSE FALSE FALSE
_enable_protected_audit_policy FALSE Allow Protected Unified Audit Policy Enforcement TRUE FALSE FALSE FALSE FALSE FALSE
_enable_session_heaps_in_mga TRUE Enable using MGA for session heaps FALSE FALSE FALSE FALSE FALSE FALSE
_enable_shared_multitarget_dblink 0 enable SHARED multitarget database links to shards FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_shared_multitarget_dblink 0 enable SHARED multitarget database links to shards FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_shared_multitarget_dblink 0 enable SHARED multitarget database links to shards FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_streams_pool_subpools FALSE enable streams pool multiple subpools FALSE FALSE FALSE FALSE FALSE FALSE
_enable_sysaux_metadata_clone FALSE enable sysaux metadata clone FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_enable_user_pdb_close_abort FALSE Enable user-initiated PDB close abort TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_enforce_lockdown_hardening FALSE Enforce hardening on lockdown related operations inside the PDB FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_enforce_set_container_hardening   Enforce hardening on SET CONTAINER inside the PDB FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_export_data_parquet_temp_dir DATA_PUMP_DIR Temporary directory used for intermediate files for export data TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_fifty-first_spare_pdb_parameter TRUE fifty-first spare pdb parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_fifty-second_spare_pdb_parameter TRUE fifty-second spare pdb parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_first_spare_parameter   first spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control_1   bug fix control overflow parameter-1 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control_2   bug fix control overflow parameter-2 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control_3   bug fix control overflow parameter-3 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control_4   bug fix control overflow parameter-4 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control_5   bug fix control overflow parameter-5 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_flashback_pdb_thread_filter_disable FALSE disable per PDB thread filter optimization FALSE FALSE FALSE FALSE FALSE FALSE
_force_backupset_zt_decryption FALSE Force ZT decryption for backupsets TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_force_create_cloud_credential FALSE Force create a scheduler credential as DBMS_CLOUD credential TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_force_level0_for_local_create_df FALSE Force level 0 backup for locally created datafile TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_forceopen_bind_undotbs FALSE Bind to any undo tbs during force open TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_fourteenth_spare_parameter   fourteenth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_fourth_spare_parameter   fourth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gc_fg_rollback TRUE if TRUE, fg does rollback instead of cr server FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gc_first_dirty_pi_merge_switch_current TRUE First dirty pi merge switch current FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gc_interrupt_wait_time 0 How long to wait for requests to complete after interrupt FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gc_timestamps 0 Add timestamps to cache fusion messages FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_change_cached_types TRUE allow automatic changes to cached resource types FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_ckptmon_stall_time 900 CKPT Monitor stall time (secs) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_ckptmon_trace_time 0 CKPT Monitor trace time (secs) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_enable_async_helpers TRUE if TRUE, GCR will spawn helper actions asynchronously FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_ges_res_cache_percent_threshold 40 percentage resource cache usage threshold FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_min_cache_reuse 50 minimum cache reuse rate threshold FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_min_free_swap_limit 10 limit for minimum free swap space before flagging an error FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_smf FALSE enable memory information sharing using node shared memory FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcs_kjbdump_threshold 60 threshold timeout to dont dump proc in kjbdmp in seconds TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gcs_max_antilocks_unmount_inst 10000 maximum number of anti-locks at unmount instance per LMS FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcs_res_freelists 8 number of gcs resource freelists per LMS FALSE FALSE FALSE FALSE FALSE FALSE
_ges_aggr_cache_clnup_intvl 25 aggressive cache clean-up interval (in secs) before FG steal FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ges_debug_acks FALSE Event to debug acks from bcast resource FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ges_max_avg_hash_chainlen 6 maximum average length of GES hash chains FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ges_max_hash_resizes 0 maximum number of GES hash expansions FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ges_num_aggr_cache_clnup 5 number of aggressive cache clean-up before FG steal FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gsm_local_users FALSE create GSM local users FALSE FALSE FALSE FALSE FALSE FALSE
_gwm_enable_ioft FALSE Allow instead of triggers in sharding TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_enable_ioft FALSE Allow instead of triggers in sharding TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_enable_ioft FALSE Allow instead of triggers in sharding TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_force_sync_duptab FALSE force synchronous on creating duplicated table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_force_sync_duptab FALSE force synchronous on creating duplicated table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_force_sync_duptab FALSE force synchronous on creating duplicated table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_max_start_catddlid 0 max ddl_id on catalog at startup. FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_max_start_catddlid 0 max ddl_id on catalog at startup. FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_max_start_catddlid 0 max ddl_id on catalog at startup. FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gwm_sr_ddlsync_enabled TRUE enable sr ddl synchronization in oracle sharding FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gwr_hb_loss 0 SNR heartbeat loss timeout, csecs FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gwr_hb_loss 0 SNR heartbeat loss timeout, csecs FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gwr_hb_loss 0 SNR heartbeat loss timeout, csecs FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gwr_lcr_cksum FALSE enable native sharding replication lcr checksum TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_gws_directory_sharding 0 directory-based sharding FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_hang_fast_track_critical_database_processes_enabled FALSE Hang Management fast-track critical database processes enabled FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hang_fast_track_progressing_sessions FALSE Hang Management fast-track progressing sessions enabled FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hang_int_spare1 0 Hang Management int 1 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hang_parsing_hangs_resolution_interval 0 Hang Manager parsing hangs resolution interval FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hang_prog_ft_critical_db_proc_verification_interval 900 Hang Manager progressing, fast-tracked critical db process verification interval FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hang_session_scan_update_hb_interval 6000 Hang Manager session scan update heartbeat interval FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hanganalyze_strip_offset TRUE if TRUE, strips offsets from short stack from HA wait chains FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hcs_disable_basetbl_transform FALSE disable base table transform TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_disable_dtmall_opt FALSE disable determine all optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_disable_mv_dense_join_opt FALSE disable move dense join optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_disable_mv_reparse_opt FALSE disable mv reparse optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_disable_remoteaggr_opt FALSE disable remote aggr optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_disable_xjoin_tgt_depths_opt FALSE disable xjoin target depths optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_enable_fusion_code FALSE enable avtune legacy code path for Fusion TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_enable_listagg_order FALSE enable listagg order TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_purge_dims_hiers FALSE purge dims and hiers on DDL operations TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_sim_no_chgtrck FALSE simulates missing change tracking table metadata TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_sim_no_cont_obj FALSE simulates missing container_obj# metadata TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_sim_no_dense FALSE simulates missing dense metadata TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hidden_parameter_check_control WARNING diagnostics control for privilege violation FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_honor_maxfsize_autoextend_on FALSE Honor maxsize of file when autoextend is on TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_host_internal_gateway   host name of Internal Gateway host TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_http_db_service FALSE Use HTTP DB Service FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hybrid_table_hidden_column FALSE enable hidden columns for hybrid table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_if_not_exists_enabled TRUE enable IF [NOT] EXISTS feature TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_im_graph_table off parameter to control in-memory execution of GRAPH_TABLE TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_im_graph_table_exec_control 0 in-memory GRAPH_TABLE execution parameters override TRUE FALSE TRUE FALSE FALSE FALSE
_im_graph_table_max_num_threads 0 number of threads for parallel GRAPH_TABLE in-memory execution TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_imado_disable_cdbaim FALSE Disable CDB AIM TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_imado_dml_const 100 AIM DML model overhead constant TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_imado_enable_imadv TRUE Enable IM Size Advisor View TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_imga_batch_size 1024 Number of elements per task when running graph algorithms TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_imga_disable FALSE Disable in-memory execution of graph algorithms FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_imgt_enabled FALSE If true, the In-Memory Graph Topology (IMGT) is enabled TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_imgt_suppress_gc FALSE If true, the IMGT GC is disabled TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_implicit_ssl_wallet TRUE Implicitly use SSL Wallet for UTL_HTTP request FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_index_coalesce_delete_block_only FALSE index coalesce mode to only delete empty leaf blocks TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_index_coalesce_max_redo_size_target 0 target for maximum redo generated by index coalesce TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_index_load_block_check FALSE Perform block checking during direct load of index blocks TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_index_mvi_oltp_advanced_high FALSE enable compression advanced high for multi-value indexes TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_index_pk_using_nonunique FALSE index primary key using non unique index TRUE FALSE FALSE FALSE FALSE FALSE
_index_relax_unique_const FALSE index relax unique index constraint TRUE FALSE FALSE FALSE FALSE FALSE
_inmemory_area_autotune TRUE if TRUE, allow imc to grow/shrink in broker's auto tuning. FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_inmemory_bf_disable_threshold 0 Threshold to disable IM bloom filter TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_bg_max_growstep 134217728 max grow step size for im grow in bg FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_inmemory_dbg_retry_ext FALSE Debug retry load inmemory extern table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_enable_bg_resize 0 IMA enable background resize operation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_enable_bg_step_grow 0 IMA enable background resize step grow TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_enable_shrink 1 IMA enable shrink support TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_enabled FALSE enable in-memory FALSE FALSE FALSE FALSE FALSE FALSE
_inmemory_fs_imco_timeout 120000 InMemory FastStart IMCO wait timeout in Gen-0 TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_fs_test_flags 0 InMemory FastStart testing flags TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_graph_pop_fg FALSE If true, all graph populations are performed in foreground TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_hybridexa_enable TRUE Inmemory Hybrid Exa Enabled TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_max_pga_usage_percent 50 Allowed PGA usage for IME creation as a percent of hard maximum FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_max_pga_usage_percol 20 Allowed PGA usage (in MB) for IME creation per column FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_metadata_pct 0 controls the pct of IM metadata space FALSE FALSE FALSE FALSE FALSE FALSE
_inmemory_optimized_date 0 Creates hidden virtual columns for accelerating date queries TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_populate_test_flags 0 In-memory populate test flags FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_private_journal_aonumbkts 16 Number of priv jrnl anchor object ht bkts FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_private_journal_dynamic TRUE If true, dynamic sizing will be enabled FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_private_journal_grplen 64 Number of blocks per PJ group FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_racgd_flags 0 Inmemory distributed GD flags TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_rw_pool 5 controls the use of the IM rw pool FALSE FALSE FALSE FALSE FALSE FALSE
_inmemory_shrink 0 In-memory shrink TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_shrink_cleanout_timeout 180 IMCO shrink cleanout timeout TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_shrink_control_flags 0 In-memory shrink control flags FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_shrink_gc_retries 3 In-memory shrink gc retries FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_shrink_test_flags 0 In-memory shrink test flags FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_inmemory_size_enable_shrink TRUE if TRUE, allow broker to shrink imc during auto tuning. FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_inmemory_succesive_bg_rsz_interval 24000 broker inmemory resize success intervals . FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_inmemory_xt_virtual_columns DISABLE Controls which user-defined VCs in external tables are stored in-memory FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_iot_overflow_tblspace_user_default FALSE creates IOT overflow segment in user's default tablespace TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ipacl_feature_control_flags 1 0x01 - enable ACL feature FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_j0_deq_maxwait_time 0 max wait for dequeues scheduled via scheduler jobs FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_job_notification_handler_owners   List of schemas allowed to own job notification handler FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_json_qryovergen_rewrite TRUE enable/disable JSON query over generation function rewrite TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kcc_aging_cool_count 1 Touch count set when buffer cooled FALSE FALSE FALSE FALSE FALSE FALSE
_kcc_aging_freeze_cr FALSE Make buffers always be too cold to keep in cache FALSE FALSE FALSE FALSE FALSE FALSE
_kcc_aging_hot_criteria 2 Touch count which sends a buffer to head of replacement list FALSE FALSE FALSE FALSE FALSE FALSE
_kcc_aging_stay_count 0 Touch count set when buffer moved to head of replacement list FALSE FALSE FALSE FALSE FALSE FALSE
_kcc_aging_touch_time 3 Touch count which sends a buffer to head of replacement list FALSE FALSE FALSE FALSE FALSE FALSE
_kcc_percent_hot_default 50 Percent of default buffer pool considered hot FALSE FALSE FALSE FALSE FALSE FALSE
_kcfis_largemd_bfquota_kb 16384 Smart IO operation bloom filter metadata size in KBs TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kcfis_largemd_compressed_kb 20480 Smart IO operation maximum compressed metadata size in KBs TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kcfis_largemd_enabled TRUE Smart IO operation large metadata supported enabled TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kcfis_max_ioctl_buffers 100 Sets the maximum number of IOCTL buffers in kcfis TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kcmi_debug 0 Use alert log instead of debug.log FALSE FALSE FALSE FALSE FALSE FALSE
_kdfip_iga_adpt_amm_intr 30 memopt w bg task timing FALSE FALSE FALSE FALSE FALSE FALSE
_kdfip_iga_adpt_dec_ldpr 50 memopt w adaptive decrement load percent FALSE FALSE FALSE FALSE FALSE FALSE
_kdfip_iga_adpt_dec_pr 5 memopt w adaptive decrement percent FALSE FALSE FALSE FALSE FALSE FALSE
_kdfip_iga_adpt_inc_ldpr 75 memopt w adaptive increment load percent FALSE FALSE FALSE FALSE FALSE FALSE
_kdfip_iga_adpt_inc_pr 25 memopt w adaptive increment percent FALSE FALSE FALSE FALSE FALSE FALSE
_kdfip_iga_adpt_maxsz 0 memopt w max adaptive global area size FALSE FALSE FALSE FALSE FALSE FALSE
_kdlf_direct_inode_path TRUE enable kdlf direct inode path for vanilla lobs TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kdlf_track_itrcnt 200 Change the no of iterations to track TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kdli_adpt_sio_mem TRUE adaptive sio memory buffer TRUE FALSE TRUE FALSE FALSE FALSE
_kdli_cache_hless_limit 4 #of extents to cache headless inode TRUE FALSE TRUE FALSE FALSE FALSE
_kdlu_timer_dmp FALSE dump inode timers on session termination TRUE FALSE TRUE FALSE FALSE FALSE
_kdlwp_multi_wgc TRUE enable multiple wgc TRUE FALSE TRUE FALSE FALSE FALSE
_kdlxp_cmpappopt TRUE New securefile compression algorithms TRUE FALSE TRUE FALSE FALSE FALSE
_kdlxp_newcmpalgos FALSE New securefile compression algorithms TRUE FALSE TRUE FALSE FALSE FALSE
_kdmado_st_txn_test 0 AIM HT ST_TXN parameter for testing TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kdmado_wt_txn_test 0 AIM HT WT_TXN parameter for testing TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kdmimadv_constant_speed FALSE Allow AIM algorithm TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kdzado_postdm_on FALSE Enable kdzado post dm actions TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kdzf_columnar_cache default Enable Columnar Flash Cache String Mode TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kerberos_debug 0 Enable debug trace for Kerberos FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_kerberos_per_pdb TRUE Enable per-PDB Kerberos FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_kerberos_service_host   service host for Kerberos TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_keusp_max_num_alloc_buf DEFAULT Maximum number of KEUSP buffers in shared memory FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_keusp_stream_batch_size DEFAULT Number of KEUSP buffers to flush in a stream batch FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_kgl_4021_assert_on_oso FALSE Raise soft assert on hitting ORA-4021 for Oracle supplied object TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kgl_assert_x_pin FALSE assert if KGL takes an X-pin on PL/SQL FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_kgl_final_blocker_kill_begin_time 2 time to wait in minutes before start killing blockers TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kgl_kill_final_blocker FALSE controls feature to kill KGL X lock/pin blockers TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kgl_max_hot_cursors_factor 25 Factor to compute max num of cursors that can be marked hot FALSE FALSE TRUE FALSE FALSE FALSE
_kgl_max_wait_time_during_kill 15 max time to wait to get unblocked while killing blockers TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kgrk_configs NONE kgrk additional configurations FALSE FALSE TRUE FALSE FALSE FALSE
_kill_session_alert 5 Kill session to alert log FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kill_session_force FALSE override session kill default to force TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kjac_purge_limit 50000 Max number of LTXID_TRANS rows to delete in one purge cycle FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kjac_purge_timeout 3600 LTXID_TRANS purge scheduler timeout FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kkporesetdn_multiplier 2 multiplier used when partitions are renumbered TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kkporesetdn_threshold 2100000 threshold for partition renumbering as part of online PMOs TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kks_max_open_cursors_dup_limit 5 number of duplicate cursors in open cursors that are acceptable TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kks_open_cursors_dump_summary_threshold 100 size to dump open cursors summary on max open cursors exceeded error TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kks_reuse_ful_child_cursor 3 allow reuse of child cursor marked with FUL flag FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_kksfra_cap_stacks FALSE capture stacks for setting kksfra TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kpdb_log_errors 0 log user errors in v$client_errors TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kpdb_perf_diag_subop_list 0 List of KPDB sub-ops to diagnose TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kpdb_perf_diag_subop_max_exec_time 30 Max allowed time (in sec) for KPDB sub-op to complete TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kql_disable_auto_commit FALSE Disable DDL auto commit in the session TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kql_verify_dependency_timestamps 0 verify dependency timestamps TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kqr_trace_options 0 kqr Trace Options (Default is all enabled) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kra_obsolete_rule TRUE disable or enable obsolete rule FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksi_disable_sopt TRUE if TRUE (default), disable s-optimization for specific row caches FALSE FALSE FALSE FALSE FALSE FALSE
_ksim_group_ops_req_async_procsz 10 ksim group async req batch processing size TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ksim_group_ops_req_async_procsz_dyn_adjustment TRUE ksim group async req processing sz dynamic adjustment TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ksim_group_ops_req_opmode async ksim group join/leave op mode TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ksipc_ipclw_wait_diag_ms 0 Configure IPCLW WAIT DIAG TIME (in MS) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksipc_spare_param2   ksipc spare param 2 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksnmon_max_flow 65535 KSNMON max number of flows monitored FALSE FALSE FALSE FALSE FALSE FALSE
_ksnmon_min_stats_interval_ms 5000 KSNMON min stats report interval in ms FALSE FALSE FALSE FALSE FALSE FALSE
_ksnmon_service_enable_bitmask 2147483647 KSNMON service enable (a bit per service) FALSE FALSE FALSE FALSE FALSE FALSE
_ksrk_dedicated_io_threads_pct 50 percentage of total io threads dedicated for PDBs FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksrk_max_io_threads_pct 40 percentage of total "processes" the PubSub sub system can use as its io threads FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksrk_pdbmax_io_thread_pct 100 Maximum number of IO threads a PDB can use FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_ksrk_pga_limit_pct 40 percentage of total PGA that can be used by the bridge FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksrk_pga_reclaim_pct 50 PGA usage threshold at which bridge starts reclaiming free extents from ksrk subheaps FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksrk_sga_limit_pct 10 percentage of total SGA that can be used by KSRK FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kstrc_archiver disk://localhost KSTRC Backend archiver FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kstrc_bucket_max_size 2097152 Configure the max size of the trace bucket for each KSTRC Operation FALSE FALSE FALSE FALSE FALSE FALSE
_kstrc_max_operations 1024 Configure total max number of KSTRC operations available/in use FALSE FALSE FALSE FALSE FALSE FALSE
_kstrc_service_mask 1 KSTRC Service Mask FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_child_service_override FALSE KSWS child service override FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_clb_storm_count 15 KSWS CLB Goodness Changes Counter to trigger posting FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_clb_storm_interval 500 KSWS CLB posting Interval to Listener FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_coloc_control 1 KSWS Colocation control parameter FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_perf_control 29 KSWS Performance control parameter FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_perf_tracing 0 KSWS Performance Diagnostics and Monitoring FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_smart 29 KSWS Smart Feature Control FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksws_smart_frequency 900 KSWS Smart Publishing Frequency in deci seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksxp_allow_ksxr_rolling_migration TRUE Allow KSXR operations during rolling migration FALSE FALSE FALSE FALSE FALSE FALSE
_ksz_fake_mga_check_range 10 ksz fake mga status check random range FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ksz_fake_mga_mode FALSE enable ksz fake MGA mode FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kts_dbg 0 KTS Generic Debug TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ktsls_autoshrink_seg_idle_seconds 86400 automatic securefile shrink segment idle seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ktsls_autoshrink_seg_pen_seconds 86400 automatic securefile shrink segment penalty seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ktsls_autoshrink_trickle_mb 128 automatic securefile shrink trickle mb FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_ktst_dbg 0 Kernel Transaction Temporary Sort management Debug TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_kttets_ignore_free_space FALSE Should x$kttets ignore storage free space for max FALSE FALSE FALSE FALSE FALSE FALSE
_kxs_library_cache_stats TRUE Library cache statistics for shared cursors FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_ldr_pga_proc_lim 0 pga proc limit, beyond which new partition loads are delayed TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_leader_pdb FALSE enable leader PDB functionality FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_leader_pdb_guid   GUID of Leader PDB FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_lgwr_delay_slave_write FALSE Enable LGnn write delay for testing FALSE FALSE FALSE FALSE FALSE FALSE
_lgwr_delay_write_csec 300 If LGWR write delays are enabled, delay each write by this amount FALSE FALSE FALSE FALSE FALSE FALSE
_lgwr_delay_write_interval 10 If LGWR write delays are enabled, delay every Nth write FALSE FALSE FALSE FALSE FALSE FALSE
_link_to_leader_pdb   database link to Leader PDB FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_lm_async_pdb_open 0 if TRUE enables asynchronous pdb open in DLM FALSE FALSE FALSE FALSE FALSE FALSE
_lm_comm_monitor_pending_sends 0 Pending sends monitoring FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_comm_receive_buffer_multiple 2 Additional receive buffer multiple FALSE FALSE FALSE FALSE FALSE FALSE
_lm_comm_send_proxy_bufr_return_mode 1 Send proxy buffer return mode FALSE FALSE FALSE FALSE FALSE FALSE
_lm_comm_send_proxy_send_comp_wait 100 Send proxy wait on send completion FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_comm_send_proxy_send_wait 50 Send proxy wait per sends FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_drm_pdb_on TRUE only pdb members participate in DRM FALSE FALSE FALSE FALSE FALSE FALSE
_lm_drm_test_duration_limit 5 set drm test duration limit (secs time/object size) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_hist_bucket_trigger 500 LM trigger to produce trace bucket dump in ms FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_hist_dump_trigger 100 LM trigger to produce diagnostic in ms FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_hist_opcode_trigger 0 LM opcode to produce trace bucket dump FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_hvenqid4_opt 1 pass setmaster in id4 of HV enqueue name FALSE FALSE FALSE FALSE FALSE FALSE
_lm_killproc_timeout 120 lazy domain killproc timeout in seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_kjbdomlzdomscn_interval 1 kjbdomlzdomscn() interval time in seconds FALSE FALSE FALSE FALSE FALSE FALSE
_lm_mwin_req_queue_max_size 4000 maximum size of multiwindow request queue FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_nodrm_service_pct 95 minimum nonsingleton service access percentage to disable drm FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp11 0 rac parameter dp11 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp12 0 rac parameter dp12 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp13 0 rac parameter dp13 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp14 0 rac parameter dp14 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp15 0 rac parameter dp15 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp16 0 rac parameter dp16 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp17 0 rac parameter dp17 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp18 0 rac parameter dp18 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp19 0 rac parameter dp19 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp20 0 rac parameter dp20 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp21 0 rac parameter dp21 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp22 0 rac parameter dp22 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp23 0 rac parameter dp23 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp24 0 rac parameter dp24 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp25 0 rac parameter dp25 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp26 0 rac parameter dp26 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp27 0 rac parameter dp27 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp28 0 rac parameter dp28 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp29 0 rac parameter dp29 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_rac_spare_dp30 0 rac parameter dp30 FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_req_max_life 36000 maximum life time of request in seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_share_opt_async_open_pdb TRUE if TRUE enables s-opt with async open pdb FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lm_sq_batch_waittick_worker 30 GES send queue batching waittime for worker in tick FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lmhb_min_pct_hbcnt 0 minimum heartbeat ticks to not be flagged as hung (percent) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lmhb_select_final_blkr FALSE selects ultimate non-fatal blocker in hang chain (if present) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lob_session_parameters PGA_SMART_LOBS_LIMIT:75 Controls LOBs behavior TRUE FALSE FALSE FALSE FALSE FALSE
_lockdown_execution_check FALSE Check if lockdown execution check feature is enabled in PDB TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_log_archive_dest_force_async FALSE force async on service destinations FALSE IMMEDIATE FALSE FALSE FALSE FALSE
_log_client_ip_address_to_alert FALSE Log Client IP Address to alert file for each login FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_lreg_max_update_history 3600 lreg max update history FALSE FALSE FALSE FALSE FALSE FALSE
_lreg_significant_change 3 lreg significant change FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lreg_update_lag_mins 10 lreg update lag (in minutes) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_map_service_name FALSE Map service names between Proxy PDB and Referenced PDB TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_max_def_granule_size 67108864 maximum default SGA granule size FALSE FALSE FALSE FALSE FALSE FALSE
_max_dist_bt_chains 8 maximum number of chains for distributed transaction FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_max_physmem_perc_um 90 maximum percentage of physical memory for Unified Memory FALSE FALSE FALSE FALSE FALSE FALSE
_max_small_page_sga_size 0 Maximum SGA size with small pages FALSE FALSE FALSE FALSE FALSE FALSE
_maxval_job_queue_processes   Maximum value of job queue slave processes parameter for the PDB FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_memoptimize_writes_no_wait FALSE enable no wait conventional insert path for memoptimize write TRUE FALSE FALSE FALSE FALSE FALSE
_memory_broker_marginal_utility_imc 6 Marginal Utility threshold pct for imc FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_memory_broker_shrink_imc 15 memory broker allow policy to shrink imc pool FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_memory_per_cpu_count 0 memory per cpu count FALSE FALSE FALSE FALSE FALSE FALSE
_mga_pid_root_head_count 16 mga pid root head count FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_mle_compilation_dump_graph_on_crash FALSE dump compilation graphs to the trace file when compilation crashes in MLE TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_mle_compilation_sync FALSE force compilation to be synchronous for MLE TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_mle_enable_recursion TRUE enable recursive/reentrant MLE TRUE FALSE FALSE FALSE FALSE FALSE
_modify_protected_profile_parameters   List of password parameters allowed to be modified for protected profile FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_mt_redo_log_record_wakeup_interval 1440 Wake up time in minutes to purge redo log table records FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_mt_rfs_flush_header_interval 60 MT flush header interval FALSE IMMEDIATE FALSE FALSE FALSE FALSE
_mt_rfs_gap_interval 720 MT Gap limit FALSE IMMEDIATE FALSE FALSE FALSE FALSE
_mt_rfs_register_lag_seq 24 MT Register Lag Sequence FALSE IMMEDIATE FALSE FALSE FALSE FALSE
_multi-statement_pdml_support PDML is multi-statement PDML allowed (remove touch-once restriction) FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_mutex_skip_spin_waiter_count 20 Active waiter count to skip mutex spin FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_nanovos_library   Nanovos instance object path FALSE FALSE FALSE FALSE FALSE FALSE
_nanovos_name   Nanovos instance name FALSE FALSE FALSE FALSE FALSE FALSE
_nanovos_type   Nanovos instance type FALSE FALSE FALSE FALSE FALSE FALSE
_need_administer_fine_grained_audit_policy_for_fga TRUE Check ADMINISTER FINE GRAINED AUDIT POLICY privilege for administering FGA policy FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_need_administer_redaction_policy_for_redact TRUE Check ADMINISTER REDACTION POLICY privilege for administering REDACT policy FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_need_administer_row_level_security_policy_for_rls TRUE Check ADMINISTER ROW LEVEL SECURITY POLICY privilege for administering VPD policy FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_need_create_table_privilege_for_redact FALSE Check CREATE TABLE privilege for administering REDACT policy FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_netldp_common_users_as_local   List of common users to be treated as local for network lockdown FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_next_constraint_cache_size 5 size of _NEXT_CONSTRAINT cache FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_ninth_spare_parameter   ninth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_non_app_cross_con_collection FALSE enable cross container collection for non-application objects TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_not_waiting_significant_CPU 10 percent of CPU time when not in a wait which is significant FALSE FALSE FALSE FALSE FALSE FALSE
_num_undostat_intervals 576 number of intervals for undo statistics in SGA FALSE FALSE FALSE FALSE FALSE FALSE
_nusa_remote_data_containers   disk groups with remote access for NUSA FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_nvm_asm_dispatchers 1 number of NVM Dispatcher Slaves for ASM FALSE FALSE FALSE FALSE FALSE FALSE
_nvm_dbw_dispatchers 1 number of NVM Dispatcher Slaves for DBWRs FALSE FALSE FALSE FALSE FALSE FALSE
_objectstore_odm_segment_size 0 Internal variable Swift DLO segment size for ODM object store lib TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-fiftieth_spare_parameter FALSE one-hundred-and-fiftieth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-fifty-fifth_spare_parameter FALSE one-hundred-and-fifty-fifth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-fifty-first_spare_parameter FALSE one-hundred-and-fifty-first spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-fifty-second_spare_parameter FALSE one-hundred-and-fifty-second spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-fifty-seventh_spare_parameter FALSE one-hundred-and-fifty-seventh spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-fifty-sixth_spare_parameter FALSE one-hundred-and-fifty-sixth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-fifty-third_spare_parameter FALSE one-hundred-and-fifty-third spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-eighth_spare_parameter FALSE one-hundred-and-forty-eighth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-fifth_spare_parameter FALSE one-hundred-and-forty-fifth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-first_spare_parameter FALSE one-hundred-and-forty-first spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-fourth_spare_parameter FALSE one-hundred-and-forty-fourth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-ninth_spare_parameter FALSE one-hundred-and-forty-ninth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-second_spare_parameter FALSE one-hundred-and-forty-second spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-sixth_spare_parameter FALSE one-hundred-and-forty-sixth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-forty-third_spare_parameter FALSE one-hundred-and-forty-third spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-thirty-fifth_spare_parameter NONE one-hundred-and-thirty-fifth spare parameter - string list TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-thirty-first_spare_parameter NONE one-hundred-and-thirty-first spare parameter - string list TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-thirty-fourth_spare_parameter NONE one-hundred-and-thirty-fourth spare parameter - string list TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-thirty-second_spare_parameter NONE one-hundred-and-thirty-second spare parameter - string list TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_one-hundred-and-thirty-third_spare_parameter NONE one-hundred-and-thirty-third spare parameter - string list TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_online_ddl_delay 200 centisecond delay for online DDL to allow cursor recompliation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_online_ddl_domain_index_flags 1 flags for domain indexes during online DDLs TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_online_direct_load 1 Online Direct Load TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_online_pmo_global_index_flags 0 flags for global indexes during partition maintenance DDLs TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_optimize_tbsquota_ddl TRUE Optimize tablespace quota for user DDL FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_optimizefsio   Test env file i/o setting TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_optimizer_diag_stats TRUE enable/disable populating stats diagnosis tables FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_optimizer_force_error_CBQT   force assert within a CBQT transformation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_optimizer_force_error_hash   force assert if hash of the error message equal to the parameter TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_optimizer_force_error_state   force assert in init phase, final phase or a candidate state TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_optimizer_push_gby_into_union_all TRUE consider pushing down group-by into union-all branches TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_optimizer_subsume_vw_sq on consider subsumption of views or subqueries TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_os_nice_high 10 OS high nice level FALSE FALSE FALSE FALSE FALSE FALSE
_os_nice_highest 0 OS highest nice level FALSE FALSE FALSE FALSE FALSE FALSE
_os_nice_low 30 OS low nice level FALSE FALSE FALSE FALSE FALSE FALSE
_os_nice_lowest 39 OS lowest nice level FALSE FALSE FALSE FALSE FALSE FALSE
_os_nice_normal 20 OS normal nice level FALSE FALSE FALSE FALSE FALSE FALSE
_os_sched_low_priority 1 OS low priority level FALSE FALSE FALSE FALSE FALSE FALSE
_os_sched_lowest_priority 1 OS lowest priority level FALSE FALSE FALSE FALSE FALSE FALSE
_os_sched_normal_priority 1 OS normal priority level FALSE FALSE FALSE FALSE FALSE FALSE
_os_sched_use_nice TRUE With this set to TRUE, the scheduling policy will be SCHED_OTHER as a default,
and nice value alone will be modified to change process priority
FALSE FALSE FALSE FALSE FALSE FALSE
_parallel_frz_step_reconfig 0 parallel rs work for freeze step for instance reconfig. FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_parallel_server_memory_threshold 0 max memory threshold for idle PX server to exit FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_parallel_server_resiliency 1 enable resilient execution of parallel query TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_part_layer_performance_trace 0 diagnostic improvements for performence issues TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_partition_by_expression FALSE allow partition by expression TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_partition_key_errmsg_limit 128 limit on the partition key string included in error messages TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_partition_key_errtrc_limit 16384 limit on the partition key string written to trace file TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_path_prefix_override_dir NONE Override directory for PATH_PREFIX in PDB TRUE FALSE FALSE FALSE FALSE FALSE
_pdb_close_immediate_kill_batchsize 1000 batch size for killing sessions inside the PDB TRUE FALSE FALSE FALSE FALSE FALSE
_pdb_component_violation_restricted   Components allowed to have mismatch between CDB$Root and PDB FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdb_lifespan_callout NONE PL SQL Procedure to import lifespan TRUE IMMEDIATE TRUE FALSE FALSE FALSE
_pdb_local_undo_tablespace_init_size 100000000 Initial size for undo tablespace TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_lockdown_error_message FALSE Enable pdb lockdown specific error message TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_media_rcv_parallelism 0 PDB media recovery parallelism TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_refresh_remote_logs_path   Location of archive logs to use for pdb refresh TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_refresh_scn_to_seq_exttbl NONE external table name to use convert scn to thread#,seq# TRUE IMMEDIATE TRUE FALSE FALSE FALSE
_pdb_replay_param_blocklist NONE pdb replay parameter block list FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdb_replay_param_mode DISABLED pdb replay parameter mode FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdb_service_name_convert   service name convert patterns and strings for per PDB clone FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_service_name_convert   service name convert patterns and strings for per PDB clone FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_service_name_convert   service name convert patterns and strings for per PDB clone FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_skiplist_apply_callout NONE PL SQL Procedure name to import skiplist TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_skiplist_redogen_callout NONE PL SQL Procedure name to export skiplist TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_pdb_trigger_user   user to execute pdb trigger TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_pdbopen_fixedtablestats FALSE gather fixed table stats at PDB open FALSE FALSE TRUE FALSE FALSE FALSE
_pdc_adaptive FALSE pmem direct commit adaptively determine percent of ORL-only txns FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_adaptive_evaluation_delta 10 pmem direct commit adaptive txn eval. delta FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdc_adaptive_evaluation_duration 10 pmem direct commit adaptive adaptive eval. duration (percent) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdc_adaptive_evaluation_interval 60 pmem direct commit adaptive adaptive eval. interval (in seconds) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdc_adaptive_evaluation_margin 5 pmem direct commit adaptive txn evaluation margin FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdc_adaptive_evaluation_successes 2 pmem direct commit adaptive txn eval. successes FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdc_concurrency 4 pmem direct commit concurrency FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_file_clear FALSE clear pmem direct commit file when redo thread is opened FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_imu_pct 0 percentage of IMU ORL-only transactions FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_imud_flush TRUE flush an imu txn's downgrade redo immediately FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_inst_bocs 1 number of per-instance persistent memory log buffer bocs FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_max_mirrors 2 max number of pmem direct commit mirrors FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_min_mirrors 2 min number of pmem direct commit file mirrors FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_msrdma TRUE enable pmem direct commit msrdma FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_non_imu_pct 0 percentage of non-IMU ORL-only transactions FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_plb_stealing TRUE enable pmem direct commit plb stealing FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_ptn_unit_size 65536 pmem direct commit file ptn unit size FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_read_full_ptn FALSE read entire pmem direct commit file ptn when resilvering FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_reconfig_interval 30 How long RECO waits before strand file mirror reconfig check (min) FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pdc_remove_all_files 0 remove PMEM strand files during mount FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_resilver TRUE enable resilvering of online log from pmem direct commit file FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_resilver_single FALSE create a single strand lwn during resilvering from pmem FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_simulation FALSE allow a simulated pmem direct commit file FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_test_hook 0 pmem direct commit testing hook FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_txn_time 5 max time in seconds before a txn logs redo only to the online log FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_units_per_ptn 4 pmem direct commit file units per ptn FALSE FALSE FALSE FALSE FALSE FALSE
_pdc_use_partnership_map TRUE enable partnership map for mirror placement FALSE FALSE FALSE FALSE FALSE FALSE
_plan_verify_absolute_margin 100000 Absolute performance criterion for evolving plan baselines TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_plsql_bypass_strict_semantics FALSE Bypass PL/SQL semantics to resolve 2-part name as schema.type after package.type fails. TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_plsql_max_frame_count 0 PL/SQL maximum call nesting depth FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_pmon_mutex_cleanup 1 PMON cleanup: mutex option FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_port_internal_gateway 0 port number of Net Listener on Internal Gateway host TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_post_multiple_shared_waiters TRUE Post multiple shared waiters of a latch FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_preformat_tempfile_bmbs TRUE Enable preformatting enough bmbs for tempfile TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_primary_guard_wait_timeout 120 Number of secords for guard wait timeout on primary FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_protect_pga_extents FALSE protection for pga extents FALSE FALSE FALSE FALSE FALSE FALSE
_pseudo_redo_dump FALSE Convert all internal redo dump to pseudo redo dump FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_px_partition_load_skew_handling on enable partition load skew handling TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_px_partition_load_skew_threshold 3 partition loads bigger than threshold times average are skewed TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_px_proactive_slave_release 1 early release of producer slaves of final DFO TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_px_window_skew_handling TRUE enable window function skew handling TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_px_window_skew_sample_size 1000 window function skew sample size TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_qesma_access_count 1 controls scan count collection for X$QESMA_ACCESS_COUNT table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_qesma_mvob_pin_lru_sz 5 size of MVOB pin LRU list for QESMA session cache TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_qesma_rt_parallel_check 1 verify qesma metadata at runtime for parallel execution TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_qkgl_crit_pct_threshold 80 Queue KGL critical percentage allocation threshold FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_qkslvc_diag_flags 0 diagnostic flags for qkslvc TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_quantified_path_pattern_maximum_upper_bound 10 maximum upper bound allowed for SQL PGQ quantified path pattern TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_rce_dblink_hostname_transform FALSE Transform RCE database link to add hostname TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_rce_dns_suffix   suffix for RCE DNS Proxy based DNS resolution TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_rdbms_min_compatibility 11.2.0.2 default mininum RDBMS compatibility level TRUE IMMEDIATE FALSE TRUE FALSE FALSE
_rds_congestion_timeout 0 Configure RDS Congestion timer (us) FALSE FALSE FALSE FALSE FALSE FALSE
_rds_congestion_type   Configure RDS Congestion type FALSE FALSE FALSE FALSE FALSE FALSE
_reco_populate_mode 1 Mode of RECO protocol execution FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_recycle_con_cache_size 5 Recycle con# cache size FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_redo_generation_max_kbytes_sec 0 redo generation maximum KB/s FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_redo_indexes_apply DISABLE utilize redo range indexes in recovery TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_refclone_redirect FALSE statement redirection in Refreshable Clone FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_refclone_source_connect_string   connect string for redirection in refreshable clone FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_remote_sv_sequence 1 enable smart sv work on remote instances. FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_request_deferral_enabled FALSE enable request deferral FALSE FALSE FALSE FALSE FALSE FALSE
_resource_exhaustion_warning_thresholds 655361281 thresholds and frequency of actions related to resource exhaustion TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_resource_exhaustion_warnings 0 enable warnings/crash when certain finite resources are used up TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_restore_delayed_write FALSE restore datafiles with delayed write option TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_result_cache_auto_blocklist_epsilon 10000 How much better blocklisted objects must be to be unblocklisted FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_result_cache_auto_blocklist_frequency 40000 Frequency of autoblocklist checks in units of RC invalidations FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_result_cache_auto_blocklist_threshold 1000 Threshold of ratio of ROs created to used before blocklisting FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_result_cache_auto_broadcast_threshold 10000 Threshold of RAC round trip times before blocklisting FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_result_cache_auto_ignore_list 0 object numbers that will never be auto blocklisted FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_retry_file_copy TRUE Enable retry for file copy in Create PDB TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_reuse_object_number_delay 0 delay in days before reusing object numbers FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_reuse_object_numbers 5 reuse object numbers FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_reuse_object_numbers_qa 0 reuse object numbers testing FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_rm_cell_cpu_scale 0 Scaling factor for storage cell cpu usage FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_rm_exadata_disable_dbcpurm FALSE Disable the Exadata DB cpu resource manager feature FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_rm_exadata_fcsize_unit 0 PDB usage size unit for flash cache for Exadata FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_rm_sgllim 0 Single CPU limit control FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_rm_tolerance_lwt 5 RM tolerance for LWT to report consumed cpu FALSE FALSE FALSE FALSE FALSE FALSE
_rolling_vsnnum   Mimic given vsnnum during test FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_router_pdb FALSE enable router PDB functionality FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_rowsets_use_work_heap_buffer TRUE allow/disallow use of work heap buffer for values for rowsets TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_saga_clear_interval 86400 qmon periodic interval for processing saga clearing job FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_saga_timeout_interval 3600 qmon periodic interval for processing saga timeout FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_scheduler_cjq0_buffer_size 1024 buffer size (in KB) for scheduler IMT for CJQ process FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_scheduler_inmemory_trace_timeout 600 Timeout for scheduler internal operations TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_scheduler_jnnn_buffer_size 32 buffer size (in KB) for scheduler IMT for JNNN processes FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_scheduler_ora_buffer_size 32 buffer size (in KB) for scheduler IMT for ORA processes TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_search_space_from_beginning 2147483647 search free space from the beginning of a tablespace FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_second_spare_parameter   second spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_service_internal_gateway   service name registered with Net Listener on Internal Gateway TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_session_preserve_logon_container FALSE preserve the logon container id in the session TRUE FALSE FALSE FALSE FALSE FALSE
_seventeenth_spare_parameter   seventeenth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_seventh_spare_parameter   seventh spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_shard_cached_sessions 0 session cache size for cross shard SQLs FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_shard_repl_bytes_per_block 8192 block size of snr logs in bytes FALSE FALSE TRUE FALSE FALSE FALSE
_shard_repl_max_iobuf 256 max number of snr io buffers FALSE FALSE TRUE FALSE FALSE FALSE
_shard_repl_total_mb_per_ru 3072 total size of snr logs per ru in mb FALSE FALSE TRUE FALSE FALSE FALSE
_sharding_lockdown FALSE Oracle internal parameter FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_shared_pool_lru_bufs 200 shared pool lru effort buffer size FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_shutdown_abort_timeout_mins 0 minutes for shutdown operation to wait for completion before initiating shutdown abort TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sixteenth_spare_parameter   sixteenth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sixth_spare_parameter   sixth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_skip_cursor_syspriv_rechecks FALSE skip re-authorization of session cached cursors FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_skip_fixed_dependency_load_during_drop FALSE skip load of fixed object dependency during drop TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_skip_multiple_svc_netname_convert_patterns FALSE skip apply multiple patterns on a network name during service_name_convert in PDB TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_skip_pdbid   PDBIDs to be skipped during init of kpdblist from control file TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_skippriv_emailserver_credential FALSE Skip execute privilege check on scheduler email server credential FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_slave_mapping_skew_handling TRUE enables skew handling for slave mapping plans TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_slow_kill_rate_on_pdb_close_immediate 5 Rate of killing sessions gradually on pdb close immediate TRUE FALSE FALSE FALSE FALSE FALSE
_smm_low_mem_bound_diag_threshold 0 low memory bound threshold to trigger diagnostic dump FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_smon_sort_management 0 Control SMON or SMCO process sort segment management message FALSE FALSE FALSE FALSE FALSE FALSE
_spfile_comment_validation_mode DISABLE Validate parameter comment format FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_analysis TRUE enable SQL analysis for reporting in plan TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_error_mitigation_control 0 internal controls for auto error mitigation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_error_mitigation_repeat_wait 86400 minimum wait time (seconds) between repeated mitigations TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_error_mitigation_retention 365 Auto error mitigation diagnostic tables retention period FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_error_mitigation_time_limit 600 maximum time limit (seconds) for error mitigation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_history_buffers 50 Min number of sql query history buffers to be monitored FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_history_buffers 50 Min number of sql query history buffers to be monitored FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_history_buffers 50 Min number of sql query history buffers to be monitored FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_sql_plan_management_comp_metric 3 controls metric used in comparing performance of plans in SPM TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sqlexec_window_function_settings 63 execution settings for window functions TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sqlmon_conitr_row_cache_size 50 Max rows fetched from keomnRefreshCacheFromPdbSwitchCbk() TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sqlmon_max_active_idle 0 Time (in sec) after which a SQL Monitor entry can be reclaimed TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_srvntfn_max_job_time 180 srvntfn max time per job FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_standby_parse_limit_seconds 0 Standby parse time limit (seconds) TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_standby_temp_file_management AUTO tempfile management on standby databases FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_statement_redirect_host NONE statement redirect host FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_statement_redirect_routing_function NONE statement redirect routing function FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_subname_for_object_patching NONE subname used to create a duplicate object for patching TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_subseg_debug 0 KTSV Subseg Debug TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_subseg_quiesce_threshold 10240 KTSV threshold size for loading to new subseg in MB TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_suppress_pg_population FALSE If true, all graph populations are suppressed TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_table_func_pred_pushdown FALSE enable table function predicate pushdown TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_tablespace_encryption_cipher_mode CFB default tablespace encryption block cipher mode FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_target_offload FALSE enable target offload functionality FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_target_offload_algorithm random algorithm for choosing target for offload TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_tempfile_monitor_interval 3600 tempfile monitor interval in seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_test_param_16 500 test parmeter 16 - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_test_param_16 500 test parmeter 16 - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_test_param_16 500 test parmeter 16 - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_text_batch_num 32 Text number of batches FALSE FALSE FALSE FALSE FALSE FALSE
_text_batch_size 8 Text batch size in Mb FALSE FALSE FALSE FALSE FALSE FALSE
_text_maintenance auto Text default maintenance setting FALSE FALSE FALSE FALSE FALSE FALSE
_tgtt_single_segment FALSE Whether to use single segment for trans GTTs FALSE FALSE TRUE FALSE FALSE FALSE
_thirteenth_spare_parameter   thirteenth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_threaded_execution FALSE Threaded Execution Mode Internal FALSE FALSE FALSE FALSE FALSE FALSE
_time_threshold_to_reboot_mmon_slv 86400 Time threshold to reboot MMON slave processes FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_true_cache_aff_hash_latches 16 True Cache affinity table latches FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_block_fetch_abort_timeout 6000 True Cache block fetch abort time out in centiseconds TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_true_cache_block_fetch_latency_histogram TRUE Enable True Cache block fetch latency histogram TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_true_cache_block_fetch_latency_limit 5000 True Cache block fetch latency in usec considered too large TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_true_cache_block_fetch_timeout 300 True Cache block fetch time out in centiseconds TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_true_cache_config NONE True cache config FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_true_cache_dest NONE True Cache destinations server list FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_true_cache_disc_time 5184000 True Cache disconnect time FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_heartbeat_interval 60 True Cache heartbeat interval FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_lad_max_failure 4 True Cache max LAD failures FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_lad_nettimeout 30 True Cache LAD net timeout time FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_lad_reopen 15 True Cache LAD reopen time FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_latch_less_htab FALSE Latchless affinity hash table access FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_max_unapplied_logs 10 True Cache max unapplied log files FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_payload_size 65536 True Cache RMI payload size FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_pdb_disc_time 216000 True Cache PDB disconnect time FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_temp_file_ext 10 True Cache default temp file extend FALSE FALSE FALSE FALSE FALSE FALSE
_true_cache_temp_file_size 100 True Cache default temp file size FALSE FALSE FALSE FALSE FALSE FALSE
_truecache_max_block_fetch_requests 1024 TrueCache maximum outstanding block fetch requests TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_tsq_shared_enabled TRUE Enable shared mode on tsq TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_tune_kctncv_diff_limit 134217728 Self-tune kctvncv diff limit for MTTR FALSE FALSE FALSE FALSE FALSE FALSE
_twelfth_spare_parameter   twelfth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_two_phase_rac_rolling_prepare_timeout 60 Prepare callback timeout for 2-Phase Rac Rolling in Seconds FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_txn_max_quarantines 3 Max number of transaction that can be quarantined FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_txn_max_quarantines 3 Max number of transaction that can be quarantined FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_txn_max_quarantines 3 Max number of transaction that can be quarantined FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_um_huge_page_pct 60 Min percent of shared memory in UM backed by large pages FALSE FALSE FALSE FALSE FALSE FALSE
_unified_memory_heap_mask 2 enable use of unified memory for these heaps FALSE FALSE FALSE FALSE FALSE FALSE
_unified_memory_pga_lim_pct 40 Percentage of pga limit in Unified Memory FALSE FALSE FALSE FALSE FALSE FALSE
_unified_memory_private_pct 20 Percentage of private memory in Unified Memory FALSE FALSE FALSE FALSE FALSE FALSE
_unified_memory_shared_pct 80 Percentage of shared memory in Unified Memory FALSE FALSE FALSE FALSE FALSE FALSE
_use_aes128_redo_encryption FALSE If true, use AES128 encryption for redo FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_use_kradc_fetch FALSE if TRUE, use kradc per process sync block fetch TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_use_saga_qtyp 0 Queue type used in SAGA infrastructure FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_use_shared_capture FALSE Enable GoldenGate Extracts to use Shared Capture Service FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_use_stored_fgd TRUE Enable use of stored fine-grained delta for invalidations TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_use_text_large_pages TRUE Use large pages for text if available FALSE FALSE FALSE FALSE FALSE FALSE
_uxt_cloud_delete_on_drop_table TRUE Delete cloud files on drop of updatable external table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_uxt_credential   credential name used for updatable external table data TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_uxt_diag_flags 0 flags to enable diagnostics for updatable external tables TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_uxt_uri_prefix   URI prefix for updatable external tables TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_wait_stats_cpus_per_set 16 Wait event stats: number of cpus per set FALSE FALSE FALSE FALSE FALSE FALSE
_xt_hybrid_addl_hidden_column FALSE enable additional hidden columns for external/hybrid table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_xt_table_hidden_column FALSE enable hidden columns for external table TRUE IMMEDIATE TRUE TRUE FALSE FALSE
allow_legacy_reco_protocol TRUE Should the database allow the legacy RECO protocol FALSE FALSE FALSE FALSE FALSE FALSE
allow_weak_crypto TRUE Allow weak crypto usage in DBMS_CRYPTO FALSE IMMEDIATE TRUE TRUE FALSE FALSE
blockchain_table_retention_threshold 16 maximum retention without TABLE RETENTION privilege FALSE IMMEDIATE TRUE TRUE FALSE FALSE
client_prefetch_rows 0 Client prefetch rows value TRUE IMMEDIATE TRUE TRUE FALSE FALSE
db_flashback_log_dest NONE Separate creation directory for flashback database logs FALSE IMMEDIATE FALSE FALSE FALSE FALSE
db_flashback_log_dest_size 0 Size limit of separate creation directory for flashback database logs FALSE IMMEDIATE FALSE FALSE FALSE FALSE
default_credential NONE default credential session parameter TRUE FALSE FALSE FALSE FALSE FALSE
group_by_position_enabled FALSE enable/disable group by position TRUE IMMEDIATE TRUE TRUE FALSE FALSE
identity_provider_config NONE Identity Provider Configuration FALSE IMMEDIATE TRUE TRUE FALSE FALSE
identity_provider_config NONE Identity Provider Configuration FALSE IMMEDIATE TRUE TRUE FALSE FALSE
identity_provider_config NONE Identity Provider Configuration FALSE IMMEDIATE TRUE TRUE FALSE FALSE
identity_provider_type NONE Identity Provider Type FALSE IMMEDIATE TRUE TRUE FALSE FALSE
identity_provider_type NONE Identity Provider Type FALSE IMMEDIATE TRUE TRUE FALSE FALSE
identity_provider_type NONE Identity Provider Type FALSE IMMEDIATE TRUE TRUE FALSE FALSE
inmemory_graph_algorithm_execution DEFAULT Controls the fall-back action of graph algorithm execution
if in-memory execution is not possible
TRUE IMMEDIATE TRUE TRUE FALSE FALSE
iorm_limit_policy RM_PLAN Policy used to compute Exadata IORM limit FALSE IMMEDIATE FALSE TRUE FALSE FALSE
ipddb_enable FALSE Enable IPD/DB data collection FALSE IMMEDIATE FALSE TRUE FALSE FALSE
json_behavior_flags NONE control json behaviors TRUE IMMEDIATE TRUE TRUE FALSE FALSE
json_expression_check off enable/disable JSON query statement check TRUE IMMEDIATE TRUE TRUE FALSE FALSE
load_without_compile none Load PL/SQL or Database objects without compilation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
main_workload_type OLTP Main workload type FALSE IMMEDIATE TRUE TRUE FALSE FALSE
max_columns STANDARD maximum number of columns allowed in table or view FALSE FALSE TRUE FALSE FALSE FALSE
max_columns STANDARD maximum number of columns allowed in table or view FALSE FALSE TRUE FALSE FALSE FALSE
max_columns STANDARD maximum number of columns allowed in table or view FALSE FALSE TRUE FALSE FALSE FALSE
max_saga_duration 86400 default value for max saga duration FALSE IMMEDIATE FALSE TRUE FALSE FALSE
memoptimize_write_area_size 0 changes memoptimize write area size FALSE IMMEDIATE FALSE TRUE FALSE FALSE
memoptimize_writes HINT write data to IGA without memoptimize_write hint TRUE FALSE FALSE FALSE FALSE FALSE
memory_max_size 0 Maximum memory size FALSE FALSE FALSE FALSE FALSE FALSE
memory_size 0 Target memory size FALSE IMMEDIATE FALSE TRUE FALSE FALSE
multilingual_engine enable Enable Multilingual Engine TRUE IMMEDIATE TRUE TRUE FALSE FALSE
pdc_file_size 0 size (in bytes) of the pmem direct commit file FALSE FALSE FALSE FALSE FALSE FALSE
plsql_implicit_conversion_bool FALSE PL/SQL: Implicit conversion for boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
result_cache_auto_blocklist ON whether to run the auto blocklisting algorithm FALSE IMMEDIATE TRUE TRUE FALSE FALSE
result_cache_integrity TRUSTED result cache deterministic PLSQL functions FALSE FALSE FALSE FALSE FALSE FALSE
saga_hist_retention 43200 default value for retention of completed sagas FALSE IMMEDIATE FALSE TRUE FALSE FALSE
session_exit_on_package_state_error FALSE Request client to exit when PL/SQL package state is discarded TRUE IMMEDIATE TRUE TRUE FALSE FALSE
shard_enable_raft_follower_read TRUE enable read from follower replications units in a shard TRUE IMMEDIATE TRUE TRUE FALSE FALSE
shard_enable_raft_follower_read TRUE enable read from follower replications units in a shard TRUE IMMEDIATE TRUE TRUE FALSE FALSE
shard_enable_raft_follower_read TRUE enable read from follower replications units in a shard TRUE IMMEDIATE TRUE TRUE FALSE FALSE
soda_behavior_flags NONE control soda behaviors TRUE IMMEDIATE TRUE TRUE FALSE FALSE
sql_error_mitigation off enables automatic error mitigation TRUE IMMEDIATE TRUE TRUE FALSE FALSE
sql_history_enabled FALSE SQL Query History is enabled when TRUE TRUE IMMEDIATE TRUE TRUE FALSE FALSE
sql_transpiler OFF Enable SQL transpiler TRUE IMMEDIATE TRUE TRUE FALSE FALSE
statement_redirect_service NONE statement redirect service FALSE IMMEDIATE TRUE TRUE FALSE FALSE
sysdate_at_dbtimezone FALSE use DB timezone while computing sysdate and systimestamp value TRUE IMMEDIATE TRUE TRUE FALSE FALSE
tablespace_encryption MANUAL_ENABLE Tablepsace encryption in hybrid ADG FALSE FALSE FALSE FALSE FALSE FALSE
time_at_dbtimezone off use DB timezone when computing current time FALSE FALSE TRUE FALSE FALSE FALSE
timezone_version_upgrade_integrity enforced perform DST upgrade leveraging constraints with desired integrity FALSE IMMEDIATE TRUE TRUE FALSE FALSE
tracefile_content_classification DISABLE enable output of trace record security label prefix FALSE FALSE FALSE FALSE FALSE FALSE
true_cache FALSE Enable True Cache FALSE FALSE FALSE FALSE FALSE FALSE
txn_auto_rollback_high_priority_wait_target 2147483647 Auto abort wait for high pri txns FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_high_priority_wait_target 2147483647 Auto abort wait for high pri txns FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_high_priority_wait_target 2147483647 Auto abort wait for high pri txns FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_medium_priority_wait_target 2147483647 Auto abort wait for medium pri txns FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_medium_priority_wait_target 2147483647 Auto abort wait for medium pri txns FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_medium_priority_wait_target 2147483647 Auto abort wait for medium pri txns FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_mode ROLLBACK Modes for Auto Transaction Rollback feature FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_mode ROLLBACK Modes for Auto Transaction Rollback feature FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_auto_rollback_mode ROLLBACK Modes for Auto Transaction Rollback feature FALSE IMMEDIATE TRUE TRUE FALSE FALSE
txn_priority HIGH Priority of a transaction in a session TRUE FALSE FALSE FALSE FALSE FALSE
xml_client_side_decoding true enable/disable xml client-side decoding TRUE IMMEDIATE TRUE TRUE FALSE FALSE
xml_handling_of_invalid_chars raise_error Handle invalid chars during xmlelement TRUE IMMEDIATE TRUE TRUE FALSE FALSE




Removed since 21.9 are 60 parameters
NAME DEFAULT_VALUE DESCRIPTION ISSES_MODIFIABLE ISSYS_MODIFIABLE ISPDB_MODIFIABLE ISINSTANCE_MODIFIABLE ISDEPRECATED ISBASIC
_allow_cross_version_chunk_move FALSE Oracle internal parameter FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_bct_initial_private_dba_buffer_size 0 initial number of entries in the private change tracking dba buffers TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug30932330_forceopen_bind_undotbs FALSE one-hundred-and-forty-fifth spare parameter - boolean TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug31789178_asm_quorum_hb FALSE Allow Quorum Disk Heartbeat TRUE IMMEDIATE FALSE TRUE FALSE FALSE
_bug31828999_lm_nodrm_service_pct 95 minimum nonsingleton service access percentage to disable drm TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug31897178_kspdgctrl NONE eighty-fourth spare parameter - string TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug31918168_keusp_stream_batch_size DEFAULT Number of KEUSP buffers to flush in a stream batch TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug31990919_keusp_max_num_alloc_buf DEFAULT Maximum number of KEUSP buffers in shared memory TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug32093558_j0_deq_maxwait_time 0 eighth spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug32093558_srvntfn_max_job_time 180 seventh spare parameter - integer TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug32171622_asm_reloc_restart_timeout 900 csecs before signaling ORA-15424 when waiting for orphans FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_bug32183142_hang_fast_track_progressing_sessions FALSE Hang Management fast-track progressing sessions enabled TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug32498459_max_small_page_sga_size 0 Maximum SGA size with small pages FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_bug32533019_DON_for_update_enabled FALSE Default on null for update feature enabled FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_bug32822436_hang_prog_ft_critical_db_proc_verification_interval 900 Hang Manager progressing,
fast-tracked critical db process verification interval
TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug32823692_hang_parsing_hangs_resolution_interval 0 Hang Manager parsing hangs resolution interval FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_bug33863150_client_prefetch_rows 0 Client prefetch rows value TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_bug34010877_enable_streams_pool_subpools FALSE enable streams pool multiple subpools FALSE FALSE FALSE FALSE FALSE FALSE
_cell_offload_backup_compression TRUE enable offload of backup compression to cells TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ctx_doc_policy_stems FALSE enable ctx_doc.policy_stems api TRUE FALSE FALSE FALSE FALSE FALSE
_dedicated_server_poll_count 10 dedicated server poll count FALSE FALSE FALSE FALSE FALSE FALSE
_dedicated_server_post_wait FALSE dedicated server post/wait FALSE FALSE FALSE FALSE FALSE FALSE
_dedicated_server_post_wait_call FALSE dedicated server post/wait call FALSE FALSE FALSE FALSE FALSE FALSE
_disable_flashback_archiver 0 disable flashback archiver FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_enable_ffw TRUE FAL FORWARDING FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_enable_mle TRUE enable MLE FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_fix_control1   bug fix control overflow parameter-1 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control2   bug fix control overflow parameter-2 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control3   bug fix control overflow parameter-3 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control4   bug fix control overflow parameter-4 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_fix_control5   bug fix control overflow parameter-5 FALSE IMMEDIATE TRUE TRUE FALSE FALSE
_gc_undo_block_disk_reads TRUE if TRUE, enable undo block disk reads FALSE FALSE FALSE FALSE FALSE FALSE
_gc_xmem_rdma FALSE if TRUE, xmem blocks rdma read is enabled FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_gcr_enable_async_slaves TRUE if TRUE, GCR will spawn slave actions asynchronously FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hang_high_session_count_update_hb_threshold 2000 Hang Manager high session count update heartbeat threshold FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_hcs_disable_audit_opt FALSE disable audit optimization TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_disable_inline FALSE add inline hint to star block TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_disable_sql_plan_baselines FALSE disable sql plan baselines TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_enable_adw FALSE enable ADW TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_enable_basetbl_transform FALSE enable base table transform TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_hcs_enable_fact_rows FALSE enable fact rows TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ipddb_enable FALSE Enable IPD/DB data collection FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_kdli_sio_fgio TRUE reap asynchronous IO in the foreground TRUE FALSE TRUE FALSE FALSE FALSE
_kernel_message_network_driver FALSE kernel message network driver FALSE FALSE FALSE FALSE FALSE FALSE
_kgl_message_locks 0 RAC message lock count FALSE FALSE FALSE FALSE FALSE FALSE
_kkpox_prtmv_rel_lock 0 explicitly release PRTMV heap during cursor compile TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_ksipc_trace_bucket PRIVATE memory tracing: use ksipc-private or rdbms-shared bucket FALSE FALSE FALSE FALSE FALSE FALSE
_ksipc_trace_bucket_size IPC0:1048576-REST:8192 KSIPC trace bucket size in bytes (format: "IPC0:<n>-REST:<m>") FALSE FALSE FALSE FALSE FALSE FALSE
_ksxp_disable_rolling_migration FALSE disable possibility of starting rolling migration FALSE FALSE FALSE FALSE FALSE FALSE
_limit_itls 20 limit the number of ITLs in OLTP Compressed Tables FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_lock_dc_users_time 120 max time to attempt to lock dc_users TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_mv_logical_partition_rewrite_enabled FALSE enable/disable Logical Partition based rewrite TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_mv_logical_partition_tracking_enabled FALSE enable/disable Logical Partition Tracking FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_redo_transport_catch_up_bandwidth_percentage 50 redo transport catch up bandwitdth percent FALSE IMMEDIATE FALSE TRUE FALSE FALSE
_sess_template_spares TRUE session template: spares FALSE FALSE TRUE FALSE FALSE FALSE
_spm_filter FALSE Knob for turning spm filter for fix 32924796 rolling issue TRUE IMMEDIATE TRUE TRUE FALSE FALSE
_sysdate_at_dbtimezone FALSE return SYSDATE at database timezone FALSE FALSE TRUE FALSE FALSE FALSE
_uts_force_seclabel_prefix FALSE Force output of trace record security label prefix FALSE FALSE FALSE FALSE FALSE FALSE
allow_deprecated_rpcs YES allow deprecated rpcs FALSE IMMEDIATE TRUE TRUE FALSE FALSE
log_archive_start FALSE start archival process on SGA initialization FALSE FALSE FALSE FALSE TRUE FALSE


87 parameters have changed default values: 
NAME 21_default_value 23_default_value DESCRIPTION
_actgrp_spawn_offload TRUE FALSE action group spawn offload
_alert_segment_size 10 50 Alert-log segment size in MBs (1024*1024)
_alert_segment_textfile FALSE TRUE Alert-log text-file also to be segmented
_alert_segments_max 0 20 Alert-log max segments to retain, 0 for unlimited
_asm_compatibility 11.2.0.2 18.0 default ASM compatibility level
_asm_enable_batch_scrub FALSE TRUE Allow scrubbing verification to run in batch mode
_asm_min_compatibility 11.2.0.2 18.0 default mininum ASM compatibility level
_asm_read_cancel AUTO DYNAMIC Read cancel timeout in milliseconds
_assm_auto_tracing_threshold 10000 0 ASSM threshold to start space search tracing
_bct_health_check_interval 60 0 CTWR health check interval (seconds), zero to disable
_bloom_pushing_total_max 262144 20971520 bloom filter combined pushing size upper bound (in KB)
_bsln_adaptive_thresholds_enabled TRUE FALSE Adaptive Thresholds Enabled
_cdb_special_old_xplan TRUE FALSE display old-style plan for CDB special fixed table
_cloudsql_offload_enabled FALSE TRUE enable CloudSQL cell offload support
_cross_con_collection FALSE TRUE enable cross container collection
_cursor_reload_failure_threshold 0 20 Number of failed reloads before marking cursor unusable
_default_service TRUE 1 Run default service in various modes
_dgpdb_standby_controlfile_name dgpdb_temp_copy_cf_%u_stby_%u_%u.cf dgpdb_stdby_cf_pdbid_%u_%u_%u.cf a name template with three %u's for DGPDB standby controlfile
_dlm_stats_collect_mode 6 14 DLM statistics collection mode
_dump_trace_scope globa global scope of trace dump during a process crash
_enable_securefile_flashback_opt FALSE TRUE Enable securefile flashback optimization
_gcs_reserved_resources 400 64 allocate the number of reserved resources in reconfiguration
_gcs_spin_check_instance_threshold 30 60 threshold timeout to dump proc in spin check in seconds
_ges_direct_free_res_type ARAH ARAHHV string of resource types(s) to directly free to the freelist
_ges_freeable_res_chunk_free TRUE FALSE if TRUE, free dynamic resource chunks which are freeable
_ges_gather_res_reuse_stats FALSE TRUE if TRUE, gather resource reuse statistics
_ges_optimizations 3 7 GES optimizations level
_ges_resource_memory_opt 4 36 enable different level of ges res memory optimization
_global_hang_analysis_interval_secs 10 5 the interval at which global hang analysis is run
_hang_blocked_session_percent_threshold 20 0 Hang Manager fast-track blocked session percent threshold
_hcs_enable_av_auto_cache FALSE TRUE enable AV auto-cache
_inmemory_format_compatible 19.0.0 21.0.0.0.0 In-memory format compatibility parameter
_inmemory_private_journal_numbkts 512 2048 Number of priv jrnl ht bkts
_inmemory_private_journal_numgran 255 32 Number of granules per HT node
_inmemory_shared_journal_minexts_repop 64 256 min number of extents per SJ to trigger repop
_inmemory_transaction_options 2806 10998 in-memory transaction performance options
_instance_recovery_bloom_filter_fprate 0 0.01 Allowable false positive percentage (0.001% to 100.00%)
_instance_recovery_bloom_filter_size 83886080 10485760 Bloom filter size (in bytes) used during claim phase
_kebm_preshut_act_enabled FALSE TRUE Enable/disable MMON Pre-shutdown Action
_key_vector_max_size 0 524288 maximum key vector size (in KB)
_kffmop_chunks 42 128 number of chunks of kffmop's
_ksws_modsvc_call_out_enabled FALSE TRUE modify service call out enabled
_lm_cache_res_type TMHWHVDI TMHWDI cache resource: string of lock types(s)
_lm_drm_duration_limit_type 2 1 drm object time limit type (time/size)
_lm_drm_filters 3 7 enable drm filters
_lm_drm_max_banned_objs 235 10 maximum number of objects not allowed to do drm
_lm_enable_pdb_abort 0 1 enable pdb abort as default failure action
_lm_pdb_weight_opts 27 90 options to size RHT structures per pdb
_lm_resource_recycle_cnt 32 4 GES: number of resources to recycle optimization
_max_incident_file_size NONE 320M Maximum size (in KB, MB, GB, Blocks) of incident dump file
_max_services 8200 25000 maximum number of database services
_min_lwt_lt 24 10 minimum low threshold for LWTs
_mle_enable_compilation FALSE TRUE enable runtime compilation for MLE
_nvm_dispatchers 3 1 number of NVM Dispatcher Slaves
_optimizer_undo_cost_change 21.1.0 23.1.0 optimizer undo cost change
_rdbms_compatibility 10.1 12.2 default RDBMS compatibility level
_redo_transport_min_kbytes_sec 10 0 redo transport minimum KB/s
_runtime_index_key_length_check 0 1 allow runtime checking of index key length
_shared_pool_reserved_pct 5 7 percentage memory of the shared pool allocated for the reserved area
_spadr YES NO _SPADR
_strict_utl_http_smtp TRUE FALSE Enforce strict URL checks on UTL_HTTP and UTL_SMTP Packages
_temp_undo_disable_refresh_clone TRUE FALSE is temp undo disabled on refreshable clone PDB
_uts_trace_disk_threshold 0 1073741824 Trace disk threshold parameter
_uts_trace_segments 5 4 Maximum number of trace segments
audit_sys_operations TRUE FALSE enable sys auditing
awr_pdb_autoflush_enabled FALSE TRUE Enable/Disable AWR automatic PDB flushing
awr_pdb_autoflush_enabled FALSE TRUE Enable/Disable AWR automatic PDB flushing
awr_pdb_autoflush_enabled FALSE TRUE Enable/Disable AWR automatic PDB flushing
db_lost_write_protect NONE AUTO enable lost write detection
db_securefile PERMITTED PREFERRED permit securefile storage during lob creation
large_pool_size 134217728 150994944 size in bytes of large pool
max_datapump_jobs_per_pdb 100 AUTO maximum number of concurrent Data Pump Jobs per PDB
max_datapump_parallel_per_job 50 AUTO maximum number of parallel processes per Data Pump Job
max_dump_file_size unlimited 32M Maximum size (in bytes) of dump file
object_cache_optimal_size 10240000 51200000 optimal size of the user session's object cache in bytes
optimizer_features_enable 21.1.0 23.1.0 optimizer plan compatibility parameter
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
shared_pool_size 134217728 150994944 size in bytes of shared pool
tablespace_encryption_default_algorithm AES128 AES256 default tablespace encryption block cipher mode
use_dedicated_broker TRUE NONE Use dedicated connection broker

Keine Kommentare: