<< 返回文章列表
续篇二:Oracle 18.3 版本参数比较12.2 看新特性优化诊断增强
2018年8月3日
eygle
1756
_hcs_no_fltr_fact_opt FALSE apply filtered fact optimization _hcs_no_fltr_hier_star_opt FALSE apply filtered hierarchy star optimization _hcs_no_inline_tmpl_opt FALSE apply inline single ref top blocks optimization to cell query _hcs_no_jback_opt_for_hord_in_oby FALSE optimize analytic view joinback for HIER_ORDER _hcs_no_mdx_cache_hint FALSE generate hcs query mdx cache hints _hcs_no_mv_rewrite_check FALSE skip MV rewrite check when generating for ANALYTIC VIEW cache _hcs_no_opt_cell_qry FALSE optimize cell query _hcs_no_rm_like_withs_optz FALSE skip like WITH element removal optimization on generated SQL _hcs_no_rm_unused_withs_optz FALSE skip unused WITH element removal optimization on generated SQL _hcs_no_rmv_unref_top_opt FALSE apply remove unref top blocks optimization to cell query _hcs_no_tgt_depths_opt FALSE apply target depths optimization _hcs_opt_av_pred_push TRUE enable optimizer AV predicate pushing via reparse _hcs_parse_dynamic_all_cache FALSE allow parsing of dynamic across all levels cache _hcs_stats_max_card 2000000 maximum value for stats cardinality _hcs_use_dynamic_all_cache FALSE use dynamic across all levels cache _hcs_use_multi_parent_gen FALSE generate hcs query using multi-parent aggregation _hugetlbfs_mount_point_for_sga HugeTLBFS mount point to be used _imado_diagtasks_log_period 5 IM-ADO diagnostic tasks logging period (in seconds) _imado_diagtasks_purge_period 30 IM diagnostic tasks purge older than X days _imado_evict_sf 2 AIM evict safety factor _imado_sysaux_usage_limit 90 SYSAUX usage percent limit for storing AIM diagnostics _imtxnrma_table_enable FALSE is In-Memory RMA Txn Table cache enabled _index_load_analysis_frequency 4 index load compression analysis frequency _inmemory_adg_batched_flush TRUE If true, batched flush is performed _inmemory_adg_journal_quota FALSE If true, throttled mining is performed under space pressure _inmemory_adg_parallel_flush TRUE If true, parallel flush is performed _inmemory_adg_periodic_sort FALSE If true, periodic sort is performed _inmemory_delta_population 0 Control Delta IMCU population _inmemory_dynamic_scans_analyze_batch_size 5 Inmemory dynamic scan analyze batch size _inmemory_external_table TRUE Enable inmemory extern table _inmemory_grpcolinv_buffer_size 131072 In-memory grpcolinv buffer size _inmemory_grpcolinv_granularity 1 In-memory grpcolinv blks per colmap _inmemory_hwm_expand_percent 20 max blks percent can exceed in hwmimcu _inmemory_hwm_expansion 0 If 0, the highwatermark CU is dropped when expanded _inmemory_max_delta 5 Inmemory max number of deltas per CU _inmemory_min_delta_blocks 50 Inmemory minimum blocks per delta _inmemory_min_delta_rows 255 Inmemory minimum rows per delta _inmemory_patch_background_blocks 200 In-memory SMU patch threshold blocks to start background tasks _inmemory_patch_commit_path FALSE If true, enable the SMU patching from DML path _inmemory_patch_threshold_blocks 25 In-memory SMU patch threshold blocks _inmemory_prefix_encode_dsbs FALSE Prefix-encode the DSB-dictionary _inmemory_scan_invalid_percent 30 Inmemory scan invalid percentage _inmemory_smu_patch_options 7 Inmemory SMU patching options _inmemory_vector_encode_override FALSE Populate and use DSBs for Vector Encode columns _instance_recovery_bloom_filter_fprate 0 Allowable false positive percentage [0-100] _instance_recovery_bloom_filter_size 83886080 Bloom filter size (in num of bits) used during claim phase _intra_cdb_dblink FALSE enable intra CDB implicit dblink _kcfis_pmem_enabled FALSE RDMA Persistent Memory support enabled _kdfip_buf_nclatch 64 memopt w buffer child latches _kdfip_bufl_nbkt 64 memopt w buffers list buckets _kdfip_cmap_nbkt 16 memopt w chunk map buckets _kdfip_debug 0 memopt w debug _kdfip_drain_sleeps 60 memopt w drain coord sleep count _kdfip_elem_nclatch 64 memopt w chunkmap elem child latches _kdfip_flush_nrows 10 memopt w flush num rows _kdfip_flush_rowsz 1024 memopt w flush row size _kdfip_flush_rowtm 60 memopt w flush time _kdfip_iga_bufsz 65536 memopt w write buffer size _kdfip_iga_maxsz 52428800 memopt w max global area size _kdfip_par_flush TRUE memopt w parallel flush _kdfip_trace FALSE memopt w tracing on-off _kdkv_fg_drop_memopt TRUE hashindex foreground drop _kdkv_fg_no_memopt FALSE hashindex foreground cleanup _kdkv_fg_populate FALSE hashindex foreground populate _kdkv_fg_repopulate FALSE hashindex foreground repopulate _kdkv_force_fastpath FALSE kdkv fast path on-off _kdkv_index_lossy TRUE hashindex lossiness on-off _kdkv_index_relocate FALSE hashindex relocation on-off _kdkv_indexinvalid FALSE objd and rdba based index invalidation _kdkv_trace FALSE kdkv tracing on-off _kdlxp_no_dedup_on_insert FALSE disable deduplication for new inserts of deduplicated lobs _key_vector_double_enabled TRUE enables or disables key vector support for binary_double _key_vector_shared_dgk_ht TRUE allows shared DGK hash table _key_vector_timestamp_enabled TRUE enables or disables key vector support for timestamp _kra_cfile_compaction TRUE controlfile record compation _kse_alt_stack_sig_syms 10 The number of top symbols used for the alternate stack signature _ksipc_trace_bucket PRIVATE memory tracing: use ksipc-private or rdbms-shared bucket _ksipc_trace_bucket_size IPC0:1048576-REST:8192 KSIPC trace bucket size in bytes (format: "IPC0:-REST:") _ksipc_window_size Configure IPC Windowing Value for clients on a per transport basis _ksipcsnsrv Configure Shared Nothing Server Name _ksm_sp_rcr_hits 10 hits to make object recurrent _ksmd_trace 0 ksmd tracing _ksmsq_hintmaxinst 1024 KSMSQ Hint Max Instances _ksmsq_hintmaxproc 300 KSMSQ Hint Max Processes _ksws_java_patching 0 java patching mode _kswsas_drain_kill_batch_size 5 Batch size for killing non-drained sessions _kswsas_num_jp_slaves Number of slaves for java patching _ksxp_validate_cnh_life_cycle 0 enable validation of ksxp connection life cycle _ktst_tscleanup_timeout 1800 Time in seconds to wait for active temp clients _ldap_config_force_sync_up FALSE LDAP configure force sync up _ldap_config_ssl_for_sasl_md5 TRUE LDAP configure SSL for SASL-DIGEST-MD5 _ldap_reset_user_account_flc TRUE LDAP reset user account lockout counter _lm_chk_inv_domenq_ops TRUE enable checks for invalid enqueue operations on domains _lm_comm_slow_op_loop_threshold 15 GES communication slow operation loop threshold in ms _lm_enq_iso_enabled TRUE if TRUE enables enqueue isolation _lm_idle_connection_action kill GES idle connection action _lm_idle_connection_load_check TRUE GES idle connection load check _lm_nonisolated_restype TOTTUL string of resource types banned from enqueue isolation _lm_pdb_wait_all_gone FALSE pdb domain attach wait until all locks are gone _lm_recovery_set 1 enable recovery set checking for accessing invalid domains _lm_share_lock_pdbisolation TRUE if TRUE enables share lock optimization with pdb isolation _lm_use_us_timer FALSE Use microsecond timer for LM hist _lm_wait_for_hub_rcv_timeout 300000 read-only insts wait for hub avaliable to recover in millis _lmhb_procstate_dump_cputime_limit 60 hb diagnostic cputime limit for process state dump in secs _lmhb_procstate_dump_runtime_limit 60 hb diagnostic runtime limit for process state dump in secs _lob_use_locator_varying_width FALSE use varying width flag in lob locator _max_lwt_cpu_ratio 2 ratio to determine the maximum CPUs for LWTs _memoptimize_xmem_pool_size 0 Size of MEMOPTIMIZE buffer pool for standard block size buffers on extended memo ry _memory_adi_module_mask 0 bit mask of modules to enable ADI versioning _mga_large_page_path large page path _next_pdbid 3 Hint for the next PDBID to use when creating a new PDB entry _no_catalog options whose schemas should not be created _no_snapshot_root_clone FALSE No snapshot clone during Application Root Clone creation _nologging_apply_stall_time 1000 milli-seconds recovery waits after DTC full before changing RCVID _nologging_fetch_initial_interval 2 seconds recovery waits between issuing fetches for old ranges _nologging_mode_override 0 Override the database logging mode; 1=Force, 2=NoForce, 3=LP, 4=DA _nologging_progress_keep_alive 10 Nologging standby progress keep alive time _nologging_slots 20 Nologging standby: initial buffer count _nologging_standby_cold_buffer_timeout 500 Centi-seconds recovery will wait for a buffer that is not being sent by a direct load client in Nologging Standby Data Availability mode _nologging_standby_dtc_expire 600 The number of seconds a Data Transfer Cache buffer may remain unclaimed _nologging_standby_fetch_disable FALSE controls whether invalid block ranges are fecthed during recovery _nologging_standby_hot_buffer_timeout 500 Centi-seconds recovery will wait for a buffer being sent by a direct load client in Nologging Standby Data Availabilty mode
由于字数超出,请关注续篇。