<< 返回文章列表
Oracle 18.3 版本参数比较12.2 看新特性优化诊断增强
2018年8月3日
eygle
2722
_datapump_inherit_svcname FALSE Inherit and propagate service name throughout job
_db_flash_cache_slow_io_adjustment_interval 3600 Decrement interval
_db_imoltp_hashidx_force_nonctg 0 kcbw imoltp hash index force non contig granules
_db_shadow_lost_write_protect NOT_SET alter shadow lost write detection for PDB
_disable_actualization_for_grant FALSE disable actualization of editioned objects on grant
_disable_asm_audit_feat 0 disable ASM audit features
_disable_dblink_optim TRUE disable intra CDB dblink optimizations
_disable_system_tablespaces_enc_enforcement FALSE if TRUE, disable system tablespaces encryption enforcement
_dmm_pga_load_threshold 3 Model size less than threshold are loaded into PGA
_drain_on_ping_database TRUE Should session drain be performed when user issues OPING
_dskm_single_instance FALSE DSKM and Diskmon operating in Single Instance mode
_dss_cache_flush_threshold 1 threshold when thread ckpt considered over obj ckpt
_duplicated_table_complete_refresh_percent 50 percent threshold for duplicated table to do complete refresh
_dupt_noupdate 0 disable duplicated table updates
_ena_storage_lmt DEFAULT Enable storage clause for LMT
_enable_auto_upgrade FALSE Enable automatic PDB upgrade
_enable_dbwr_auto_tracing 0 enable dbwriter auto-tracing
_enable_imc_mira FALSE enable IMC with multi instance redo apply
_enable_ios_spm FALSE Allow Split Mirror operations via IOServer
_enable_multiple_fgprepares FALSE Allow concurrent PREPAREs on the same database
_enable_parallel_dml FALSE enables or disables parallel dml
_enable_pmo_outside_begin_end TRUE Enable PMO outside begin-end block
_enable_proxy_adg_redirect FALSE Enable Statement Redirection Support for ADG using Proxy PDB
_enable_single_dgprepare FALSE Disable concurrent PREPAREs in same disk group
_error_row_predicate_evaluation AUTO skip predicate evaluation for error rows
_exadata_feature_on FALSE Exadata Feature On
_fg_fast_sync_sleep_usecs 50 DAX log file sync sleep time
_fg_fast_sync_spin_usecs 300 DAX log file sync spins time
_force_active_temp_detection FALSE Force active temp detection during PDB close
_freeze_kgh_timestamp FALSE prevent heap manager timestamp from advancing
_gc_lease_time 500 lease time for rdma reads
_gc_max_reg_sz 68719476736 maximum length for memory registration
_gc_partial_cleanout FALSE if TRUE, partial cleanout is enabled
_gc_undo_rdma_read FALSE if TRUE, rdma read of undo blocks is enabled
_gcs_disable_imc_preallocation FALSE disable preallocation for imc memory requirement in RAC
_gcs_enable_private_iterator TRUE Enable private iterator for GCS locks
_gcs_recoverable_asserts 1 if non-zero, enable recoverable assert resolution
_gdr_control_flags 0 gdr control flags
_gds_allow_nullkey 0 allow the use of nullable shard key columns
_gds_max_chunk_num 0 max chunk_num used in sharding environment
_ges_mseq_demo 0 demo mseq wrap scenarios (dflt is 0)
_globaldict_analyzer_pct 100 Maximum percentage of unique values in analyzer phase for GD
_globaldict_chain_limit 32 Chain limit for global dictionary
_globaldict_check 0 Dictionary checking
_globaldict_chunk_minalloc FALSE Force minimum chunk allocation size
_globaldict_dbg 0 Global dictionary debug modes
_globaldict_enable 2 Enable segment dictionary
_globaldict_max_gdsize 1073741824 Maximum number of entries in a Global dictionary
_globaldict_reprobe_limit 1 Reprobe limit for global dictionary
_globaldict_use_ndv TRUE Use NDV for sizing global dictionary, if available
_gwm_db_unique_name gsm db_unique_name name
_hang_appl_issue_session_threshold 0 Hang Management application issue session threshold
_hang_asm_hang_resolution_enabled FALSE Hang Management ASM hang resolution enabled
_hang_deadlock_resolution_enabled TRUE Hang Management deadlock resolution enabled
_hang_hang_blocked_session_delta_percent_threshold 20 Hang Manager hang's blocked session delta percent threshold
_hang_ignore_hngmtrc_interval 150 Hang Management ignore hang metric dependent hang interval
_hang_intersecting_chains_scanning_enabled TRUE Hang Management intersecting chains scanning is allowed
_hang_log_important_hangs_to_alert TRUE Hang Management log important hangs to alert log
_hang_promote_process_termination_interval 70 Hang Management promote process termination interval in seconds
_hang_root_ha_phase_trigger_time 300 Hang Management root HA phase trigger time
_hcs_expose_with_expr FALSE expose internal with_expression
_hcs_gen_aggr_opt_estimate FALSE apply OPT_ESTIMATE hint to aggregation queries
_hcs_ignore_latest_compat_check FALSE skip compatibility check for latest compatible version
_hcs_in_mem_cdt_hint FALSE add hint opt_param('_in_memory_cdt', 'off')
_hcs_mdx_cache_name_col FALSE add column for mdx cache name
_hcs_mdx_cache_name_no_sid FALSE don't use session id in mdx cache hint names
_hcs_mdx_sleep_after_pin FALSE sleep after pinning MDX caches
_hcs_no_calc_dtm_to_out_opt FALSE apply move calc determined hier to output hier optimization
_hcs_no_cell_qry_atr_prune_opt FALSE apply attribute prune optimization to cell query
_hcs_no_cell_qry_lvl_prune_opt FALSE apply level prune optimization to cell query
_hcs_no_cell_qry_meas_prune_opt FALSE apply measure prune optimization to cell query
_hcs_no_cell_qry_mv_cache_opt FALSE apply mv cache optimization to cell query
_hcs_no_cell_qry_no_calc_nav_opt FALSE apply no calc navigation optimization to cell query
_hcs_no_cell_qry_no_out_data_opt FALSE apply no output data optimization to cell query
_hcs_no_cell_qry_tmpls FALSE no cell query templates for optimization
_hcs_no_col_prune_optz FALSE skip column pruning optimization on generated SQL
由于字数原因,请关注续篇 。