【12c新特性】12cR1 diff 11gR2 Hidden Parameters
_ILM_FILTER_TIME | 0 | Upper filter time for ILM block compression |
_ILM_FILTER_TIME_LOWER | 0 | Lower filter time for ILM block compression |
_ILM_POLICY_NAME | FALSE | User specified ILM policy name |
__data_transfer_cache_size | 0 | Actual size of data transfer cache |
_abort_on_mrp_crash | FALSE | abort database instance when MRP crashes |
_ac_enable_dscn_in_rac | FALSE | Enable Dependent Commit SCN tracking |
_adaptive_scalable_log_writer_disable_worker_threshold | 90 | Percentage of overlap across multiple outstanding writes |
_adaptive_scalable_log_writer_enable_worker_threshold | 200 | Increase in redo generation rate as a percentage |
_adaptive_window_consolidator_enabled | TRUE | enable/disable adaptive window consolidator PX plan |
_add_nullable_column_with_default_optim | TRUE | Allows add of a nullable column with default optimization |
_adg_buffer_wait_timeout | 10 | Active Dataguard buffer wait time in cs |
_adg_instance_recovery | TRUE | enable ADG instance recovery |
_advanced_index_compression_options | 0 | advanced index compression options |
_advanced_index_compression_options_value | 20 | advanced index compression options2 |
_advanced_index_compression_trace | 0 | advanced index compression trace |
_allow_file_1_offline_error_1245 | FALSE | don’t signal ORA-1245 due to file 1 being offline |
_alter_common_user_schema | TRUE | allow local user to create objects in common schema |
_am_container_filesystem_ausize | 4194304 | allocation unit size for non-ASM containers |
_am_max_containers | 0 | maximum number of containers |
_am_max_groups | 0 | maximum number of containers |
_am_max_seg_bytes | 4000 | maximum number of bytes per array segment |
_am_timeouts_enabled | TRUE | enable timeouts |
_am_trace_buffer_size | 131072 | size of per-process I/O trace buffer |
_appqos_cdb_setting | 0 | QoSM CDB Performance Class Setting |
_appqos_po_multiplier | 1000 | Multiplier for PC performance objective value |
_aq_disable_x | FALSE | AQ – Disable new cross processes at an instance |
_aq_dq_sessions | 20 | Deq session count |
_aq_eq_sessions | 10 | Enq session count |
_aq_init_shards | 5 | Minimum enqueue shards per queue at an instance |
_aq_precrt_partitions | 0 | Precreate Partitions |
_aq_pt_processes | 1 | Partition background processes |
_aq_stop_backgrounds | FALSE | Stop all AQ background processes |
_aq_subshard_Size | 2000 | Sub Shard Size |
_aqsharded_cache_limit | 0 | Limit for cached enqueue/dequeue operations |
_array_cdb_view_enabled | TRUE | array mode enabled for CDB views |
_asm_access | auto | ASM File access mechanism |
_asm_allow_unsafe_reconnect | TRUE | attempt unsafe reconnect to ASM |
_asm_allowdegeneratemounts | TRUE | Allow force-mounts of DGs w/o proper quorum |
_asm_dba_spcchk_thld | 20000 | ASM Disk Based Allocation Space Check Threshold |
_asm_disable_ufg_dump | FALSE | disable terminated umbilicus diagnostic |
_asm_disable_ufgmemberkill | FALSE | disable ufg member kill |
_asm_diskerr_traces | 2 | Number of read/write errors per disk a process can trace |
_asm_diskgroups2 | disk groups to mount automatically set 2 | |
_asm_diskgroups3 | disk groups to mount automatically set 3 | |
_asm_diskgroups4 | disk groups to mount automatically set 4 | |
_asm_enable_xrov | FALSE | Enable XROV capability |
_asm_global_dump_level | 267 | System state dump level for ASM asserts |
_asm_healthcheck_timeout | 180 | seconds until health check takes action |
_asm_network_timeout | 1 | Keepalive timeout for ASM network connections |
_asm_networks | ASM network subnet addresses | |
_asm_nodekill_escalate_time | 180 | secs until escalating to nodekill if fence incomplete |
_asm_noevenread_diskgroups | List of disk groups having even read disabled | |
_asm_procs_trace_diskerr | 5 | Number of processes allowed to trace a disk failure |
_asm_proxy_startwait | 60 | Maximum time to wait for ASM proxy connection |
_asm_remote_client_timeout | 300 | timeout before killing disconnected remote clients |
_asm_resyncCkpt | 1024 | number of extents to resync before flushing checkpoint |
_asm_scrub_limit | AUTO | ASM disk scrubbing power |
_asm_skip_diskval_check | FALSE | skip client side discovery for disk revalidate |
_asm_trace_limit_timeout | 30000 | Time-out in milliseconds to reset the number of traces per disk and the number of processes allowed to trace |
_autotask_test_name | N/A | Name of current Autotask Test (or test step) |
_aux_dfc_keep_time | 1440 | auxiliary datafile copy keep time in minutes |
_awr_cdbperf_threshold | 21 | Setting for AWR CDBPERF Threshold |
_awr_mmon_deep_purge_all_expired | FALSE | Allows deep purge to purge AWR data for all expired snapshots |
_awr_pdb_registration_enabled | FALSE | Parameter to enable/disable AWR PDB Registration |
_awr_remote_target_dblink | AWR Remote Target DBLink for Flushing | |
_backup_ksfq_bufmem_max | 2.68E+08 | maximum amount of memory (in bytes) used for buffers for backup/restore |
_backup_min_ct_unused_optim | 2097152 | mimimun size in bytes of change tracking to apply unused space optimuzation |
_bct_mrp_timeout | 600 | CTWR MRP wait timeout (seconds), zero to wait forever |
_bct_public_dba_buffer_dynresize | 2 | allow dynamic resizing of public dba buffers, zero to disable |
_bct_public_dba_buffer_maxsize | 0 | max buffer size permitted for public dba buffers, in bytes |
_bg_spawn_diag_opts | 0 | background processes spawn diagnostic options |
_block_level_offload_high_lat_thresh | 40000 | High Latency Threshold for Block Level Offload operations |
_bloom_filter_size | 0 | bloom filter vector size (in KB) |
_bloom_predicate_offload | TRUE | enables or disables bloom filter predicate offload to cells |
_bloom_rm_filter | FALSE | remove bloom predicate in favor of zonemap join pruning predicate |
_bloom_sm_enabled | FALSE | enable bloom filter optimization using slave mapping |
_broadcast_scn_mode | 1 | broadcast-on-commit scn mode |
_cache_orl_during_open | ALL | cache online logs |
_cdb_compatible | TRUE | CDB Compatible |
_cdb_rac_affinity | TRUE | rac affinity for parallel cdb operations |
_cell_materialize_all_expressions | FALSE | Force materialization of all offloadable expressions on the cells |
_cell_materialize_virtual_columns | TRUE | enable offload of expressions underlying virtual columns to cells |
_cell_object_expiration_hours | 24 | flashcache object expiration timeout |
_cell_offload_complex_processing | TRUE | enable complex SQL processing offload to cells |
_cell_offload_expressions | TRUE | enable offload of expressions to cells |
_cell_offload_sys_context | TRUE | enable offload of SYS_CONTEXT evaluation to cells |
_cgs_comm_readiness_check | 1 | CGS communication readiness check |
_cgs_memberkill_from_rim_instance | FALSE | allow a RIM instance to issue a CSS member kill |
_cgs_msg_batch_size | 4096 | CGS message batch size in bytes |
_cgs_msg_batching | TRUE | CGS message batching |
_cgs_ticket_sendback | 50 | CGS ticket active sendback percentage threshold |
_check_pdbid_in_redo | FALSE | Enable checking of pluggable database ID in redo |
_cleanout_shrcur_buffers | TRUE | if TRUE, cleanout shrcur buffers |
_cli_cachebktalloc | 100 | Percentage of memory to allocate |
_client_enable_auto_unregister | FALSE | enable automatic unregister after a send fails with timeout |
_clone_one_pdb_recovery | FALSE | Recover ROOT and only one PDB in clone database |
_cloud_name | gsm cloud name | |
_collect_tempundo_stats | TRUE | Collect Statistics v$tempundostat |
_common_data_view_enabled | TRUE | common objects returned through dictionary views |
_common_user_prefix | C## | Enforce restriction on a prefix of a Common User/Role/Profile name |
_concurrency_chosen | 10 | what is the chosen value of concurrency |
_controlfile_cell_flash_caching | 3 | Flash cache hint for control file accesses |
_cpu_eff_thread_multiplier | CPU effective thread multiplier | |
_crash_domain_on_exception | 0 | allow domain to exit for exceptions in any thread |
_create_stat_segment | 0 | create ilm statistics segment |
_ctx_doc_policy_stems | FALSE | enable ctx_doc.policy_stems api |
_cu_row_locking | 0 | CU row level locking |
_cursor_reload_failure_threshold | 0 | Number of failed reloads before marking cursor unusable |
_cvmap_buffers | 5000 | Number of change vector buffers for multi instance media recovery |
_data_transfer_cache_bc_perc_x100 | 500 | Percentange * 100 of buffer cache to transfer to data transfer cache |
_data_transfer_cache_size | 0 | Size of data transfer cache |
_data_warehousing_scan_buffers | TRUE | if TRUE, enable data warehousing scan buffers |
_datapump_compressbas_buffer_size | 0 | specifies buffer size for BASIC compression algorithm |
_datapump_metadata_buffer_size | 131072 | specifies buffer size for metadata file I/O |
_datapump_tabledata_buffer_size | 262144 | specifies buffer size for table data file I/O |
_db_block_cache_history_lru | FALSE | buffer header tracing for lru operations |
_db_block_prefetch_wasted_threshold_perc | 2 | Allowed wasted percent threshold of prefetched size |
_db_dump_from_disk_and_efc | 0 | dump contents from disk and efc |
_db_dw_scan_adaptive_cooling | FALSE | if TRUE, enable adaptive DW scan cooling |
_db_dw_scan_max_shadow_count | 5 | DW Scan adaptive cooling max shadow count |
_db_dw_scan_obj_cooling_factor | 500 | DW Scan object cooling factor to cool all temperatures |
_db_dw_scan_obj_cooling_interval | 100 | DW Scan object cooling interval in number of scans, seconds, or pct of cache size |
_db_dw_scan_obj_cooling_policy | CACHE_SIZE | DW scan objtect cooling policy |
_db_dw_scan_obj_warming_increment | 1000 | DW Scan object warming increment when an object is scanned |
_db_flash_cache_max_latency | 400 | Flash cache maximum latency allowed in 10 milliseconds |
_db_flash_cache_max_outstanding_writes | 32 | Flash cache maximum outstanding writes allowed |
_db_flash_cache_max_read_retry | 3 | Flash cache max read retry |
_db_flash_cache_max_slow_io | 3 | Flash cache maximum slow io allowed |
_db_num_gsm | 0 | database number in gsm dbpool |
_dbfs_modify_implicit_fetch | TRUE | DBFS Link allows implicit fetch on modify – only on SecureFiles |
_dbg_scan | 0 | generic scan debug |
_dbop_enabled | 1 | Any positive number enables automatic DBOP monitoring. 0 is disabled |
_dbpool_name | gsm database pool name | |
_dd_validate_remote_locks | TRUE | GES deadlock detection validate remote locks |
_deadlock_record_to_alert_log | TRUE | record resolved deadlocks to the alert log |
_defer_sga_alloc_chunk_size | 1.07E+09 | Chunk size for defer sga allocation |
_defer_sga_enabled | FALSE | Enable deferred shared memory allocation for SGA |
_defer_sga_min_spsz_at_startup | 5.37E+10 | Minimum shared pool size at startup with deferred sga enabled |
_defer_sga_min_total_defer_segs_sz | 1.07E+11 | Minimum total deferred segs size for defer sga allocation |
_defer_sga_test_alloc_intv | 0 | SA** sleeps for N secs before allocating a deferred segment |
_deferred_seg_in_seed | TRUE | Enable Deferred Segment Creation in Seed |
_diag_test_seg_reinc_mode | FALSE | Sets trace segmentation to be in reincarnation mode |
_diag_xm_enabled | FALSE | If TRUE, DIAG allows message exchanges across DB/ASM boundary |
_disable_12cbigfile | FALSE | DIsable Storing ILM Statistics in 12cBigFiles |
_disable_directory_link_check | FALSE | Disable directory link checking |
_disable_flashback_recyclebin_opt | TRUE | Don’t use the Flashback Recyclebin optimization |
_disable_rolling_patch | 0 | Disable Rolling Patch Feature |
_dm_dmf_details_compatibility | 12.1.0 | set dm dmf details compatibility version |
_dm_enable_legacy_dmf_output_types | FALSE | revert dmf output types to pre-12.1.0.1 |
_dnfs_rdma_enable | 1 | Enable dNFS RDMA transfers |
_dnfs_rdma_max | 1048576 | Maximum size of dNFS RDMA transfer |
_dnfs_rdma_min | 8192 | Minimum size of dNFS RDMA transfer |
_drop_stat_segment | 0 | drop ilm statistics segment |
_dump_10261_level | 0 | Dump level for event 10261, 1=>minimal dump 2=>top pga dump |
_dump_scn_increment_stack | Dumps scn increment stack per session | |
_emon_pool_inc | 1 | increment in EMON slaves per pool type |
_emon_pool_max | 10 | maximum number of EMON slaves per pool type |
_emon_pool_min | 1 | minimum number of EMON slaves per pool type |
_emon_send_timeout | 10000 | send timeout after which the client is unregistered |
_emx_control | 0 | EM Express control (internal use only) |
_emx_max_sessions | 128 | Maximum number of sessions in the EM Express cache |
_emx_session_timeout | 3600 | Session timeout (sec) in the EM Express cache |
_enable_12g_bft | TRUE | enable 12g bigfile tablespace |
_enable_columnar_cache | 0 | Enable Columnar Flash Cache Rewrite |
_enable_heatmap_internal | FALSE | heatmap related – to be used by oracle dev only |
_enable_iee_stats | TRUE | enables IEE stats gathering |
_enable_ilm_flush_stats | TRUE | Enable ILM Stats Flush |
_enable_ilm_testflush_stats | FALSE | Enable Test ILM Stats Flush |
_enable_offloaded_writes | FALSE | Enable offloaded writes for Unit Test |
_enable_pluggable_database | FALSE | Enable Pluggable Database |
_enable_securefile_flashback_opt | FALSE | Enable securefile flashback optimization |
_enqueue_deadlock_detect_all_global_locks | FALSE | enable deadlock detection on all global enqueues |
_enqueue_sync_retry_attempts | 3 | max number of times the bg process to retry synchronous enqueue open if it failed because master could not allocate memory |
_enqueue_sync_sim_mem_error | FALSE | simulate master instance running out of memory when synchronously getting a remotely mastered enqueue |
_external_scn_logging_threshold_seconds | 86400 | High delta SCN threshold in seconds |
_external_scn_rejection_delta_threshold_minutes | 0 | external SCN rejection delta threshold in minutes |
_external_scn_rejection_threshold_hours | 24 | Lag in hours between max allowed SCN and an external SCN |
_fast_index_maintenance | TRUE | fast global index maintenance during PMOPs |
_fast_psby_conversion | TRUE | Enable fast physical standby conversion |
_flush_ilm_stats | 0 | flush ilm stats |
_force_logging_in_upgrade | TRUE | force logging during upgrade mode |
_force_sys_compress | TRUE | Sys compress |
_full_diag_on_rim | FALSE | rim nodes have full DIA* function |
_gc_affinity_acquire_time | TRUE | if TRUE, save the time we acquired an affinity lock |
_gc_async_send | FALSE | send blocks asynchronously |
_gc_fg_spin_time | 0 | foreground msgq spin time |
_gc_object_queue_max_length | 0 | maximum length for an object queue |
_gc_save_cleanout | TRUE | if TRUE, save cleanout to apply later |
_gc_split_flush | FALSE | if TRUE, flush index split redo before rejecting bast |
_gc_temp_affinity | FALSE | if TRUE, enable global temporary affinity |
_gcr_cpu_min_free | 10 | minimum amount of free CPU to flag an anomaly |
_gcr_enable_high_memory_kill | FALSE | if TRUE, GCR may kill foregrounds under high memory load |
_gcr_enable_new_drm_check | FALSE | if FALSE, revert to old drm load metric |
_gcr_enable_statistical_cpu_check | TRUE | if FALSE, revert to old cpu load metric |
_gcr_high_memory_threshold | 10 | minimum amount of Memory process must consume to be kill target |
_gcr_max_rt_procs | maximum number of RT DLM processes allowed by GCR | |
_gcr_mem_min_free | 10 | minimum amount of free memory to flag an anomaly |
_gcs_disable_switch_role_with_writer | TRUE | if TRUE, disable switching to local role with a writer |
_gcs_min_slaves | 0 | if non zero, it enables the minimum number of gcs slaves |
_gcs_res_hash_buckets | number of gcs resource hash buckets to be allocated | |
_gcs_reserved_resources | 400 | allocate the number of reserved resources in reconfiguration |
_gcs_reserved_shadows | 400 | allocate the number of reserved shadows in reconfiguration |
_ges_default_lmds | * | default lmds for enqueue hashing |
_ges_direct_free | FALSE | if TRUE, free each resource directly to the freelist |
_ges_direct_free_res_type | CT | string of resource types(s) to directly free to the freelist |
_ges_dump_open_locks | FALSE | if TRUE, dump open locks for the LCK process during shutdown |
_ges_fggl | TRUE | DLM fg grant lock on/off |
_ges_freeable_res_chunk_free | FALSE | if TRUE, free dynamic resource chunks which are freeable |
_ges_freeable_res_chunk_free_interval | 180 | time interval for freeing freeable dynamic resource chunks |
_ges_gather_res_reuse_stats | FALSE | if TRUE, gather resource reuse statistics |
_ges_hash_groups | * | enqueue hash table groups |
_ges_lmd_mapping | * | enqueue to lmd mapping |
_ges_nres_divide | 0 | how to divide number of enqueue resources among hash tables |
_ges_resource_memory_opt | 4 | enable different level of ges res memory optimization |
_ges_server_processes | 1 | number of background global enqueue server processes |
_grant_secure_role | FALSE | Disallow granting of SR to NSR |
_gsm | GSM descriptions | |
_gsm_config_vers | 0 | version of gsm config |
_gsm_cpu_thresh | 75 | CPU busy threshold |
_gsm_drv_interval | 30 | metric derived values interval |
_gsm_max_instances_per_db | 8 | maximum number of instances per database in gsm cloud |
_gsm_max_num_regions | 10 | maximum number of regions in gsm cloud |
_gsm_region_list | List of GSM Regions | |
_gsm_srlat_thresh | 20 | Single block read latency threshold |
_gsm_thresh_respct | 50 | threshold resource percentage |
_gsm_thresh_zone | 10 | threshold zone |
_gwm_spare1 | gsm spare 1 | |
_gwm_spare2 | 0 | gsm spare 2 |
_gwm_spare3 | 0 | gsm spare 3 |
_hang_base_file_count | 5 | Number of trace files for the normal base trace file |
_hang_base_file_space_limit | 20000000 | File space limit for current normal base trace file |
_hang_bool_spare1 | TRUE | Hang Management 1 |
_hang_cross_boundary_hang_detection_enabled | TRUE | Hang Management Cross Boundary detection |
_hang_delay_resolution_for_libcache | TRUE | Hang Management delays hang resolution for library cache |
_hang_hang_analyze_output_hang_chains | TRUE | if TRUE hang manager outputs hang analysis hang chains |
_hang_int_spare2 | FALSE | Hang Management 2 |
_hang_log_verified_hangs_to_alert | FALSE | Hang Management log verified hangs to alert log |
_hang_lws_file_space_limit | 20000000 | File space limit for current long waiting session trace file |
_hang_monitor_archiving_related_hang_interval | 300 | Time in seconds ignored hangs must persist after verification |
_hang_resolution_allow_archiving_issue_termination | TRUE | Hang Management hang resolution allow archiving issue termination |
_hang_terminate_session_replay_enabled | FALSE | Hang Management terminates sessions allowing replay |
_hashops_prefetch_size | 4 | maximum no of rows whose relevant memory locations are prefetched |
_heatmap_format_1block | FALSE | heatmap related – to be used by oracle dev only |
_heatmap_min_maxsize | 0 | Internal testing only |
_hm_xm_enabled | TRUE | If TRUE, DIA0 allows message exchanges across DB/ASM boundary |
_ilm_mem_limit | 10 | percentage of the max shared pool heat-map can use – internal |
_ilmflush_stat_limit | 0 | ILM flush statistics limit – Internal testing only |
_ilmset_stat_limit | 0 | ILM set statistics limit – Internal testing only |
_ilmstat_memlimit | 10 | Percentage of shared pool for use by ILM Statistics |
_image_redo_gen_delay | 0 | Image redo generation delay in centi-seconds (direct write mode) |
_imr_rr_holder_kill_time | 300 | IMR max time instance is allowed to hold RR lock in seconds |
_index_load_buf_oltp_sacrifice_pct | 10 | index load buf oltp sacrifice pct |
_index_load_buf_oltp_under_pct | 85 | index load buf and comp oltp under-estimation pct |
_index_max_inc_trans_pct | 20 | max itl expand percentage soft limit during index insert |
_io_internal_test | 0 | I/O internal testing parameter |
_io_osd_param | 1 | OSD specific parameter |
_io_outlier_threshold | 500 | Latency threshold for io_outlier table |
_ka_allow_reenable | FALSE | reenability of kernel accelerator service after disable |
_ka_compatibility_requirement | all | kernel accelerator compatibility operation requirement |
_ka_doorbell | 0 | kernel accelerator doorbell mode |
_ka_locks_per_sector | 4 | locks per sector in kernel accelerator |
_ka_mode | 0 | kernel accelerator mode |
_ka_msg_reap_count | 40 | maximum number of KA messages to receive and process per wait |
_ka_pbatch_messages | TRUE | kernel accelerator perform pbatch messages |
_kcfis_automem_level | 1 | Set auto memory management control for kcfis memory allocation |
_kcfis_cell_passthru_dataonly | TRUE | Allow dataonly passthru for smart scan |
_kcfis_celloflsrv_passthru_enabled | FALSE | Enable offload server usage for passthru operations |
_kcfis_celloflsrv_usage_enabled | TRUE | Enable offload server usage for offload operations |
_kcfis_qm_prioritize_sys_plan | TRUE | Prioritize Quaranitine Manager system plan |
_kcfis_qm_user_plan_name | Quaranitine Manager user plan name | |
_kdizoltp_uncompsentinal_freq | 16 | kdizoltp uncomp sentinal frequency |
_kdlf_read_flag | 0 | kdlf read flag |
_kdli_descn_adj | FALSE | coalesce extents with deallocation scn adjustment |
_kdli_mts_so | TRUE | use state objects in shared server for asyncIO pipelines |
_kdli_ralc_length | 10485760 | lob length threshold to trigger rounded allocations |
_kdli_ralc_rounding | 1048576 | rounding granularity for rounded allocations |
_kdz_pred_nrows | 32767 | Number of rows to predicate at a time in kdzt |
_kdz_proj_nrows | 1024 | Number of rows to project at a time in kdzt |
_kecap_cache_size | 10240 | Workload Replay INTERNAL parameter used to set memory usage in Application Replay |
_kffmlk_hash_size | 512 | size of kffmlk_hash table |
_kffmop_chunks | 42 | number of chunks of kffmop’s |
_kgl_cap_hd_alo_stacks | FALSE | capture stacks for library cache handle allocation |
_kjac_force_outcome_current_session | FALSE | if TRUE, enable to run force outcome on the current session |
_kjdd_call_stack_dump_enabled | FALSE | Enables printing of short call stack with the WFG |
_kjdd_wfg_dump_cntrl | 0 | To control the way Wait-For_Graph is dumped |
_kjltmaxgt | 1000 | record latch requests that takes longer than this many us |
_kjltmaxht | 1000 | record latch reqeust that are held longer than this many us |
_kjlton | FALSE | track DLM latch usage on/off |
_kqdsn_max_instance_bits | 8 | maximum bits used for instance value in sequence partition |
_kqdsn_min_instance_bits | 0 | minimum bits used for instance value in sequence partition |
_kqdsn_partition_ratio | 30 | ratio of instance to session bits in sequence partition |
_kqr_optimistic_reads | FALSE | optimistic reading of row cache objects |
_ksipc_libipc_path | over-ride default location of libipc | |
_ksipc_mode | 0 | ksipc mode |
_ksipc_spare_param1 | 0 | ksipc spare param 1 |
_ksipc_spare_param2 | ksipc spare param 2 | |
_ksipc_wait_flags | 0 | tune ksipcwait |
_ksmlsaf | 0 | KSM log alloc and free |
_ksv_slave_exit_timeout | 120 | slave exit timeout |
_ksxp_skgxp_ant_options | SKGXP ANT options | |
_ksxp_skgxp_inets | limit SKGXP networks | |
_ktilmsc_exp | 600 | expiration time of ktilm segment cache (in second) |
_ktspsrch_scchk | 60 | cleanout check time of space search cache |
_ktspsrch_scexp | 60 | expiration time of space search cache |
_ktst_rss_max | 1000 | maximum temp extents to be released across instance |
_ktst_rss_min | 100 | minimum temp extents to be released across instance |
_ktst_rss_retry | 2 | maximum retries of sort segment release |
_kxdbio_ctx_init_count | 32 | initial count of KXDBIO state object |
_kxdbio_disable_offload_opcode | 0 | KXDBIO Disable offload for the set opcodes. Value is a Bitmap of 0x00000001 – disable cell to cell data copy offload 0x00000002 – disable disk scrubbing offload to cell 0x00000004 – disable offloaded writes to cell |
_kxdbio_enable_ds_opcode | 0 | KXDBIO Enable Dumb storage simulation for the set opcodes. |
_kxdbio_hca_loadavg_thresh | 98 | HCA loadavg threshold at which writes need to get offloaded |
_kxdbio_ut_ctl | 0 | kxdbio unit test controls |
_latch_wait_list_pri_sleep_secs | 1 | Time to sleep on latch wait list until getting priority |
_ldr_tempseg_threshold | 8388608 | amount to buffer prior to allocating temp segment (extent sizing) |
_lgwr_io_outlier | 0 | LGWR I/O outlier frequency |
_lm_big_cluster_optimizations | FALSE | enable certain big cluster optimizations in drm |
_lm_comm_channel | ksxp | GES communication channel type |
_lm_comm_msgq_busywait | 10 | busy wait time in microsecond for msgq |
_lm_comm_reap_count | 1 | message reap count for receive |
_lm_comm_tkts_add_factor | 10 | Ticket allocation addition factor |
_lm_comm_tkts_calc_period_length | 5 | Weighted average calculation interval length (second) |
_lm_comm_tkts_max_periods | 10 | Max number of periods used in weighted avearage calculation |
_lm_comm_tkts_min_decrease_wait | 120 | Time to wait before allowing an allocation decrease |
_lm_comm_tkts_min_increase_wait | 25 | Time to wait before allowing an allocation increase |
_lm_comm_tkts_mult_factor | 200 | Ticket allocation multiplication factor |
_lm_comm_tkts_nullreq_threshold | 25 | Null request frequency threshold (percentage) |
_lm_drmopt12 | 8 | enable drm scan optimizations in 12 |
_lm_drmopt12_nolatch | TRUE | enable drm latching optimizations in 12 |
_lm_enqueue_blocker_dump_timeout_cnt | 30 | enqueue blocker dump timeout count |
_lm_fdrm_stats | FALSE | gather full drm statistics |
_lm_hashtable_bkt_high | 5 | High element threshold in hash table bucket |
_lm_hashtable_bkt_low | 3 | Low element threshold in hash table bucket |
_lm_hashtable_bkt_thr | 70 | Threshold for hash table resizing |
_lm_hb_acceptable_hang_condition | default | list of acceptable hang conditions in heartbeat check |
_lm_hb_enable_acl_check | TRUE | to enable the wait analysis with acceptable condition lists |
_lm_hb_exponential_hang_time_factor | 2 | heartbeat exponential hang time multiplier |
_lm_hb_maximum_hang_report_count | 20 | maximum heartbeat hang report count |
_lm_idle_connection_kill_max_skips | 1 | GES idle connection max skip kill request |
_lm_idle_connection_max_ignore_kill_count | 2 | GES maximum idle connection kill request ignore count |
_lm_idle_connection_quorum_threshold | 50 | GES idle connection health quorum threshold |
_lm_lms_opt_priority | TRUE | enable freeslot lms priority optimization |
_lm_lms_priority_check_frequency | 60000 | frequency of LMS priority decisions in milliseconds |
_lm_msg_pool_dump_threshold | 20000 | GES message pool dump threshold in terms of buffer count |
_lm_num_bnft_stats_buckets | 1 | number of buckets in the benefit stats hash table |
_lm_process_lock_q_scan_limit | 100 | limit on scanning process lock queue instead of resource convert lock queue |
_lm_res_tm_hash_bucket | 0 | number of extra TM resource hash buckets |
_lm_resend_open_convert_timeout | 30 | timeout in secs before resubmitting the open-convert |
_lm_rm_slaves | 1 | if non zero, it enables remastering slaves |
_lm_wait_pending_send_queue | TRUE | GES wait on pending send queue |
_lock_ref_constraint_count | 50 | number of nowait attempts to lock referential constraint |
_log_undo_df_info | FALSE | generate marker to log file# that belong to undo tablespace |
_log_write_info_size | 4096 | Size of log write info array |
_log_writer_worker_dlm_hearbeat_update_freq | 5000 | LGWR worker DLM health-monitoring heartbeat update frequency (ms) |
_lthread_cleanup_intv_secs | 5 | interval for cleaning lightweight threads in secs |
_lthread_clnup_hk_wait_secs | 3 | timeout after hard killing operation for lthread to exit |
_lthread_clnup_pmon_softkill_wait_secs | 1 | wait timeout for PMON between soft kill and hard kill of lthreads |
_lthread_clnup_spawner_sk_wait_secs | 30 | timeout for spawner between soft kill and hard kill of lthreads |
_lthread_debug | FALSE | Enable Debugging mode for lightweight threads |
_lthread_enabled | TRUE | Enable lightweight threads |
_lthread_max_spawn_time_csecs | 12000 | maximum time interval a spawner will wait for a lthread to get ready |
_lthread_spawn_check_intv_ms | 10 | time interval for a spawner to check for spawnee to get ready |
_lthread_step_debugging | FALSE | Enable Step wise Debugging mode for lightweight threads |
_max_clients_per_emon | 256 | maximum number of clients per emon |
_max_data_transfer_cache_size | 5.37E+08 | Maximum size of data transfer cache |
_max_defer_gran_xfer_atonce | 10 | Maximum deferred granules transferred by MMAN atonce |
_max_incident_file_size | Maximum size (in KB, MB, GB, Blocks) of incident dump file | |
_max_kcnibr_ranges | 1048576 | Max number of nonlogged data block ranges |
_max_log_write_io_parallelism | 1 | Maximum I/O parallelism within a log write (auto=0) |
_max_log_write_parallelism | 1 | Maximum parallelism within a log write (auto=0) |
_max_outstanding_log_writes | 2 | Maximum number of outstanding redo log writes |
_max_queued_report_requests | 300 | Maximum number of report requests that can be queued in a list |
_max_report_flushes_percycle | 5 | Max no of report requests that can be flushed per cycle |
_max_string_size_bypass | 0 | controls error checking for the max_string_size parameter |
_max_sys_next_extent | 0 | Dictionary managed SYSTEM tablespace maximum next extent size in MB (allowed range [16-4095], 0 if unlimited) |
_memory_max_tgt_inc_cnt | 0 | counts the times checker increments memory target |
_midtier_affinity_cluswait_prc_threshold | 6 | cluster wait precentage threshold to enter affinity |
_min_time_between_psp0_diag_secs | 300 | minimum time between PSP0 diagnostic used for flow control |
_modify_column_index_unusable | FALSE | allow ALTER TABLE MODIFY(column) to violate index key length limit |
_mpmt_enabled_backgrounds | * | mpmt enabled backgrounds |
_mpmt_fg_enabled | FALSE | MPMT mode foreground enabled |
_mpmt_procs_per_osp | 100 | max procs per osp |
_multi_transaction_optimization_enabled | TRUE | reduce SGA memory use during create of a partitioned table |
_mv_add_log_placeholder | TRUE | add log placeholder |
_mv_cleanup_orphaned_metadata | TRUE | cleanup orphaned materialized view metadata |
_mv_complete_refresh_conventional | FALSE | use conventional INSERTs for MV complete refresh |
_mv_deferred_no_log_age_val | TRUE | avoid build deferred MV log age validate |
_mv_expression_extend_size | 4096 | MV expression extend size |
_mv_refresh_insert_no_append | TRUE | materialized view refresh using insert no append |
_nameservice_consistency_check | TRUE | NameService Consistency check switch |
_net_timeout_latency | 0 | NET_TIMEOUT latency |
_no_small_file | FALSE | Not to apply new extent scheme for small file temp spaces |
_no_stale_joinback_rewrite | FALSE | No joinbacks if mv is stale |
_nologging_kcnbuf_hash_buckets | 1024 | Number of nologging buffer hash buckets |
_nologging_kcnbuf_hash_latches | 256 | Number of nologging buffer hash latches |
_nologging_load_slotsz | 1048576 | Nologging standby: direct load buffer size |
_nologging_sdcl_append_wait | 100 | Nologging standby append sdcl wait time |
_nologging_sendbuf_ratio | 99 | Nologging standby: outstanding send buffer ratio |
_nologging_txn_cmt_wait | 1500 | Nologging standby transaction commit wait time |
_noncdb_to_pdb | FALSE | converting a non-cdb to a pdb |
_numa_shift_enabled | TRUE | Enable NUMA shift |
_numa_shift_value | 0 | user defined value for numa nodes shift |
_number_group_memberships_per_cache_line | 3 | maximum number of group memberships per cache line |
_odci_aggregate_save_space | FALSE | trade speed for space in user-defined aggregation |
_olap_row_load_time_precision | DEFAULT | OLAP Row Load Time Precision |
_old_extent_scheme | FALSE | Revert to old extent allocation |
_oltp_comp_dbg_scan | 0 | oltp compression scan debug |
_oltp_spill | FALSE | spill rows for oltp compression if loader pga limit is exceeded |
_omni_enqueue_enable | 1 | Enable Omni Enqueue feature (0 = disable, 1 = enable on ASM (default), 2 = enable) |
_online_ctas_diag | 0 | controls dumping diagnostic information for online ctas |
_optimizer_adaptive_plan_control | 0 | internal controls for adaptive plans |
_optimizer_adaptive_plans | TRUE | enable adaptive plans |
_optimizer_ads_max_table_count | 0 | maximum number of tables in a join under ADS |
_optimizer_ads_time_limit | 0 | maximum time limit (seconds) under ADS |
_optimizer_ads_use_result_cache | TRUE | use result cache for ADS queries |
_optimizer_ansi_join_lateral_enhance | TRUE | optimization of left/full ansi-joins and lateral views |
_optimizer_ansi_rearchitecture | TRUE | re-architecture of ANSI left, right, and full outer joins |
_optimizer_batch_table_access_by_rowid | TRUE | enable table access by ROWID IO batching |
_optimizer_cluster_by_rowid | TRUE | enable/disable the cluster by rowid feature |
_optimizer_cluster_by_rowid_control | 3 | internal control for cluster by rowid feature mode |
_optimizer_cube_join_enabled | TRUE | enable cube join |
_optimizer_dsdir_usage_control | 126 | controls optimizer usage of dynamic sampling directives |
_optimizer_gather_feedback | TRUE | optimizer gather feedback |
_optimizer_gather_stats_on_load | TRUE | enable/disable online statistics gathering |
_optimizer_generate_transitive_pred | TRUE | optimizer generate transitive predicates |
_optimizer_hybrid_fpwj_enabled | TRUE | enable hybrid full partition-wise join when TRUE |
_optimizer_multi_table_outerjoin | TRUE | allows multiple tables on the left of outerjoin |
_optimizer_null_accepting_semijoin | TRUE | enables null-accepting semijoin |
_optimizer_partial_join_eval | TRUE | partial join evaluation parameter |
_optimizer_performance_feedback | OFF | controls the performance feedback |
_optimizer_proc_rate_level | BASIC | control the level of processing rates |
_optimizer_proc_rate_source | DEFAULT | control the source of processing rates |
_optimizer_strans_adaptive_pruning | TRUE | allow adaptive pruning of star transformation bitmap trees |
_optimizer_unnest_scalar_sq | TRUE | enables unnesting of of scalar subquery |
_optimizer_use_gtt_session_stats | TRUE | use GTT session private statistics |
_optimizer_use_histograms | TRUE | enable/disable the usage of histograms by the optimizer |
_oracle_script | FALSE | Running an Oracle-supplied script |
_parallel_blackbox_sga | TRUE | true if blackbox will be allocated in SGA, false if PGA |
_parallel_ctas_enabled | TRUE | enable/disable parallel CTAS operation |
_parallel_fault_tolerance_threshold | 3 | total number of faults fault-tolerance will handle |
_part_access_version_by_number | TRUE | use version numbers to access versioned objects for partitioning |
_part_redef_global_index_update | TRUE | online partition redefinition update global indexes |
_partition_advisor_srs_active | TRUE | enables sampling based partitioning validation |
_partition_cdb_view_enabled | TRUE | partitioned cdb view evaluation enabled |
_pdb_use_sequence_cache | TRUE | Use sequence cache in PDB mode |
_pga_limit_check_wait_time | 1000000 | microseconds to wait for over limit confirmation |
_pga_limit_dump_summary | FALSE | dump PGA summary when signalling ORA-4036 |
_pga_limit_interrupt_smaller | FALSE | whether to interrupt smaller eligible processes |
_pga_limit_min_req_size | 4194304 | bytes of PGA usage below which process will not get ORA-4036 |
_pga_limit_simulated_physmem_size | 0 | bytes of physical memory to determine pga_aggregate_limit with |
_pga_limit_target_perc | 200 | default percent of pga_aggregate_target for pga_aggregate_limit |
_pga_limit_time_to_interrupt | 2 | seconds to wait until direct interrupt |
_pga_limit_time_until_idle | 15 | seconds to wait before treating process as idle |
_pga_limit_time_until_killed | 30 | seconds to wait before killing session over limit |
_pga_limit_tracing | 0 | trace pga_aggregate_limit activity |
_pga_limit_use_immediate_kill | TRUE | use immediate kill for sessions over limit |
_pga_limit_watch_perc | 50 | percentage of limit to have processes watch |
_pga_limit_watch_size | 1.05E+08 | bytes of PGA usage at which process will begin watching limit |
_pin_time_statistics | FALSE | if TRUE collect statistics for how long a current pin is held |
_ping_wait_for_log_force | TRUE | Wait for log force before block ping |
_pluggable_database_debug | 0 | Debug flag for pluggable database related operations |
_pred_push_cdb_view_enabled | TRUE | predicate pushdown enabled for CDB views |
_prefered_standby | standby db_unique_name prefered for krb operations | |
_print_inmem_heatmap | 0 | print inmem ilm heatmap |
_print_stat_segment | 0 | print ilm statistics segment |
_px_adaptive_dist_method | CHOOSE | determines the behavior of adaptive distribution methods |
_px_adaptive_dist_method_threshold | 0 | Buffering / decision threshold for adaptive distribution methods |
_px_adaptive_offload_percentage | 30 | percentage for PQ adaptive offloading of granules |
_px_back_to_parallel | OFF | allow going back to parallel after a serial operation |
_px_cdb_view_enabled | TRUE | parallel cdb view evaluation enabled |
_px_concurrent | TRUE | enables pq with concurrent execution of serial inputs |
_px_cpu_autodop_enabled | TRUE | enables or disables auto dop cpu computation |
_px_cpu_operator_bandwidth | CPU operator bandwidth in MB/sec for DOP computation | |
_px_cpu_process_bandwidth | 200 | CPU process bandwidth in MB/sec for DOP computation |
_px_dp_array_size | 32767 | Max number of pq processes supported |
_px_filter_parallelized | TRUE | enables or disables correlated filter parallelization |
_px_filter_skew_handling | TRUE | enable correlated filter parallelization to handle skew |
_px_groupby_pushdown | FORCE | perform group-by pushdown for parallel query |
_px_hybrid_TSM_HWMB_load | TRUE | Enable Hybrid Temp Segment Merge/High Water Mark Brokered load method |
_px_join_skew_handling | TRUE | enables skew handling for parallel joins |
_px_join_skew_minfreq | 30 | sets minimum frequency(%) for skewed value for parallel joins |
_px_join_skew_ratio | 10 | sets skew ratio for parallel joins |
_px_load_balancing_policy | UNIFORM | parallel load balancing policy |
_px_load_monitor_threshold | 10000 | threshold for pushing information to load slave workload monitor |
_px_message_compression | TRUE | enable compression of control messages for parallel query |
_px_monitor_load | FALSE | enable consumer load slave workload monitoring |
_px_object_sampling | 200 | parallel query sampling for base objects (100000 = 100%) |
_px_object_sampling_enabled | TRUE | use base object sampling when possible for range distribution |
_px_onepass_slave_acquisition | TRUE | enable/disable one pass slave acquisition for parallel execution |
_px_parallelize_expression | TRUE | enables or disables expression evaluation parallelization |
_px_partial_rollup_pushdown | ADAPTIVE | perform partial rollup pushdown for parallel execution |
_px_proactive_slave_alloc_threshold | 8 | parallel proactive slave allocation threshold/unit |
_px_pwmr_enabled | TRUE | parallel partition wise match recognize enabled |
_px_replication_enabled | TRUE | enables or disables replication of small table scans |
_px_single_server_enabled | TRUE | allow single-slave dfo in parallel query |
_px_tq_rowhvs | TRUE | turn on intra-row hash valueing sharing in TQ |
_px_wif_dfo_declumping | CHOOSE | NDV-aware DFO clumping of multiple window sorts |
_px_wif_extend_distribution_keys | TRUE | extend TQ data redistribution keys for window functions |
_px_wif_min_ndv_per_slave | 2 | mininum NDV of TQ keys needed per slave for scalable WiF PX |
_radm_enabled | TRUE | Data Redaction |
_re_fast_sql_operator | all | enables fast boxable sql operator |
_re_independent_expression_cache_size | 20 | defines max number of compiled cached expressions for iee |
_re_num_complex_operator | 1000 | defines max number of compiled complex operator per ruleset-iee |
_re_num_rowcache_load | 2 | defines max number of complex operators loaded with row cache |
_re_result_cache_keysiz | 20 | defines max number key for result cache hash table |
_re_result_cache_size | 20 | defines max number of cached elements for result cache |
_read_mostly_enable_logon | FALSE | Read mostly instances enable non-privileged logons |
_read_mostly_instance | FALSE | indicates this is a read_mostly instance |
_read_mostly_instance_qa_control | 0 | internal parameter to control read mostly instance QA |
_read_mostly_slave_timeout | 20000 | Time to wait on read mostly node when hub not available |
_realfree_heap_pagesize | 65536 | hint for real-free page size in bytes |
_realfree_pq_heap_pagesize | 65536 | hint for pq real-free page size in bytes |
_redef_on_statement | FALSE | Use on-statement refresh in online redefinition |
_redo_log_debug_config | 0 | Various configuration flags for debugging redo logs |
_redo_log_record_life | 168 | Life time in hours for redo log table records |
_region_name | gsm region name | |
_relocate_pdb | FALSE | Relocate PDB to another RAC instance after it is closed in the current instance |
_remote_asm | remote ASM configuration | |
_remote_awr_enabled | FALSE | Enable/disable Remote AWR Mode |
_remove_exf_component | TRUE | enable/disable removing of components EXF and RUL during upgrade |
_report_capture_cycle_time | 60 | Time (in sec) between two cycles of report capture daemon |
_report_capture_dbtime_percent_cutoff | 50 | 100X Percent of system db time daemon is allowed over 10 cycles |
_report_capture_recharge_window | 10 | No of report capture cycles after which db time is recharged |
_report_capture_timeband_length | 1 | Length of time band (in hours) in the reports time bands table |
_report_request_ageout_minutes | 60 | Time (in min) after which a report request is deleted from queue |
_resource_includes_unlimited_tablespace | FALSE | Whether RESOURCE role includes UNLIMITED TABLESPACE privilege |
_result_cache_deterministic_plsql | FALSE | result cache deterministic PLSQL functions |
_resumable_critical_alert | 0 | raise critical alert for resumable failure |
_rman_roundrobin_placement | Numa round robin placement for RMAN procs | |
_rond_test_mode | 0 | rac one node test mode |
_rowlen_for_chaining_threshold | 1000 | maximum rowlen above which rows may be chained across blocks |
_rowsets_cdb_view_enabled | TRUE | rowsets enabled for CDB views |
_rowsets_enabled | TRUE | enable/disable rowsets |
_rowsets_max_rows | 200 | maximum number of rows in a rowset |
_rowsets_target_maxsize | 524288 | target size in bytes for space reserved in the frame for a rowset |
_rtaddm_trigger_args | comma-separated list of numeric arguments for RT addm trigger | |
_rtaddm_trigger_enabled | TRUE | To enable or disable Real-Time ADDM automatic trigger |
_scalar_type_lob_storage_threshold | 4000 | threshold for VARCHAR2, NVARCHAR2, and RAW storage as BLOB |
_securefile_log_num_latches | 0 | Maximum number of open descriptors for securefile log |
_securefile_log_shared_pool_size | 0 | Size of securefile log buffer pool from SGA |
_securefiles_breakreten_retry | 5 | segment retry before dishonoring retention |
_securefiles_spcutl | FALSE | securefiles segment utl optimization |
_serial_log_write_worker_io | FALSE | Serialize log write slave I/O |
_set_container_service | DEFAULT | set container service |
_sf_default_enabled | TRUE | enable 12g securefile default |
_sga_alloc_slaves_term_timeout_secs | 120 | Termination timeout in secs for SA** slaves |
_shrd_que_tm_processes | 1 | number of sharded queue Time Managers to start |
_shrd_que_tm_statistics_duration | 0 | Shaded queue statistics collection window duration |
_simulated_log_write_usecs | 0 | Simulated latency of log writes (usecs) |
_skgxp_ant_options | SKGXP ANT options (oss) | |
_skip_acfs_checks | FALSE | Override checking if on an ACFS file system |
_smm_max_size_static | 92160 | static maximum work area size in auto mode (serial) |
_smm_px_max_size_static | 230400 | static maximum work area size in auto mode (global) |
_snapshot_recovery_enabled | TRUE | enable/disable snapshot recovery |
_sort_sync_min_spill_threshold | 90 | controls the mininum spill size for synchronized spill (in percent) |
_sort_sync_min_spillsize | 262144 | controls the size of mininum run size for synchronized spill (in kb) |
_sql_diag_repo_origin | all | duarations where sql diag repository are retained |
_sql_diag_repo_retain | retain sql diag repository to cursor or not | |
_sql_hvshare_debug | 1 | control hash value sharing debug level |
_sql_hvshare_threshold | 0 | threshold to control hash value sharing across operators |
_sql_plan_directive_mgmt_control | 3 | controls internal SQL Plan Directive management activities |
_sql_show_expreval | FALSE | show expression evalution as shared hash producer in plan |
_stat_aggs_one_pass_algorithm | FALSE | enable one pass algorithm for variance-related functions |
_suppress_identifiers_on_dupkey | FALSE | supress owner index name err msg |
_switch_current_scan_scn | TRUE | switch current uses scan scn |
_switchover_timeout | 0 | Switchover timeout in minutes |
_sys_logon_delay | 1 | failed logon delay for sys |
_target_log_write_size | 0 | Do log write if this many redo blocks in buffer (auto=0) |
_target_log_write_size_timeout | 1 | How long LGWR will wait for redo to accumulate (csecs) |
_temp_undo_disable_adg | FALSE | is temp undo disabled on ADG |
_test_hm_extent_map | FALSE | heatmap related – to be used by oracle dev only |
_test_param_7 | test parameter 7 – big integer list | |
_test_param_8 | 20 | test parameter 8 – cdb tests |
_thread_state_change_timeout_pnp | 1800 | Thread state change timeout for PnP instance (in sec) |
_time_based_rcv_ckpt_target | 0 | time-based incremental recovery checkpoint target in sec |
_time_based_rcv_hdr_update_interval | 0 | time-based incremental recovery file header update interval in sec |
_trace_ktfs | FALSE | Trace ILM Stats Tracking |
_trace_ktfs_mem | FALSE | Debug memleak |
_trace_temp | FALSE | Trace Tempspace Management |
_track_metrics_memory | TRUE | Enable/disable Metrics Memory Tracking |
_tsenc_obfuscate_key | BOTH | Encryption key obfuscation in memory |
_twenty-eighth_spare_parameter | FALSE | twenty-eighth spare parameter – boolean |
_twenty-fifth_spare_parameter | twenty-fifth spare parameter – string list | |
_twenty-first_spare_parameter | twenty-first spare parameter – string list | |
_twenty-fourth_spare_parameter | twenty-fourth spare parameter – string list | |
_twenty-second_spare_parameter | twenty-second spare parameter – string list | |
_twenty-seventh_spare_parameter | FALSE | twenty-seventh spare parameter – boolean |
_twenty-sixth_spare_parameter | FALSE | twenty-sixth spare parameter – boolean |
_twenty-third_spare_parameter | twenty-third spare parameter – string list | |
_txn_control_trace_buf_size | 4096 | size the in-memory buffer size of txn control |
_unified_audit_flush_interval | 3 | Unified Audit SGA Queue Flush Interval |
_unified_audit_flush_threshold | 85 | Unified Audit SGA Queue Flush Threshold |
_unified_audit_policy_disabled | FALSE | Disable Default Unified Audit Policies on DB Create |
_upddel_dba_hash_mask_bits | 0 | controls masking of lower order bits in DBA |
_use_fips_mode | FALSE | Enable use of crypographic libraries in FIPS mode |
_use_hidden_partitions | FALSE | use hidden partitions |
_use_single_log_writer | ADAPTIVE | Use a single process for redo log writing |
_utlmmig_table_stats_gathering | TRUE | enable/disable utlmmig table stats gathering at upgrade |
_uts_first_segment_retain | TRUE | Should we retain the first trace segment |
_uts_first_segment_size | 0 | Maximum size (in bytes) of first segments |
_uts_trace_disk_threshold | 0 | Trace disk threshold parameter |
_uts_trace_segment_size | 0 | Maximum size (in bytes) of a trace segment |
_uts_trace_segments | 5 | Maximum number of trace segments |
_validate_metric_groups | FALSE | Enable/disable SGA Metric Structure validation |
_wcr_grv_cache_size | 65535 | Oracle internal: Set the replay cache size for WRR$_REPLAY_DATA. |
_wcr_seq_cache_size | 65535 | Oracle internal: Set the replay cache size for WRR$_REPLAY_SEQ_DATA. |
_widetab_comp_enabled | TRUE | wide table compression enabled |
_xa_internal_retries | 600 | number of internal retries for xa transactions |
_xds_max_child_cursors | 100 | Maximum number of XDS user-specific child cursors |
_xs_cleanup_task | TRUE | Triton Session Cleanup |
_xs_dispatcher_only | FALSE | XS dispatcher only mode |
_zonemap_control | 0 | control different uses/algorithms related to zonemaps |
_zonemap_staleness_tracking | 1 | control the staleness tracking of zonemaps via trigger |
_zonemap_use_enabled | TRUE | enable the use of zonemaps for IO pruning |
cell_offloadgroup_name | Set the offload group name | |
connection_brokers | ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1)) | connection brokers specification |
db_big_table_cache_percent_target | 0 | Big table cache target size in percentage |
db_index_compression_inheritance | NONE | options for table or tablespace level compression inheritance |
dnfs_batch_size | 4096 | Max number of dNFS asynch I/O requests queued per session |
enable_pluggable_database | TRUE | Enable Pluggable Database |
heat_map | OFF | ILM Heatmap Tracking |
max_string_size | STANDARD | controls maximum size of VARCHAR2, NVARCHAR2, and RAW types in SQL |
noncdb_compatible | FALSE | Non-CDB Compatible |
optimizer_adaptive_features | TRUE | controls adaptive features |
optimizer_adaptive_reporting_only | FALSE | use reporting-only mode for adaptive optimizations |
parallel_degree_level | 100 | adjust the computed degree in percentage |
parallel_fault_tolerance_enabled | FALSE | enables or disables fault-tolerance for parallel statement |
pdb_file_name_convert | PDB file name convert patterns and strings for create cdb/pdb | |
pga_aggregate_limit | 2.15E+09 | limit of aggregate PGA memory consumed by the instance |
spatial_vector_acceleration | FALSE | enable spatial vector acceleration |
temp_undo_enabled | FALSE | is temporary undo enabled |
threaded_execution | FALSE | Threaded Execution Mode |
unified_audit_sga_queue_size | 1048576 | Size of Unified audit SGA Queue |
use_dedicated_broker | FALSE | Use dedicated connection broker |
[…] 【12c新特性】12cR1 diff 11gR2 Hidden Parameters […]