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:
Kommentar veröffentlichen