内容简介：废弃的参数，在12.2 中存在，可是在 18.3 中已经被驱逐的废弃参数，数量是 43 个，参考如下列表：>>
在 Oracle Database 18.3 版本发布之后，一系列新的参数被加入到数据库中，这些新的参数就代表了数据库中新增的特性。
很多特性Oracle并未明确解释何说明，但是我们可以通过参数揣摩端倪。
以下列表是对比 Oracle Database 12.2 版本，18.3 中新增的参数。通过 x$ksppi 可以看到 12.2 版本有 4846 个参数，而 18.3 有 5159 个参数.
从参数数量上来说，增加了 313 个，这是一个不小的数字，无论是跟踪诊断，性能优化，还是 异常恢复，这些参数都是核心所在。
KSPPINM KSPPSTVL KSPPDESC
-------------------------------------------------- ------------------------- --------------------------------------------------------------------------------
_EnableDDLTtriggerTracing FALSE enable ddl trigger tracing
_EnableShadowTypes FALSE enable shadow types
_REMOVE_INACTIVE_STANDBY_TDE_MASTER_KEY FALSE Remove Inactive Standby TDE Master Key
_REMOVE_STDBY_OLD_KEY_AFTER_CHECKPOINT_SCN TRUE Remove standby old key after checkpoint SCN
_STFTranslateDynamicSQL FALSE if TRUE translation profile will translate dynamic SQL statements
__memoptimize_xmem_pool_size_metadata 0 Size of extended cache metadata of MEMOPTIMIZE buffer pool for standard block si
ze buffers
__sga_current_size 0 Current size for PDB SGA
_adg_auto_close_pdb TRUE ADG recovery auto close PDB upon PDB drop/unplug/rename marker
_adg_objectlock_attempts 2 Maximum attemps for objectlock get on ADG
_adg_objectlock_maxnum 1000 The maximum limit of the objectlock number on ADG
_adg_objectlock_timeout 0 timeout for objectlock get on ADG in centiseconds
_adg_redirect_flags 0 Flags for controlling ADG's Statement Redirection behavior
_allocate_flashback_buffer FALSE Allocate flashback buffer at mount time even if flashback is off
_allow_cross_endian_dictionary FALSE Allow cross-endian data dictionary
_app_container_debug 0 Enable Debug tracing in Application container
_apppdb_multi_slave_sync TRUE Multiple slaves used during Application sync
_aq_dqblocks_in_cache 0 deq blocks in cache
_aq_free_list_pools 10 state object and transaction memory pools
_aq_lb_garbage_col_interval 600 AQ LB garbage collect interval
_aq_lb_subht_bkt_ltch 32 AQ LB subscriber ht bucket latches
_aq_lb_subht_elm_ltch 128 AQ LB subscriber ht element latches
_aq_max_pdb_close_msg 1 Max Number of AQ Recovery Messages when pdb is closed
_aq_scrambled_deqlog 1 scrambled deqlog
_asm_allow_dgname_special_chars FALSE Enable the use of special characters in diskgroup names
_asm_async_scrub_reap_wait 100000 Async scrubbing reaping IO wait in microseconds
_asm_cancel_delta 75000 Delta timeout for blocking big writes in milliseconds
_asm_enable_batch_scrub FALSE Allow scrubbing verification to run in batch mode
_asm_enable_kfios FALSE Enable KFIOS module
_asm_oda_type ODA Type
_asm_proxy_online_restart 0 Allow patching while ADVM volumes are online
_asm_pstonpartners TRUE Select ideal PST disks following partnership
_asm_reloc_cic FALSE Allow relocation during rolling migration
_asm_relocation_scheme alloc_p2 alloc_s3 reb_p2 ASM allocation / relocation scheme
reb_s1 bal_p2 bal_s3 prep
_p2 prep_s3
_asm_write_badfdata_in_contentcheck TRUE Write BADFDA7A in content check
_asm_zero_power_limit allow setting zero power limit
_async_scn_sync OFF Asynchronous SCN Sync Setting
_auto_dismount_on_pdb_close FALSE Enable implicit PDB dismount on PDB close
_auto_rcv_pdb_open 1 enable automatic recovery during pdb open
_awr_incremental_flush_enabled TRUE Enable/Disable AWR automatic incremental flushing
_backup_block0 default backup block0
_bequeath_via_broker FALSE Bequeath connections via broker
_bloom_extent_size 0 bloom filter extent size in bytes
_bloom_filter_setops_enabled TRUE Allow bloom filter to be pushed through set operations
_bloom_max_wait_time 50 bloom filter wait time upper bound (in ms)
_bloom_pruning_setops_enabled TRUE Allow bloom pruning to be pushed through set operations
_bloom_use_shared_pool FALSE use shared pool for bloom filter
_bloom_wait_on_rac FALSE enables bloom filter (with hash hash distribution) wait on RAC
_capability_simulate Simulate the capabilities for testing
_cdb_fleet_sync_timeout 10 Time in minutes to wait for sync of stub entry in CDB Fleet
_cdb_port 0 Port number for CDB
_cdb_view_no_skip_restricted FALSE do not skip RESTRICTED mode PDBs from results of CONTAINERS()
_cell_offload_hybrid_processing TRUE enable hybrid SQL processing offload to cells
_cell_offload_vector_groupby_force FALSE force offload of vector group by
_cgs_publish_netinfo_collect_event_chm TRUE enable cgs publish collect_netinfo event to event stream for CHM
_cgs_publish_netinfo_collect_event_haip FALSE enable cgs publish collect_netinfo event to event stream for HAIP
_clear_preserved_buffers TRUE Clear preserved buffers before DB reopen after switchover
_client_result_cache_ramthreshold client_result_cache_ramthreshold
_cloud_service_sim 0 simulate cloud services in Database
_cloud_service_type cloud service type
_con_map_sql_enforcement TRUE disable container map SQL enforcement
_connection_broker_handout_accept FALSE connection broker accepts prior to handout
_cross_con_collection FALSE enable cross container collection
_datapump_gather_stats_on_load FALSE Gather table statistics during Data Pump load rather thanimporting statistics fr
om the dump file. This should be set to TRUE in the lockdown profile in a DWCS e
nvironment.
_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
_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:
<n>
-REST:
<m>
")
_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
_nologging_standby_refetch_disable FALSE controls fetching of pre-existing invalid block ranges during standby recovery
_optimizer_allow_all_access_paths TRUE allow all access paths
_optimizer_answering_query_using_stats FALSE enable statistics-based query transformation
_optimizer_gather_stats_on_load_all FALSE enable/disable online statistics gathering for nonempty segments
_optimizer_gather_stats_on_load_hist FALSE enable/disable online histogram gathering for loads
_optimizer_key_vector_payload TRUE enables or disables dimension payloads in vector transform
_optimizer_vector_fact_payload_ratio 20 cost based vector transform payload dimension to fact ratio
_parallel_lmd_reconfig 1 parallel lmd work in reconfiguration for enqueues.
_partition_by_con_name FALSE enable partitioning by con$name
_pdb_ignore_table_clauses TRUE Ignore subset of clauses in CREATE TABLE and ALTER TABLE
_pdb_isolation_class NONE PDB isolation level: NONE, HIGH or MAX
_pdb_ldp_cascade 0 pluggable database lockdown profile cascade param
_pga_limit_per_process_minimum 3145728 pga_aggregate_limit per-process minimum
_pmon_exitnfy_enabled FALSE PMON Exit notification enabled
_ptf_enable_objects FALSE enable object types in PTF
_ptf_max_rows 1024 number of rows per row-buffer
_ptt_max_num 16 Maximum number of PTTs per session
_px_granule_alignment 1024 default size of a rowid range granule (in KB)
_px_join_skew_null_handling TRUE enables null skew handling improvement for parallel outer joins
_px_join_skew_sampling_percent 0 Sets sampling percentage for skew handling sampling queries
_px_join_skew_sampling_time_limit 50 Sets execution time limit for skew handling sampling queries
_px_join_skew_use_histogram TRUE Enables retrieval of skewed values from histogram when possible
_px_nlj_bcast_rr_threshold 10 threshold to use broadcast left random right distribution for NLJ
_px_partition_skew_threshold 80 percentage of table size considered as threshold for skew determination
_px_pwise_wif_enabled TRUE enable parallel partition wise window function
_px_reuse_server_groups MULTI enable/disable reusing of server groups that are already acquired
_px_shared_hash_join FALSE enable/disable shared hash join
_px_tq_memcpy_threshold 100 threshold for PQ TQ to use memcpy for packing columns
_qksfgi_dynamic_partitions enable partition bind SQLIDs for
_qksfgi_feature_level 0 controls the feature level for fine-grained cursor invalidation
_rac_propagate_last_rba TRUE Propagate last written log redo address in RAC for log mining
_read_only_slave_timeout 30 Time to wait on read only node when hub not available
_read_optimized_table_lookup TRUE enables read-optimized table lookup
_reader_farm_isolation_enable FALSE Reader Farm instances isolation enable
_reader_farm_isolation_time_threshold 200 reader farm isolation time threshold
_record_module_name TRUE Record module name in BEGIN action
_redo_log_key_reuse_count 0 Determines the number of redo logs sharing the same redo log key
_redo_write_sync_single_io TRUE enable sync I/O for single redo write
_ref_cons_sql_enforcement TRUE disable extended/data ref constraint SQL enforcement
_reg_cache_status FALSE Enables or disabled caching
_remessage_dbwrs 0 DBWR wait and remessage time - in cs
_request_boundaries 1 request boundaries mode
_restore_block0 on restore block0
_result_cache_per_pdb TRUE Is service result cache per pdb
_rm_exadata_partition_fc FALSE Partition flash cache for Exadata
_rm_exadata_pdb_cpu_cnt_mult 2 Multiplication factor for PDB cpu count
_rmv_dynamic_priority TRUE enable rmv priority modification
_root_clone_state_from_root TRUE Application Root Clone's state comes from Application Root
_sequence_scale_extend FALSE Force sequence creation with scale extend
_sequence_scale_noextend FALSE Force sequence creation with scale noextend
_shd_atomic_move 0 Use atomic move
_show_login_pdb_sessions FALSE return logon pdb container id from v$session
_simulate_dax_storage DISABLE Simulate log on DAX storage
_skip_pdb_recovery_if_keystore_not_open FALSE Skip PDB recovery when the PDB's keystore is not open
_skip_unconverted_change_vector FALSE Skip apply of a CV that has no endian conversion function
_slow_kill_on_pdb_close_immediate FALSE Kill sessions periodically on pdb close immediate
_sqlexec_cache_aware_hash_aggr_enabled TRUE enable/disable cache aware hash aggregation
_sqlexec_pwiseops_with_binds_enabled TRUE enable partition wise execution in the presence of bind variables in inlist equa
lity operator in where clause
_sqlexec_pwiseops_with_sqlfuncs_enabled TRUE enables partition wise operations even in the presence of functions over table p
artition keys
_sqlexec_reorder_wif_enabled TRUE enable re-ordering of window functions
_sqlexec_use_kgghash3 TRUE use CRC-based hash function
_standby_newkey_keystore_location Location of keystore on standby having new key
_uniq_cons_sql_enforcement TRUE disable extended data unique constraint SQL enforcement
_use_fallocate_for_mga FALSE MGA fallocate enabled
_use_hugetlbfs_for_SGA FALSE Enable HugeTLBFS usage for SGA
_use_large_pages_for_mga FALSE MGA largepage enabled
_verify_encrypted_tablespace_keys TRUE if TRUE, verify encryption key signature for data files
_wait_outlier_dump_flags 0 Wait Outlier Dump Flags
_wait_outlier_lambda_x1000 1500 Lambda (in thousands) to compute outliers
_wait_outlier_min_waits 10 Minimum waits required to enable wait outliers detection
_wait_outlier_num_outliers 600 Max number of outliers tracked
_xt_def_compression_ratio 4 Default compression ratio for external table data files
_xt_http_wscl FALSE Use KGWSCL for HTTP requests
_xt_legacy_debug_flags 0 Debug flags for ORACLE_LOADER and ORACLE_DATAPUMP
adg_account_info_tracking LOCAL ADG user account info tracked in standby(LOCAL) or in Primary(GLOBAL)
awr_pdb_max_parallel_slaves 10 maximum concurrent AWR PDB MMON slaves per instance
forward_listener forward listener
inmemory_automatic_level OFF Enable Automatic In-Memory management
inmemory_optimized_arithmetic DISABLE Controls whether or not DSBs are stored in-memory
inmemory_prefer_xmem_memcompress Prefer to store tables with given memcompress levels in xmem
inmemory_prefer_xmem_priority Prefer to store tables with given priority levels in xmem
inmemory_xmem_size 0 size in bytes of in-memory xmem area
memoptimize_pool_size 0 Size of cache for imoltp buffers
multishard_query_data_consistency strong consistency setting for multishard queries
multishard_query_partial_results not allowed enable partial results for multishard queries
optimizer_ignore_hints FALSE enables the embedded hints to be ignored
optimizer_ignore_parallel_hints FALSE enables embedded parallel hints to be ignored
parallel_min_degree 1 controls the minimum DOP computed by Auto DOP
pdb_template PDB template
private_temp_table_prefix ORA$PTT_ Private temporary table prefix
standby_pdb_source_file_dblink database link to standby source files
standby_pdb_source_file_directory standby source file directory location
tde_configuration Per-PDB configuration for Transparent Data Encryption
unified_audit_systemlog Syslog facility and level for Unified Audit
wallet_root wallet root instance initialization parameter
356 rows selected.
</m>
</n>
废弃的参数，在12.2 中存在，可是在 18.3 中已经被驱逐的废弃参数，数量是 43 个，参考如下列表：
KSPPINM -------------------------------------------------- _bloom_use_crchash _cdbperf_sweep_enabled _cdt_shared_memory_limit _cdt_shared_memory_query_percent _db_new_lost_write_protect _dbwr_nowrite_tracing_interval _dmm_blas_lib_enable _enable_umf_auto_tasks_pool _gc_cpu_time _gws_chunk_ver _hang_ignore_hngmtrc_count _hcs_no_column_info _imado_histogram_period _imcdt_use_mga _inmemory_ado_enabled _inmemory_batched_flush _inmemory_dynamic_scan_analyze_batch_size _inmemory_periodic_sort _inmemory_segment_populate_verify _kcl_max_reg_sz _key_vector_caching _kqr_allocate_directly_from_sga _kswsas_sim_jp_api _log_event_queues _optimizer_ignore_hints _post_wait_queues_dynamic_queues _px_reuse_server_group _segdict_analyzer_pct _segdict_chain_limit _segdict_check _segdict_chunk_minalloc _segdict_enable _segdict_enable_domaindict _segdict_max_gdsize _segdict_reprobe_limit _segdict_use_ndv _select_any_dictionary_security_enabled _set_mgd_recovery_state _wait_outlier_dlambda _wait_outlier_plambda _wait_outlier_report_minute_interval standby_archive_dest utl_file_dir 43 rows selected. 一点一滴，Oracle 数据库在发生大变化。
历史上的今天...
>> 2011-08-01 文章:
Dreamhost被墙牵连 Eygle.Com/Acoug.org 网站
>> 2007-08-01 文章:
万恶的东方航空公司续
>> 2006-08-01 文章:
Oracle10g的回收站(recyclebin)和自由空间管理
>> 2005-08-01 文章:
By eygle on 2018-08-01 19:20 |Comments (0) |Oracle12c/11g | 3295 |
以上就是本文的全部内容，希望本文的内容对大家的学习或者工作能带来一定的帮助，也希望大家多多支持 码农网
猜你喜欢:
本站部分资源来源于网络，本站转载出于传递更多信息之目的，版权归原作者或者来源机构所有，如转载稿涉及版权问题，请联系我们。
Building Websites with Joomla!
H Graf / Packt Publishing / 2006-01-20 / USD 44.99
This book is a fast paced tutorial to creating a website using Joomla!. If you've never used Joomla!, or even any web content management system before, then this book will walk you through each step i......一起来看看 《Building Websites with Joomla!》 这本书的介绍吧!
