<< 返回文章列表
Oracle 18.3 版本参数比较12.2 看新特性优化诊断增强
2018年8月3日
eygle
2687
_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 由于字数原因,请关注续篇 。