– Enter name of the parameter when prompted

SETlinesize235colParameterFORa50colSESSIONFORa28colInstanceFORa55colSFORa1colIFORa1colDFORa1colDescriptionFORa90SELECTa.ksppinm"Parameter",decode(p.isses_modifiable,'FALSE',NULL,NULL,NULL,b.ksppstvl)"Session",c.ksppstvl"Instance",decode(p.isses_modifiable,'FALSE','F','TRUE','T')"S",decode(p.issys_modifiable,'FALSE','F','TRUE','T','IMMEDIATE','I','DEFERRED','D')"I",decode(p.isdefault,'FALSE','F','TRUE','T')"D",a.ksppdesc"Description"FROMx$ksppia,x$ksppcvb,x$ksppsvc,v$parameterpWHEREa.indx=b.indxANDa.indx=c.indxANDp.name(+)=a.ksppinmANDUPPER(a.ksppinm)LIKEUPPER('%&1%')ORDERBYa.ksppinm;Entervaluefor1:Here is the list of all undocumented parameters in Oracle 11g :

<1table border="0" class=" xhe-border ke-zeroborder" style="border-width:1px;border-style:dotted dotted solid;border-color:#D3D3D3 #D3D3D3 #EDEDED;border-image:initial;background-color:#FFFFFF;border-spacing:0px;font-size:14px;line-height:2;margin:0px 0px 20px;width:662px;color:#141412;font-family:" "="">

PARAMETER NAMEPARAMETER VALUEDESCRIPTION_4031_dump_bitvec67194879bitvec to specify dumps prior to 4031 error_4031_dump_interval300Dump 4031 error once for each n-second interval_4031_max_dumps100Maximum number of 4031 dumps for this process_4031_sga_dump_interval3600Dump 4031 SGA heapdump error once for each n-second interval_4031_sga_max_dumps10Maximum number of SGA heapdumps_NUMA_instance_mappingNot specifiedSet of nodes that this instance should run on_NUMA_pool_sizeNot specifiedaggregate size in bytes of NUMA pool_PX_use_large_poolFALSEUse Large Pool as source of PX buffers_UTL_FILE_FOLLOW_SYMLINKSFALSEUTL_FILE backout event which allows UTL_FILE to open symlinks__db_cache_size314572800Actual size of DEFAULT buffer pool for standard block size buffers__dg_broker_service_namespdb11_XPTservice names for broker use__java_pool_size20971520Actual size in bytes of java pool__large_pool_size4194304Actual size in bytes of large pool__oracle_base/u01/app/oracleORACLE_BASE__pga_aggregate_target209715200Current target size for the aggregate PGA memory consumed__sga_target629145600Actual size of SGA__shared_io_pool_size0Actual size of shared IO pool__shared_pool_size281018368Actual size in bytes of shared pool__streams_pool_size0Actual size in bytes of streams pool_abort_recovery_on_joinFALSEif TRUE, abort recovery on join reconfigurations_accept_versions
List of parameters for rolling operation_active_standby_fast_reconfigurationTRUEif TRUE optimize dlm reconfiguration for active/standby OPS_adaptive_direct_readTRUEAdaptive Direct Read_adaptive_fetch_enabledTRUEenable/disable adaptive fetch in parallel group by_add_col_optim_enabledTRUEAllows new add column optimization_add_stale_mv_to_dependency_listTRUEadd stale mv to dependency list_addm_auto_enableTRUEgoverns whether ADDM gets run automatically after every AWR snapshot_addm_skiprules
comma-separated list of ADDM nodes to skip_addm_version_checkTRUEgoverns whether ADDM checks the input AWR snapshot version_adjust_literal_replacementFALSEIf TRUE, we will adjust the SQL/PLUS output_affinity_onTRUEenable/disable affinity at run time_aiowait_timeouts100Number of aiowait timeouts before error is reported_alert_expiration604800seconds before an alert message is moved to exception queue_alert_message_cleanup1Enable Alert Message Cleanup_alert_message_purge1Enable Alert Message Purge_alert_post_background1Enable Background Alert Posting_all_shared_dblinks
treat all dblinks as shared_allocate_creation_orderFALSEshould files be examined in creation order during allocation_allocation_update_interval3interval at which successful search in L1 should be updated_allow_commutativityTRUEallow for commutativity of +, * when comparing expressions_allow_drop_snapshot_standby_grspFALSEAllow dropping snapshot standby guaranteed restore point_allow_error_simulationFALSEAllow error simulation for testing_allow_level_without_connect_byFALSEallow level without connect by_allow_read_only_corruptionFALSEallow read-only open even if database is corrupt_allow_resetlogs_corruptionFALSEallow resetlogs even if it will cause corruption_allow_sage_attrTRUEAllow checking Disk Group SAGE Attr_allow_terminal_recovery_corruptionFALSEFinish terminal recovery even if it may cause corruption_alternate_iot_leaf_block_split_pointsTRUEenable alternate index-organized table leaf-block split-points_always_anti_joinCHOOSEalways use this method for anti-join when possible_always_semi_joinCHOOSEalways use this method for semi-join when possible_always_star_transformationFALSEalways favor use of star transformation_app_ctx_versFALSEenable app ctx versioning_aq_tm_scanlimit0scan limit for Time Managers to clean up IOT_arch_corrupted_redo_log0Variable to simulate corruption errors during archivals_arch_io_slaves0ARCH I/O slaves_array_update_vector_read_enabledFALSEEnable array update vector read_ash_disk_filter_ratio10Ratio of the number of in-memory samples to the number of samples actually written to disk_ash_disk_write_enableTRUETo enable or disable Active Session History flushing_ash_dummy_test_param0Oracle internal dummy ASH parameter used ONLY for testing!_ash_eflush_trigger66The percentage above which if the in-memory ASH is full the emergency flusher will be triggered_ash_enableTRUETo enable or disable Active Session sampling and flushing_ash_min_mmnl_dump90Minimum Time interval passed to consider MMNL Dump_ash_sample_allFALSETo enable or disable sampling every connected session including ones waiting for idle waits_ash_sampling_interval1000Time interval between two successive Active Session samples in millisecs_ash_size1048618To set the size of the in-memory Active Session History buffers_asm_acd_chunks1initial ACD chunks created_asm_allow_only_raw_disksTRUEDiscovery only raw devices_asm_allow_resilver_corruptionFALSEEnable disk resilvering for external redundancy_asm_ausize1048576allocation unit size_asm_blksize4096metadata block size_asm_compatibility10.1default ASM compatibility level_asm_dbmsdg_nohdrchkFALSEdbms_diskgroup.checkfile does not check block headers_asm_disk_repair_time14400seconds to wait before dropping a failing disk_asm_emulmax10000max number of concurrent disks to emulate I/O errors_asm_emultimeout0timeout before emulation begins (in 3s ticks)_asm_kfdpevent0KFDP event_asm_kfioevent0KFIO event_asm_librariesufslibrary search order for discovery_asm_maxio1048576Maximum size of individual I/O request_asm_repairquantum60quantum (in 3s) used to compute elapsed time for disk drop_asm_runtime_capability_volume_supportFALSEruntime capability for volume support returns supported_asm_skip_resize_checkFALSEskip the checking of the clients for s/w compatibility for resize_asm_stripesize131072ASM file stripe size_asm_stripewidth8ASM file stripe width_asm_wait_time18Max/imum time to wait before asmb exits_asmlib_test0Osmlib test event_asmsidasmASM instance id_assm_defaultTRUEASSM default_async_recovery_claimsTRUEif TRUE, issue recovery claims asynchronously_async_recovery_readsTRUEif TRUE, issue recovery reads asynchronously_async_ts_threshold1check tablespace thresholds asynchronously_auto_assign_cg_for_sessionsFALSEauto assign CGs for sessions_automatic_maintenance_test0Enable AUTOTASK Test Mode_automemory_broker_interval3memory broker statistics gathering interval for auto memory_autotask_max_window480Maximum Logical Maintenance Window Length in minutes_autotask_min_window15Minimum Maintenance Window Length in minutes_autotune_gtx_idle_time600idle time to trigger auto-shutdown a gtx background process_autotune_gtx_interval5interval to autotune global transaction background processes_autotune_gtx_threshold60auto-tune threshold for degree of global transaction concurrency_avoid_prepareTRUEif TRUE, do not prepare a buffer when the master is local_aw_row_source_enabledTRUEEnables AW Row Source instead of collection iterator_awr_corrupt_modeFALSEAWR Corrupt Mode_awr_disabled_flush_tables
Disable flushing of specified AWR tables_awr_flush_threshold_metricsTRUEEnable/Disable Flushing AWR Threshold Metrics_awr_flush_workload_metricsFALSEEnable/Disable Flushing AWR Workload Metrics_awr_mmon_cpuusageTRUEEnable/disable AWR MMON CPU Usage Tracking_awr_restrict_modeFALSEAWR Restrict Mode_awr_sql_child_limit200Setting for AWR SQL Child Limit_b_tree_bitmap_plansTRUEenable the use of bitmap plans for tables w. only B-tree indexes_backup_disk_io_slaves0BACKUP Disk I/O slaves_backup_encrypt_opt_mode4294967294specifies encryption block optimization mode_backup_io_pool_size1048576memory to reserve from the large pool_backup_kgc_bufsz0specifies buffer size to be used by BZIP2 compression_backup_kgc_memlevel8specifies memory level for ZLIB compression_backup_kgc_niters0specifies number of iterations done by BZIP2 compression_backup_kgc_perflevel1specifies compression (performance) level for ZLIB compression_backup_kgc_schemeZLIBspecifies compression scheme_backup_kgc_type0specifies compression type used by kgc BZIP2 compression_backup_kgc_windowbits15specifies window size for ZLIB compression_backup_ksfq_bufcnt0number of the ksfq buffers used for backup/restore_backup_ksfq_bufcnt_max0maximum number of the ksfq buffer used for backup/restore_backup_ksfq_bufsz0size of the ksfq buffer used for backup/restore_backup_max_gap_size4294967294largest gap in an incremental/optimized backup buffer, in bytes_bct_bitmaps_per_file8number of bitmaps to store for each datafile_bct_buffer_allocation_max104857600maximum size of all change tracking buffer allocations, in bytes_bct_buffer_allocation_min_extents1mininum number of extents to allocate per buffer allocation_bct_buffer_allocation_size2097152size of one change tracking buffer allocation, in bytes_bct_chunk_size0change tracking datafile chunk size, in bytes_bct_crash_reserve_size262144change tracking reserved crash recovery SGA space, in bytes_bct_file_block_size0block size of change tracking file, in bytes_bct_file_extent_size0extent size of change tracking file, in bytes_bct_fixtab_file
change tracking file for fixed tables_bct_initial_private_dba_buffer_size0initial number of entries in the private change tracking dba buffers_bct_public_dba_buffer_size0total size of all public change tracking dba buffers, in bytes_bitmap_or_improvement_enabledTRUEcontrols extensions to partition pruning for general predicates_block_change_trackingTRUEchange tracking possible_blocking_sess_graph_cache_size
blocking session graph cache size in bytes_blocks_per_cache_server64number of consecutive blocks per global cache server_bloom_filter_debug0debug level for bloom filtering_bloom_filter_enabledTRUEenables or disables bloom filter_bloom_predicate_enabledFALSEenables or disables bloom filter predicate pushdown_bloom_pruning_enabledTRUEEnable partition pruning using bloom filtering_bloom_vector_elements0number of elements in a bloom filter vector_bsln_adaptive_thresholds_enabledTRUEAdaptive Thresholds Enabled_bt_mmv_query_rewrite_enabledTRUEallow rewrites with multiple MVs and base tables_buffer_busy_wait_timeout100buffer busy wait time in centiseconds_buffered_publisher_flow_control_threshold0Flow control threshold for buffered publishers except capture_bufq_stop_flow_controlFALSEStop enforcing flow control for buffered queues_build_deferred_mv_skipping_mvlog_updateFALSEDEFERRED MV creation skipping MV log setup update_bump_highwater_mark_count0how many blocks should we allocate per free list on advancing HWM_bwr_for_flushed_piTRUEif TRUE, generate a BWR for a flushed PI_cache_stats_monitorFALSEif TRUE, enable cache stats monitoring_capture_buffer_size65536To set the size of the PGA I/O recording buffers_capture_publisher_flow_control_threshold0Flow control threshold for capture publishers_case_sensitive_logonTRUEcase sensitive logon enabled_cgs_reconfig_timeout1000CGS reconfiguration timeout interval_cgs_send_timeout300CGS send timeout value_cgs_tickets1000CGS messaging tickets_check_block_after_checksumTRUEperform block check after checksum if both are turned on_check_block_new_invariant_for_flashbackFALSEcheck block new invariant for flashback_check_ts_threshold0check tablespace thresholds_cleanup_rollback_entries100no. of undo entries to apply per transaction cleanup_client_result_cache_bypassFALSEbypass the client result cache_close_cached_open_cursorsFALSEclose cursors cached by PL/SQL at each commit_cluster_libraryclsscluster library selection_clusterwide_global_transactionsTRUEenable/disable clusterwide global transactions_collapse_wait_historyFALSEcollapse wait history_collect_undo_statsTRUECollect Statistics v$undostat_column_compression_factor0Column compression ratio_column_elimination_offFALSEturn off predicate-only column elimination_column_tracking_level1column usage tracking_compilation_call_heap_extent_size16384Size of the compilation call heaps extents_complex_view_mergingTRUEenable complex view merging_compression_above_cache0number of recompression above cache for sanity check_compression_advisor0Compression advisor_compression_chain50percentage of chained rows allowed for Compression_controlfile_block_size0control file block size in bytes_controlfile_enqueue_dumpFALSEdump the system states after controlfile enqueue timeout_controlfile_enqueue_holding_time780control file enqueue max holding time in seconds_controlfile_enqueue_timeout900control file enqueue timeout in seconds_controlfile_section_init_size
control file initial section size_controlfile_section_max_expand
control file max expansion rate_controlfile_update_checkOFFcontrolfile update sanity check_convert_set_to_joinFALSEenables conversion of set operator to join_coord_message_buffer0parallel recovery coordinator side extra message buffer size_corrupted_rollback_segments
corrupted undo segment list_cost_equality_semi_joinTRUEenables costing of equality semi-join_cp_num_hash_latches1connection pool number of hash latches_cpu_to_io0divisor for converting CPU cost to I/O cost_cr_grant_global_roleTRUEif TRUE, grant lock for CR requests when block is in global role_cr_grant_local_roleAUTOturn 3-way CR grants off, make it automatic, or turn it on_cr_server_log_flushTRUEif TRUE, flush redo log before serving a CR buffer_cursor_bind_capture_area_size400maximum size of the cursor bind capture area_cursor_bind_capture_interval900interval (in seconds) between two bind capture for a cursor_cursor_db_buffers_pinned178additional number of buffers a cursor can pin at once_cursor_features_enabled2Shared cursor features enabled bits._cursor_plan_enabledTRUEenable collection and display of cursor plans_cursor_plan_hash_version1version of cursor plan hash value_cursor_plan_unparse_enabledTRUEenables/disables using unparse to build projection/predicates_cursor_stats_bucket15Hash table buckets for cursor stats (2^)._cursor_stats_heap4Heaps/latches for cursor stats._cvw_enable_weak_checkingTRUEenable weak view checking_db_aging_cool_count1Touch count set when buffer cooled_db_aging_freeze_crFALSEMake CR buffers always be too cold to keep in cache_db_aging_hot_criteria2Touch count which sends a buffer to head of replacement list_db_aging_stay_count0Touch count set when buffer moved to head of replacement list_db_aging_touch_time3Touch count which sends a buffer to head of replacement list_db_always_check_system_tsTRUEAlways perform block check and checksum for System tablespace_db_block_adjcheckTRUEadjacent cache buffer checks – low blkchk overwrite parameter_db_block_adjchk_level0adjacent cache buffer check level_db_block_align_direct_readTRUEAlign Direct Reads_db_block_bad_write_checkFALSEenable bad write checks_db_block_buffers27060Number of database blocks cached in memory: hidden parameter_db_block_cache_cloneFALSEAlways clone data blocks on get (for debugging)_db_block_cache_history0buffer header tracing (non-zero only when debugging)_db_block_cache_history_level2buffer header tracing level_db_block_cache_num_umap0number of unmapped buffers (for tracking swap calls on blocks)_db_block_cache_protectFALSEprotect database blocks (true only when debugging)_db_block_cache_protect_internal0protect database blocks (for strictly internal use only)_db_block_check_for_debugFALSECheck more and dump block before image for debugging_db_block_check_objtypTRUEcheck objd and typ on cache disk read_db_block_corruption_recovery_threshold5threshold number of block recovery attempts_db_block_do_full_mbreadsFALSEdo full block read even if some blocks are in cache_db_block_hash_buckets65536Number of database block hash buckets_db_block_hash_latches2048Number of database block hash latches_db_block_header_guard_level0number of extra buffer headers to use as guard pages_db_block_hi_priority_batch_size0Fraction of writes for high priority reasons_db_block_known_clean_pct2Initial Percentage of buffers to maintain known clean_db_block_lru_latches8number of lru latches_db_block_max_cr_dba6Maximum Allowed Number of CR buffers per dba_db_block_max_scan_pct40Percentage of buffers to inspect when looking for free_db_block_med_priority_batch_size0Fraction of writes for medium priority reasons_db_block_numa1Number of NUMA nodes_db_block_prefetch_fast_longjumps_enabledTRUEBatched IO enable fast longjumps_db_block_prefetch_limit0Prefetch limit in blocks_db_block_prefetch_override0Prefetch force override in blocks_db_block_prefetch_private_cache_enabledTRUEBatched IO enable private cache_db_block_prefetch_quota10Prefetch quota as a percent of cache size_db_block_prefetch_skip_reading_enabledTRUEBatched IO enable skip reading buffers_db_block_table_scan_buffer_size4194304Size of shared table scan read buffer_db_block_temp_redoFALSEgenerate redo for temp blocks_db_block_trace_protectFALSEtrace buffer protect calls_db_block_vlm_checkFALSEcheck of rvlm mapping leaks (for debugging)_db_block_vlm_leak_threshold3Threshold for allowable vlm leaks_db_blocks_per_hash_latch
Number of blocks per hash latch_db_cache_advice_batch_size128cache advisory simulation batch size_db_cache_advice_sample_factor4cache advisory sampling factor_db_cache_crx_checkFALSEcheck for costly crx examination functions_db_cache_pre_warmTRUEBuffer Cache Pre-Warm Enabled : hidden parameter_db_cache_process_cr_pin_max
maximum number of cr pins a process may have_db_change_notification_enableTRUEenable db change notification_db_disable_temp_encryptionFALSEDiable Temp Encryption for Spills_db_fast_obj_checkFALSEenable fast object drop sanity check_db_fast_obj_ckptTRUEenable fast object checkpoint_db_fast_obj_truncateTRUEenable fast object truncate_db_file_direct_io_count1048576Sequential I/O buf size_db_file_exec_read_count128multiblock read count for regular clients_db_file_format_io_buffers4Block formatting I/O buf count_db_file_noncontig_mblock_read_count11number of noncontiguous db blocks to be prefetched_db_file_optimizer_read_count8multiblock read count for regular clients_db_handles750System-wide simultaneous buffer operations_db_handles_cached5Buffer handles cached each process_db_hot_block_trackingFALSEtrack hot blocks for hash latch contention_db_index_block_checkingTRUEindex block checking override parameter_db_large_dirty_queue25Number of buffers which force dirty queue to be written_db_lost_write_checkingFALSEEnable scn based lost write detection mechanism_db_mttr_adviceONMTTR advisory_db_mttr_partitions0number of partitions for MTTR advisory_db_mttr_sample_factor64MTTR simulation sampling factor_db_mttr_sim_target
MTTR simulation targets_db_mttr_sim_trace_size256MTTR simulation trace size_db_mttr_trace_to_alertFALSEdump trace entries to alert file_db_noarch_disble_optimFALSEImage redo logging (NOARCHIVEMODE)_db_num_evict_waitevents64number of evict wait events_db_obj_enable_ksrTRUEenable ksr in object checkpoint/reuse_db_percent_hot_default50Percent of default buffer pool considered hot_db_percent_hot_keep0Percent of keep buffer pool considered hot_db_percent_hot_recycle0Percent of recycle buffer pool considered hot_db_percpu_create_cachesize2size of cache created per cpu in deferred cache create_db_recovery_temporal_file_dest
default database recovery temporal file location_db_required_percent_fairshare_usage10percent of fairshare a processor group should always use_db_row_overlap_checkingTRUErow overlap checking override parameter for data/index blocks_db_todefer_cache_createTRUEbuffer cache deferred create_db_writer_chunk_writes0Number of writes DBWR should wait for_db_writer_coalesce_area_size2293760Size of memory allocated to dbwriter for coalescing writes_db_writer_coalesce_write_limit131072Limit on size of coalesced write_db_writer_flush_imuTRUEIf FALSE, DBWR will not downgrade IMU txns for AGING_db_writer_histogram_statisticsFALSEmaintain dbwr histogram statistics in x$kcbbhs_db_writer_max_writes0Max number of outstanding DB Writer IOs_db_writer_nomemcopy_coalesceFALSEEnable DBWR no-memcopy coalescing_db_writer_verify_writesFALSEEnable lost write detection mechanism_dbg_proc_startupFALSEdebug process startup_dbms_sql_security_level1Security level in DBMS_SQL_dbwr_async_ioTRUEEnable dbwriter asynchronous writes_dbwr_scan_interval300dbwriter scan interval_dbwr_tracing0Enable dbwriter tracing_dde_flood_control_initTRUEInitialize Flood Control at database open_dead_process_scan_interval60PMON dead process scan interval_deadlock_diagnostic_level2automatic deadlock resolution diagnostics level_deadlock_resolution_incidents_enabledTRUEcreate incidents during deadlock resolution_deadlock_resolution_level1automatic deadlock resolution level_deadlock_resolution_min_wait_timeout_secs60the minimum wait timeout required for deadlock resolution_deadlock_resolution_signal_process_thresh_secs60the amount of time given to process a deadlock resolution signal_dedicated_server_poll_count10dedicated server poll count_dedicated_server_post_waitFALSEdedicated server post/wait_dedicated_server_post_wait_callFALSEdedicated server post/wait call_default_encrypt_alg0default encryption algorithm_default_non_equality_sel_checkTRUEsanity check on default selectivity for like/range predicate_defer_log_boundary_ckptTRUEdefer media recovery checkpoint at log boundary_defer_log_count2Number of log boundaries media recovery checkpoint lags behind_delay_index_maintainTRUEdelays index maintenance until after MV is refreshed_desired_readmem_rate70The desired percentage of redo reading from memory_diag_adr_auto_purgeTRUEEnable/disable ADR MMON Auto Purging_diag_adr_enabledTRUEParameter to enable/disable Diag ADR_diag_adr_test_param0Test parameter for Diagnosability_diag_backward_compatTRUEBackward Compatibility for Diagnosability_diag_cc_enabledTRUEParameter to enable/disable Diag Call Context_diag_conf_cap_enabledTRUEParameter to enable/disable Diag Configuration Capture_diag_daemonTRUEstart DIAG daemon_diag_dde_async_age_limit300diag dde async actions: message age limit (in seconds)_diag_dde_async_cputime_limit300diag dde async actions: action cputime limit (in seconds)_diag_dde_async_mode1diag dde async actions: dispatch mode_diag_dde_async_msg_capacity1024diag dde async actions: message buffer capacity_diag_dde_async_msgs50diag dde async actions: number of preallocated message buffers_diag_dde_async_process_rate5diag dde async actions: message processing rate – per loop_diag_dde_async_runtime_limit900diag dde async actions: action runtime limit (in seconds)_diag_dde_async_slaves5diag dde async actions: max number of concurrent slave processes_diag_dde_enabledTRUEenable DDE handling of critical errors_diag_dde_fc_enabledTRUEParameter to enable/disable Diag Flood Control_diag_dde_fc_implicit_time0Override Implicit Error Flood Control time parameter_diag_dde_fc_macro_time0Override Macro Error Flood Control time parameter_diag_dde_inc_proc_delay1The minimum delay between two MMON incident sweeps (minutes)_diag_diagnosticsTRUETurn off diag diagnostics_diag_dump_timeout30timeout parameter for SYNC dump_diag_hm_rc_enabledTRUEParameter to enable/disable Diag HM Reactive Checks_diag_hm_tc_enabledFALSEParameter to enable/disable Diag HM Test(dummy) Checks_diag_uts_control0UTS control parameter_dimension_skip_nullTRUEcontrol dimension skip when null feature_direct_path_insert_features0disable direct path insert features_disable_12751FALSEdisable policy timeout error (ORA-12751)_disable_adaptive_shrunk_aggregationFALSEadaptive shrunk aggregation_disable_autotune_gtxFALSEdisable autotune global transaction background processes_disable_datalayer_samplingFALSEdisable datalayer sampling_disable_duplex_linkTRUETurn off connection duplexing_disable_fast_aggregationFALSEfast aggregation_disable_fast_validateFALSEdisable PL/SQL fast validation_disable_fastopenFALSEDo Not Use Fastopen_disable_fba_qrw0disable flashback archiver query rewrite_disable_fba_wpr0disable flashback archiver wait for prepared transactions_disable_file_locksFALSEdisable file locks for control, data, redo log files_disable_flashback_archiver0disable flashback archiver_disable_flashback_wait_callbackFALSEDisable flashback wait callback_disable_function_based_indexFALSEdisable function-based index matching_disable_health_checkFALSEDisable Health Check_disable_highres_ticksFALSEdisable high-res tick counter_disable_image_checkFALSEDisable Oracle executable image checking_disable_incremental_checkpointsFALSEDisable incremental checkpoints for thread recovery_disable_incremental_recovery_ckptFALSEDisable incremental recovery checkpoint mechanism_disable_index_block_prefetchingFALSEdisable index block prefetching_disable_instance_params_checkFALSEdisable instance type check for ksp_disable_interface_checkingFALSEdisable interface checking at startup_disable_kcb_flashback_blocknew_optFALSEDisable KCB flashback block new optimization_disable_kcbhxor_osdFALSEdisable kcbh(c)xor OSD functionality_disable_kcbl_flashback_blocknew_optFALSEDisable KCBL flashback block new optimization_disable_latch_free_SCN_writes_via_32casFALSEdisable latch-free SCN writes using 32-bit compare & swap_disable_latch_free_SCN_writes_via_64casFALSEdisable latch-free SCN writes using 64-bit compare & swap_disable_loggingFALSEDisable logging_disable_metrics_group0Disable Metrics Group (or all Metrics Groups)_disable_multiple_block_sizesFALSEdisable multiple block size support (for debugging)_disable_odmFALSEdisable odm feature_disable_parallel_conventional_loadFALSEDisable parallel conventional loads_disable_read_only_open_dict_checkFALSEDisable read-only open dictionary check_disable_rebalance_space_checkFALSEdisable space usage checks for storage reconfiguration_disable_recoverable_recoveryFALSEDisable the new recoverable recovery mechanism_disable_recovery_read_skipFALSEDisable the read optimization during media recovery_disable_sample_io_optimFALSEdisable row sampling IO optimization_disable_savepoint_resetFALSEdisable the fix for bug 1402161_disable_sec_ticksFALSEdisable low-res (sec) counter_disable_selftune_checkpointingFALSEDisable self-tune checkpointing_disable_streams_pool_auto_tuningFALSEdisable streams pool auto tuning_disable_sun_rsmTRUEDisable IPC OSD support for Sun RSMAPI_disable_system_state4294967294disable system state dump_disable_thread_internal_disableFALSEDisable thread internal disable feature_disable_txn_alert0disable txn layer alert_disable_vktmFALSEdisable vktm process_disable_wait_stackFALSEDisable wait stack_discrete_transactions_enabledFALSEenable OLTP mode_diskmon_pipe_name
DiSKMon skgznp pipe name_dispatcher_rate_scale
scale to display rate statistic (100ths of a second)_dispatcher_rate_ttl
time-to-live for rate statistic (100ths of a second)_distinct_view_unnestingFALSEenables unnesting of in subquery into distinct view_distributed_recovery_connection_hold_time200number of seconds RECO holds outbound connections open_dlmtrace
Trace string of global enqueue type(s)_dm_max_shared_pool_pct1max percentage of the shared pool to use for a mining model_dml_monitoring_enabledTRUEenable modification monitoring_domain_index_batch_size2000maximum number of rows from one call to domain index fetch routine_domain_index_dml_batch_size200maximum number of rows for one call to domain index dml routines_dra_bmr_number_threshold1000Maximum number of BMRs that can be done to a file_dra_bmr_percent_threshold10Maximum percentage of blocks in a file that can be BMR-ed_dra_enable_offline_dictionaryTRUEEnable the periodic creation of the offline dictionary for DRA_drop_table_granule256drop_table_granule_drop_table_optimization_enabledTRUEreduce SGA memory use during drop of a partitioned table_ds_iocount_iosize6553664Dynamic Sampling Service defaults: #IOs and IO Size_dss_cache_flushFALSEenable full cache flush for parallel execution_dtree_area_size131072size of Decision Tree Classification work area_dtree_binning_enabledTRUEDecision Tree Binning Enabled_dtree_bintest_id0Decision Tree Binning Test ID_dtree_compressbmp_enabledTRUEDecision Tree Using Compressed Bitmaps Enabled_dtree_max_surrogates1maximum number of surrogates_dtree_pruning_enabledTRUEDecision Tree Pruning Enabled_dummy_instanceFALSEdummy instance started by RMAN_dump_common_subexpressionsFALSEdump common subexpressions_dump_connect_by_loop_dataFALSEdump connect by loop error message into trc file_dump_cursor_heap_sizesFALSEdump comp/exec heap sizes to tryace file_dump_interval_limit120trace dump time interval limit (in seconds)_dump_max_limit5max number of dump within dump interval_dump_qbc_tree0dump top level query parse tree to trace_dump_rcvr_ipcTRUEif TRUE enables IPC dump at instance eviction time_dump_system_state_scopelocalscope of sysstate dump during instance termination_dump_trace_scopeglobalscope of trace dump during a process crash_dynamic_rls_policiesTRUErls policies are dynamic_dynamic_stats_threshold30delay threshold (in seconds) between sending statistics messages_edition_based_redefinitionFALSEenable edition based redefinition_eliminate_common_subexprTRUEenables elimination of common sub-expressions_emon_regular_ntfn_slaves4number of EMON slaves doing regular database notifications_enable_NUMA_optimizationTRUEEnable NUMA specific optimizations_enable_automatic_maintenance1if 1, Automated Maintenance Is Enabled_enable_automatic_sqltuneTRUEAutomatic SQL Tuning Advisory enabled parameter_enable_block_level_transaction_recoveryTRUEenable block level recovery_enable_cscn_cachingFALSEenable commit SCN caching for all transactions_enable_ddl_wait_lockTRUEuse this to turn off ddls with wait semantics_enable_default_affinity0to enable default implementation of affinity osds_enable_dml_lock_escalationTRUEenable dml lock escalation against partitioned tables if TRUE_enable_exchange_validation_using_checkTRUEuse check constraints on the table for validation_enable_fast_ref_after_mv_tbsFALSEenable fast refresh after move tablespace_enable_hash_overflowFALSETRUE – enable hash cluster overflow based on SIZE_enable_hwm_syncTRUEenable HWM synchronization_enable_list_ioFALSEEnable List I/O_enable_midtier_affinityTRUEenable midtier affinity metrics processing_enable_nativenet_tcpipFALSEEnable skgxp driver usage for native net_enable_obj_queuesTRUEenable object queues_enable_online_index_without_s_lockingTRUEAllow online index creation algorithm without S DML lock_enable_query_rewrite_on_remote_objsTRUEmv rewrite on remote table/view_enable_refresh_scheduleTRUEenable or disable MV refresh scheduling (revert to 9.2 behavior)_enable_reliable_latch_waitsTRUEEnable reliable latch waits_enable_rlbTRUEenable RLB metrics processing_enable_row_shippingTRUEuse the row shipping optimization for wide table selects_enable_scn_wait_interfaceTRUEuse this to turn off scn wait interface in kta_enable_separable_transactionsFALSEenable/disable separable transactions_enable_shared_pool_durationsTRUEtemporary to disable/enable kgh policy_enable_shared_server_vector_ioFALSEEnable shared server vector I/O_enable_space_preallocation3enable space pre-allocation_enable_spacebgTRUEenable space management background task_enable_tablespace_alertsTRUEenable tablespace alerts_enable_type_dep_selectivityTRUEenable type dependent selectivity estimates_endprot_chunk_commentchk 10235 dfltchunk comment for selective overrun protection_endprot_heap_commenthp 10235 dfltheap comment for selective overrun protection_endprot_subheapsTRUEselective overrun protection for subeheaps_enqueue_deadlock_time_sec5requests with timeout <= this will not have deadlock detection_enqueue_debug_multi_instanceFALSEdebug enqueue multi instance_enqueue_hash375enqueue hash table length_enqueue_hash_chain_latches1enqueue hash chain latches_enqueue_locks2260locks for managed enqueues_enqueue_resources968resources for enqueues_evolve_plan_baseline_report_levelTYPICALLevel of detail to show in plan verification/evolution report_evt_system_event_propagationTRUEdisable system event propagation_expand_aggregatesTRUEexpand aggregates_explain_rewrite_modeFALSEallow additional messages to be generated during explain rewrite_extended_pruning_enabledTRUEdo runtime pruning in iterator if set to TRUE_fair_remote_cvtFALSEif TRUE enables fair remote convert_fairness_threshold4number of times to CR serve before downgrading lock_fast_dual_enabledTRUEenable/disable fast dual_fast_full_scan_enabledTRUEenable/disable index fast full scan_fastpin_enable1enable reference count based fast pins_fbda_busy_percentage0flashback archiver busy percentage_fbda_inline2_percentage0flashback archiver full inline percentage_fbda_inline_percentage0flashback archiver inline percentage_fg_iorm_slaves1ForeGround I/O slaves for IORM_fg_log_checksumTRUEChecksum redo in foreground process_fic_algorithm_setautomaticSet Frequent Itemset Counting Algorithm_fic_area_size131072size of Frequent Itemset Counting work area_fic_max_length20Frequent Itemset Counting Maximum Itemset Length_fic_min_bmsize1024Frequent Itemset Counting Minimum BITMAP Size_fic_outofmem_candidatesFALSEFrequent Itemset Counting Out Of Memory Candidates Generation_fifth_spare_parameter
fifth spare parameter – string_filemap_dir
FILEMAP directory_first_k_rows_dynamic_prorationTRUEenable the use of dynamic proration of join cardinalities_first_spare_parameter
first spare parameter – integer_fix_control
bug fix control parameter_flashback_allow_noarchivelogFALSEAllow enabling flashback on noarchivelog database_flashback_archiver_partition_size0flashback archiver table partition size_flashback_barrier_interval1800Flashback barrier interval in seconds_flashback_copy_latches10Number of flashback copy latches_flashback_format_chunk_mb4Chunk mega-bytes for formatting flashback logs using sync write_flashback_format_chunk_mb_dwrite16Chunk mega-bytes for formatting flashback logs using delayed write_flashback_fuzzy_barrierTRUEUse flashback fuzzy barrier_flashback_generation_buffer_size4194304flashback generation buffer size_flashback_hint_barrier_percent20Flashback hint barrier percent_flashback_log_io_error_behavior0Specify Flashback log I/O error behavior_flashback_log_min_size100Minimum flashback log size_flashback_log_size1000Flashback log size_flashback_logfile_enqueue_timeout600flashback logfile enqueue timeout for opens_flashback_marker_cache_enabledTRUEEnable flashback database marker cache_flashback_marker_cache_size328Size of flashback database marker cache_flashback_max_log_size0Maximum flashback log size in bytes (OS limit)_flashback_max_n_log_per_thread2048Maximum number of flashback logs per flashback thread_flashback_max_standby_sync_span900Maximum time span between standby recovery sync for flashback_flashback_n_log_per_thread128Desired number of flashback logs per flashback thread_flashback_standby_barrier_interval1800Flashback standby barrier interval in seconds_flashback_verbose_infoFALSEPrint verbose information about flashback database_flashback_write_max_loop_limit10Flashback writer loop limit before it returns_force_datefold_truncFALSEforce use of trunc for datefolding rewrite_force_hsc_compressFALSEcompress all new created tables_force_oltp_compressFALSEOLTP Compress all new created tables_force_rewrite_enableFALSEcontrol new query rewrite features_force_slave_mapping_intra_part_loadsFALSEForce slave mapping for intra partition loads_force_temptables_for_gsetsFALSEexecutes concatenation of rollups using temp tables_force_tmp_segment_loadsFALSEForce tmp segment loads_forwarded_2pc_threshold10auto-tune threshold for two-phase commit rate across RAC instances_fourth_spare_parameter
fourth spare parameter – string_full_pwise_join_enabledTRUEenable full partition-wise join when TRUE_gby_hash_aggregation_enabledTRUEenable group-by and aggregation using hash scheme_gby_onekey_enabledTRUEenable use of one comparison of all group by keys_gc_affinity_lockingTRUEif TRUE, enable object affinity_gc_affinity_locksTRUEif TRUE, get affinity locks_gc_affinity_ratio50dynamic object affinity ratio_gc_async_memcpyFALSEif TRUE, use async memcpy_gc_bypass_readersTRUEif TRUE, modifications bypass readers_gc_check_bscnTRUEif TRUE, check for stale blocks_gc_coalesce_recovery_readsTRUEif TRUE, coalesce recovery reads_gc_defer_time3how long to defer down converts for hot buffers_gc_dissolve_undo_affinityFALSEif TRUE, dissolve undo affinity after an offline_gc_element_percent110global cache element percent_gc_global_checkpoint_scnTRUEif TRUE, enable global checkpoint scn_gc_global_lruAUTOturn global lru off, make it automatic, or turn it on_gc_initiate_undo_affinityTRUEif TRUE, initiate undo affinity after an online_gc_integrity_checks1set the integrity check level_gc_keep_recovery_buffersTRUEif TRUE, make recovery buffers current_gc_latches8number of latches per LMS process_gc_long_query_threshold0threshold for long running query_gc_maximum_bids0maximum number of bids which can be prepared_gc_policy_minimum1500dynamic object policy minimum activity per minute_gc_policy_time10how often to make object policy decisions in minutes_gc_read_mostly_lockingTRUEif TRUE, enable read-mostly locking_gc_statisticsTRUEif TRUE, kcl statistics are maintained_gc_transfer_ratio2dynamic object read-mostly transfer ratio_gc_undo_affinityTRUEif TRUE, enable dynamic undo affinity_gc_undo_block_disk_readsTRUEif TRUE, enable undo block disk reads_gc_use_crTRUEif TRUE, allow CR pins on PI and WRITING buffers_gc_vector_readTRUEif TRUE, vector read current buffers_gc_voluntary_down_convert_obj0object number for voluntary down-convert_gcs_fast_reconfigTRUEif TRUE, enable fast reconfiguration for gcs locks_gcs_latches0number of gcs resource hash latches to be allocated per LMS process_gcs_process_in_recoveryTRUEif TRUE, process gcs requests during instance recovery_gcs_res_per_bucket16number of gcs resource per hash bucket_gcs_resources
number of gcs resources to be allocated_gcs_shadow_locks
number of pcm shadow locks to be allocated_gcs_testing0GCS testing parameter_generalized_pruning_enabledTRUEcontrols extensions to partition pruning for general predicates_ges_dd_debug1if 1 or higher enables GES deadlock detection debug diagnostics_ges_diagnosticsTRUEif TRUE enables GES diagnostics_ges_health_check1if greater than 0 enables GES system health check_global_hang_analysis_interval_secs10the interval at which global hang analysis is run_globalindex_pnum_filter_enabledTRUEenables filter for global index with partition extended syntax_groupby_nopushdown_cut_ratio3groupby nopushdown cut ratio_groupby_orderby_combine5000groupby/orderby don’t combine threshold_gs_anti_semi_join_allowedTRUEenable anti/semi join for the GS query_hang_analysis_num_call_stacks3hang analysis num call stacks_hang_detection60Hang Management detection interval_hang_resolutionFALSEHang Management hang resolution_hard_protectionFALSEif TRUE enable H.A.R.D specific format changes_hash_join_enabledTRUEenable/disable hash join_hash_multiblock_io_count0number of blocks hash join will read/write at once_heur_deadlock_resolution_secs0the heuristic wait time per node for deadlock resolution_high_priority_processesLMS*|VKTMHigh Priority Process Name Mask_high_server_threshold0high server thresholds_hj_bit_filter_threshold50hash-join bit filtering threshold (0 always enabled)_hm_analysis_oradebug_node_dump_level0the oradebug node dump level for hang manager hang analysis_hm_analysis_oradebug_sys_dump_level0the oradebug system state level for hang manager hang analysis_hm_analysis_output_diskFALSEif TRUE the hang manager outputs hang analysis results to disk_hm_log_incidentsFALSEHang Manager incident logging_hm_verification_interval60the hang manager verification interval_hwm_sync_threshold10HWM synchronization threshold in percentage_idl_conventional_index_maintenanceTRUEenable conventional index maintenance for insert direct load_idle_session_kill_enabledTRUEenables or disables resource manager session idle limit checks_idxrb_rowincr100000000proportionality constant for dop vs. rows in index rebuild_ignore_desc_in_indexFALSEignore DESC in indexes, sort those columns ascending anyhow_ignore_fg_deps
ignore fine-grain dependencies during invalidation_immediate_commit_propagationTRUEif TRUE, propagate commit SCN immediately_improved_outerjoin_cardTRUEimproved outer-join cardinality calculation_improved_row_length_enabledTRUEenable the improvements for computing the average row length_imr_activeTRUEActivate Instance Membership Recovery feature_imr_avoid_double_votingTRUEAvoid device voting for CSS reconfig during IMR_imr_device_typecontrolfileType of device to be used by IMR_imr_disk_voting_interval3Maximum wait for IMR disk voting (seconds)_imr_evicted_member_killTRUEIMR issue evicted member kill after a wait_imr_evicted_member_kill_wait20IMR evicted member kill wait time in seconds_imr_highload_threshold
IMR system highload threshold_imr_max_reconfig_delay300Maximum Reconfiguration delay (seconds)_imr_splitbrain_res_wait600Maximum wait for split-brain resolution (seconds)_imr_systemload_checkTRUEPerform the system load check during IMR_imu_pools3in memory undo pools_in_memory_undoTRUEMake in memory undo for top level transactions_incremental_recovery_ckpt_min_batch30Minimum number of writes for incremental recovery ckpt every 3 sec_index_join_enabledTRUEenable the use of index joins_index_prefetch_factor100index prefetching factor_init_granule_interval10number of granules to process for deferred cache_init_sql_file?/rdbms/admin/sql.bsqFile containing SQL statements to execute upon database creation_inject_startup_fault0inject fault in the startup code_inline_sql_in_plsqlFALSEinline SQL in PL/SQL_insert_enable_hwm_brokeredTRUEduring parallel inserts high water marks are brokered_inst_locking_period5period an instance can retain a newly acquired level1 bitmap_interconnect_checksumTRUEif TRUE, checksum interconnect blocks_intrapart_pdml_enabledTRUEEnable intra-partition updates/deletes_intrapart_pdml_randomlocal_enabledTRUEEnable intra-partition updates/deletes with random local dist_io_resource_manager_always_onFALSEio resource manager always on_io_shared_pool_size4194304Size of I/O buffer pool from SGA_io_slaves_disabledFALSEDo not use I/O slaves_io_statisticsTRUEif TRUE, ksfd I/O statistics are collected_ioq_fanin_multiplier2IOQ miss count before a miss exception_ior_serialize_fault0inject fault in the ior serialize code_iorm_tout1000IORM scheduler timeout value in msec_ioslave_batch_count1Per attempt IOs picked_ioslave_issue_count500IOs issued before completion check_ipc_fail_network0Simulate cluster network failer_ipc_test_failover0Test transparent cluster network failover_ipc_test_mult_nets0simulate multiple cluster networks_job_queue_interval5Wakeup interval in seconds for job queue co-ordinator_k2q_latches0number of k2q latches_kcfis_fault_control0trace level setting for KCFIS module_kcfis_max_appliances40Max. appliances in a KCFIS session_kcfis_oss_io_size0KCFIS OSS I/O size_kcfis_read_buffer_limit0KCFIS Read Buffer (per session) memory limit in bytes_kcfis_trace_level0trace level setting for KCFIS module_kcfis_work_set_appliances6Working Set of appliances in a KCFIS session_kcl_commitTRUEif TRUE, call kjbcommit_kcl_conservative_log_flushFALSEif TRUE, conservatively log flush before CR serving_kcl_debugTRUEif TRUE, record le history_kcl_index_splitTRUEif TRUE, reject pings on blocks in middle of a split_kdbl_enable_post_allocationFALSEallocate dbas after populating data buffers_kdi_avoid_block_checkingFALSEavoid index block checking on sensitive opcodes_kdli_STOP_bsz0undocumented parameter for internal use only_kdli_STOP_dba0undocumented parameter for internal use only_kdli_STOP_fsz0undocumented parameter for internal use only_kdli_STOP_nio0undocumented parameter for internal use only_kdli_STOP_tsn0undocumented parameter for internal use only_kdli_allow_corruptTRUEallow corrupt filesystem_logging data blocks during read/write_kdli_cache_inodeTRUEcache inode state across calls_kdli_cache_read_threshold0minimum lob size for cache->nocache read (0 disables heuristic)_kdli_cache_size8maximum #entries in inode cache_kdli_cache_verifyFALSEverify cached inode via deserialization_kdli_cache_write_threshold0minimum lob size for cache->nocache write (0 disables heuristic)_kdli_cacheable_length0minimum lob length for inode cacheability_kdli_force_crTRUEforce CR when reading data blocks of direct-write lobs_kdli_force_cr_metaTRUEforce CR when reading metadata blocks of direct-write lobs_kdli_force_storagenoneforce storage settings for all lobs_kdli_full_readahead_threshold0maximum lob size for full readahead_kdli_inject_assert0inject asserts into the inode_kdli_inject_crash0inject crashes into the inode_kdli_inline_xfmTRUEallow inline transformed lobs_kdli_inode_preferencedatainline inode evolution preference (data, headless, lhb)_kdli_itree_entries0#entries in lhb/itree blocks (for testing only)_kdli_memory_protectFALSEtrace accesses to inode memory outside kdli API functions_kdli_rci_lobmap_entries255#entries in RCI lobmap before migration to lhb_kdli_readahead_limit0shared/cached IO readahead limit_kdli_readahead_strategycontigshared/cached IO readahead strategy_kdli_recent_scnFALSEuse recent (not dependent) scns for block format/allocation_kdli_reshapeFALSEreshape an inode to inline or headless on length truncation_kdli_safe_callbacksTRUEinvoke inode read/write callbacks safely_kdli_sio_asyncTRUEasynchronous shared IO_kdli_sio_backoffFALSEuse exponential backoff when attempting SIOP allocations_kdli_sio_bps0maximum blocks per IO slot_kdli_sio_dop2degree-of-parallelism in the SIO keep pool_kdli_sio_fgioTRUEreap asynchronous IO in the foreground_kdli_sio_fileopennodsyncshared IO fileopen mode: datasync vs nodatasync vs async_kdli_sio_flushFALSEenable shared IO pool operations_kdli_sio_freeTRUEfree IO buffers when not in active use_kdli_sio_min_read0shared IO pool read threshold_kdli_sio_min_write0shared IO pool write threshold_kdli_sio_nbufs8maximum #IO buffers to allocate per session_kdli_sio_niods8maximum #IO descriptors to allocate per session_kdli_sio_onTRUEenable shared IO pool operations_kdli_sio_pgaFALSEuse PGA allocations for direct IO_kdli_sio_pga_topFALSEPGA allocations come from toplevel PGA heap_kdli_sio_strategyautoshared IO strategy: block vs. extent_kdli_small_cache_limit32size limit of small inode cache_kdli_sort_dbasFALSEsort dbas during chunkification_kdli_space_cache_limit2048maximum size of the space cache in #blocks_kdli_squeezeTRUEcompact lobmap extents with contiguous dbas_kdli_timer_dmpFALSEdump inode timers on session termination_kdli_timer_trcFALSEtrace inode timers to uts/tracefile_kdli_trace0inode trace level_kdlu_max_bucket_size4194304UTS kdlu bucket size_kdlu_max_bucket_size_mts131072UTS kdlu bucket size for mts_kdlu_trace_layer0UTS kdlu per-layer trace level_kdlu_trace_session0UTS session dump_kdlu_trace_system0UTS system dump_kdlw_enable_ksi_lockingFALSEenable ksi locking for lobs_kdlw_enable_write_gatheringTRUEenable lob write gathering for sql txns_kdlwp_flush_threshold4194304WGC flush threshold in bytes_kdlxp_cmp_subunit_size262144size of compression sub-unit in bytes_kdlxp_dedup_flush_threshold8388608deduplication flush threshold in bytes_kdlxp_dedup_hash_algoSHA1secure hash algorithm for deduplication – only on SecureFiles_kdlxp_dedup_prefix_threshold1048576deduplication prefix hash threshold in bytes_kdlxp_lobcompressFALSEenable lob compression – only on SecureFiles_kdlxp_lobdeduplicateFALSEenable lob deduplication – only on SecureFiles_kdlxp_lobdedupvalidateTRUEenable deduplicate validate – only on SecureFiles_kdlxp_lobencryptFALSEenable lob encryption – only on SecureFiles_kdlxp_min_xfm_size32768minimum transformation size in bytes_kdlxp_mincmp20minimum comp ratio in pct – only on SecureFiles_kdlxp_spare10deduplication spare 1_kdlxp_xfmcacheTRUEenable xfm cache – only on SecureFiles_kdt_bufferingTRUEcontrol kdt buffering for conventional inserts_kebm_nstrikes3kebm # strikes to auto suspend an action_kebm_suspension_time82800kebm auto suspension time in seconds_keep_remote_column_sizeFALSEremote column size does not get modified_kernel_message_network_driverFALSEkernel message network driver_kffmap_hash_size1024size of kffmap_hash table_kffmop_hash_size2048size of kffmop_hash table_kfm_disable_set_fenceFALSEdisable set fence calls and revert to default (process fence)_kghdsidx_count1max kghdsidx count_kgl_bucket_count9index to the bucket count array_kgl_debug
Library cache debugging_kgl_features_enabled2Library cache features enabled bits_kgl_fixed_extentsTRUEfixed extent size for library cache memory allocations_kgl_hash_collisionFALSEwhether KGL hash collision is possible_kgl_heap_size1024extent size for library cache heap 0_kgl_kqr_cap_so_stacksFALSEcapture stacks for library and row cache state objects_kgl_large_heap_warning_threshold52428800maximum heap size before KGL writes warnings to the alert log_kgl_latch_count0number of library cache latches_kgl_message_locks64RAC message lock count_kgl_min_cached_so_count1Minimum cached SO count. If > 1 can help find SO corruptions_kgl_multi_instance_invalidationTRUEwhether KGL to support multi-instance invalidations_kgl_multi_instance_lockTRUEwhether KGL to support multi-instance locks_kgl_multi_instance_pinTRUEwhether KGL to support multi-instance pins_kgl_so_stack_depth16The depth of the stack capture for SO get or free_kgl_time_to_wait_for_locks15time to wait for locks and pins before timing out_kglsim_maxmem_percent5max percentage of shared pool size to be used for KGL advice_kgsb_threshold_size16777216threshold size for base allocator_kgx_latches1024# of mutex latches if CAS is not supported._kgx_spin_count255third spare parameter – integer_kill_controlfile_enqueue_blockerTRUEenable killing controlfile enqueue blocker on timeout_kill_diagnostics_timeout60timeout delay in seconds before killing enqueue blocker_kill_enqueue_blocker2if greater than 0 enables killing enqueue blocker_kill_java_threads_on_eocFALSEKill Java threads and do sessionspace migration at end of call_kill_session_dumpTRUEProcess dump on kill session immediate_kkdlgon_max_iter20000kkdlgon maximum number of iterations_kkfi_traceFALSEtrace expression substitution_kks_free_cursor_stat_pct10percentage of cursor stats buckets to scan on each load, in 1/10th of a percent_kks_use_mutex_pinTRUETurning on this will make KKS use mutex for cursor pins._kokli_cache_size32Size limit of Materialized View and Object Table Lookup Cache_kolfuseslfFALSEallow kolf to use slffopen_kql_subheap_trace0tracing level for library cache subheap level pins_ksb_disable_diagpidFALSEdisable the call to ksb_diagpid_ksb_restart_clean_time30000process uptime for restarts_ksb_restart_policy_times0, 60, 120, 240process restart policy times in seconds_ksd_test_param999KSD test parmeter_ksdxdocmd_default_timeout_ms30000default timeout for internal oradebug commands_ksdxdocmd_enabledTRUEif TRUE ksdxdocmd* invocations are enabled_ksdxw_cini_flg0ksdxw context initialization flag_ksdxw_nbufs1000ksdxw number of buffers in buffered mode_ksdxw_num_pgw10number of watchpoints on a per-process basis_ksdxw_num_sgw10number of watchpoints to be shared by all processes_ksdxw_stack_depth4number of PCs to collect in the stack when watchpoint is hit_kse_die_timeout60000amount of time a dying process is spared by PMON (in centi-secs)_kse_pc_table_size256kse pc table cache size_kse_signature_entries0number of entries in the kse stack signature cache_kse_signature_limit7number of stack frames to cache per kse signature_kse_snap_ring_size0ring buffer to debug internal error 17090_ksfd_verify_writeFALSEverify asynchronous writes issued through ksfd_ksi_trace
KSI trace string of lock type(s)_ksi_trace_bucketPRIVATEmemory tracing: use ksi-private or rdbms-shared bucket_ksi_trace_bucket_size8192size of the KSI trace bucket_ksmb_debug0ksmb debug flags_ksmd_protect_modeoffKSMD protect mode for catching stale access_ksmg_granule_locking_status1granule locking status_ksmg_granule_size4194304granule size in bytes_ksmg_lock_check_interval
timeout action interval in minutes_ksmg_lock_reacquire_count5repeat count for acquisition of locks_kspol_tac_timeout5timeouts for TAC registerd by kspol_ksr_unit_test_processes0number of ksr unit test processes_kss_quietFALSEif TRUE access violations during kss dumps are not recorded_ksu_diag_kill_time5number of seconds ksuitm waits before killing diag_ksuitm_addon_trccmd
command to execute when dead processes don’t go away_ksuitm_dont_kill_dumperFALSEdelay inst. termination to allow processes to dump_ksv_max_spawn_fail_limit5bg slave spawn failure limit_ksv_pool_hang_kill_to0bg slave pool terminate timeout_ksv_pool_wait_timeout600bg slave pool wait limit_ksv_spawn_control_allFALSEcontrol all spawning of background slaves_ksvppktmode0ksv internal pkt test_ksxp_diagmodeOFFset to OFF to disable automatic slowsend diagnostics_ksxp_disable_dynamic_loadingFALSEdisable dynamic loadin of lib skgxp_ksxp_disable_ipc_statsFALSEdisable ipc statistics_ksxp_init_stats_bkts0initial number arrays for ipc statistics_ksxp_max_stats_bkts0max. arrays for ipc statistics_ksxp_ping_enableTRUEdisable dynamic loadin of lib skgxp_ksxp_ping_polling_time0max. arrays for ipc statistics_ksxp_reaping20tune ksxp layer reaping limit_ksxp_reporting_processLMD0reporting process for KSXP_ksxp_send_timeout300set timeout for sends queued with the inter-instance IPC_ksxp_skgxp_compat_library_path
over-ride default location of lib skgxp compat_ksxp_skgxp_library_path
over-ride default location of lib skgxp_ksxp_stats_mem_lmt0limit ipc statistics memory. this parameter is a percentage value_ksxp_testing0KSXP test parameter_ksxp_unit_test_byte_transformationFALSEenable byte transformation unit test_ktc_debug0for ktc debug_ktc_latches0number of ktc latches_ktslj_segext_warning10segment pre-extension warning threshold in percentage_ktspsrch_maxsc32maximum segments supported by space search cache_kttext_warning5tablespace pre-extension warning threshold in percentage_ktu_latches0number of KTU latches_ku_tracenonedatapump trace parameter_large_pool_min_alloc16000minimum allocation size in bytes for the large allocation pool_last_allocation_period5period over which an instance can retain an active level1 bitmap_latch_class_0
latch class 0_latch_class_1
latch class 1_latch_class_2
latch class 2_latch_class_3
latch class 3_latch_class_4
latch class 4_latch_class_5
latch class 5_latch_class_6
latch class 6_latch_class_7
latch class 7_latch_classes
latch classes override_latch_miss_stat_sid0Sid of process for which to collect latch stats_latch_recovery_alignment65534align latch recovery structures_ldr_io_size262144size of write IOs used during a load operation_left_nested_loops_randomTRUEenable random distribution method for left of nestedloops_lgwr_async_broadcastsTRUELGWR Asynchronous Broadcasts enabling boolean flag_lgwr_delay_writeFALSELGWR write delay for debugging_lgwr_io_slaves0LGWR I/O slaves_lgwr_max_ns_wt1Maximum wait time for lgwr to allow NetServer to progress_lgwr_ns_nl_max1000Variable to simulate network latency or buffer threshold_lgwr_ns_nl_min500Variable to simulate network latency or buffer threshold_lgwr_ns_sim_err0Variable to simulate errors lgwrns_lgwr_ta_sim_err0Variable to simulate errors lgwr true async_library_cache_adviceTRUEwhether KGL advice should be turned on_lightweight_hdrsTRUELightweight headers for redo_like_with_bind_as_equalityFALSEtreat LIKE predicate with bind as an equality predicate_lm_activate_lms_threshold100threshold value to activate an additional lms_lm_asm_enq_hashingTRUEif TRUE makes ASM use enqueue master hashing for fusion locks_lm_better_ddvictimTRUEGES better deadlock victim_lm_cache_lvl0_cleanup0how often to cleanup level 0 cache res (in sec)_lm_cache_res_cleanup25percentage of cached resources should be cleanup_lm_cache_res_typeTMHWDIcache resource: string of lock types(s)_lm_checksum_batch_msg0GES checksum batch messages_lm_contiguous_res_count128number of contiguous blocks that will hash to the same HV bucket_lm_dd_interval10dd time interval in seconds_lm_dd_max_search_time180max dd search time per token_lm_dd_scan_interval5dd scan interval in seconds_lm_dd_search_cnt3number of dd search per token get_lm_drm_max_requests100dynamic remastering maximum affinity requests processed together_lm_drm_window0dynamic remastering bucket window size_lm_drm_xlatch0dynamic remastering forced exclusive latches_lm_dynamic_lmsFALSEdynamic lms invocation_lm_dynamic_loadTRUEdynamic load adjustment_lm_enq_lock_freelist
Number of ges enqueue element freelist_lm_enq_rcfgTRUEif TRUE enables enqueue reconfiguration_lm_enqueue_freelist3Number of enqueue freelist_lm_file_affinity
mapping between file id and master instance number_lm_global_postsTRUEif TRUE deliver global posts to remote nodes_lm_idle_connection_checkTRUEGES idle connection check_lm_idle_connection_check_interval10GES idle connection check interval time_lm_idle_connection_killFALSEGES idle connection kill_lm_lmd_waittime8default wait time for lmd in centiseconds_lm_lmon_nowait_latchTRUEif TRUE makes lmon get nowait latches with timeout loop_lm_lms0number of background gcs server processes to start_lm_lms_waittime8default wait time for lms in centiseconds_lm_locks12000number of enqueues configured for cluster database_lm_master_weight1master resource weight for this instance_lm_max_lms0max. number of background global cache server processes_lm_msg_batch_size0GES batch message size_lm_msg_cleanup_interval3000GES message buffer cleanup interval time_lm_node_join_optFALSEcluster database node join optimization in reconfig_lm_non_fault_tolerantFALSEdisable cluster database fault-tolerance mode_lm_num_pt_buckets8192number of buckets in the object affinity hash table_lm_num_pt_latches128number of latches in the object affinity hash table_lm_postevent_buffer_size256postevent buffer size_lm_proc_freeze_timeout300reconfiguration: process freeze timeout_lm_process_batchingTRUEGES implicit process batching for IPC messages_lm_procs320number of client processes configured for cluster database_lm_psrcfgFALSEenable pseudo reconfiguration_lm_rcfg_timeout1260Reconfiguration timeout_lm_rcvr_hang_allow_time200receiver hang allow time in seconds_lm_rcvr_hang_check_frequency60receiver hang check frequency in seconds_lm_rcvr_hang_killFALSEto kill receiver hang_lm_res_hash_bucket0number of resource hash buckets_lm_res_part128number of resource partition configured for gcs_lm_ress6000number of resources configured for cluster database_lm_send_modeautoGES send mode_lm_send_queue_batchingTRUEGES send queue message batching_lm_send_queue_length5000GES send queue maximum length_lm_sendproxy_reserve25GES percentage of send proxy reserve of send tickets_lm_share_lock_optFALSEif TRUE enables share lock optimization_lm_sq_batch_factor2GES send queue minimum batching factor_lm_sq_batch_typeautoGES send queue batching mechanism_lm_sq_batch_waittick3GES send queue batching waittime in tick_lm_sync_timeout420Synchronization timeout for DLM reconfiguration steps_lm_ticket_active_sendback
Flow control ticket active sendback threshold_lm_tickets1000GES messaging tickets_lm_tx_delta16TX lock localization delta_lm_validate_resource_typeFALSEif TRUE enables resource name validation_lm_xids352number of transaction IDs configured for cluster database_lmn_compressionFALSEsuppl logging for compression enabled_load_without_compileNONELoad PL/SQL or Database objects without compilation_local_communication_costing_enabledTRUEenable local communication costing when TRUE_local_communication_ratio50set the ratio between global and local communication (0..100)_local_hang_analysis_interval_secs3the interval at which local hang analysis is run_lock_sga_areas0Lock specified areas of the SGA in physical memory_log_archive_avoid_memcpyTRUElog archive avoid memcpy_log_archive_buffers10Number of buffers to allocate for archiving_log_archive_callout
archival callout_log_archive_compress_enableFALSEBypass database rules for enabling archivelog compression_log_archive_network_redo_size10Log archive network redo buffer size used by ARCH_log_archive_prot_auto_demoteFALSElog archive protection auto demotion_log_archive_security_enabledTRUElog archive security enabled_log_archive_strong_authTRUElog archive security strong auth_log_blocks_during_backupTRUElog block images when changed during backup_log_buffers_corruptFALSEcorrupt redo buffers before write_log_buffers_debugFALSEdebug redo buffers (slows things down)_log_checkpoint_recovery_check0# redo blocks to verify after checkpoint_log_committime_block_cleanoutFALSELog commit-time block cleanout_log_deletion_policymandatoryarchivelog deletion policy for mandatory/all destination_log_event_queues0number of the log writer event queues_log_io_size0automatically initiate log write if this many redo blocks in buffer_log_parallelism_dynamicTRUEEnable dynamic strands_log_parallelism_max1Maximum number of log buffer strands_log_private_mul5Private strand multiplier for log space preallocation_log_private_parallelismFALSENumber of private log buffer strands for zero-copy redo_log_private_parallelism_mul10Active sessions multiplier to deduce number of private strands_log_read_buffers4Number of log read buffers for media recovery_log_simultaneous_copies2number of simultaneous copies into redo buffer(# of copy latches)_log_space_errorsTRUEshould we report space errors to alert log_log_switch_timeout0Maximum number of seconds redos in the current log could span_logout_storm_rate0number of processes that can logout in a second_logout_storm_retrycnt600maximum retry count for logouts_logout_storm_timeout5timeout in centi-seconds for time to wait between retries_longops_enabledTRUElongops stats enabled_low_server_threshold0low server thresholds_ltc_trace0tracing level for load table conventional_master_direct_sends31direct sends for messages from master (DFS)_mav_refresh_consistent_readTRUErefresh materialized views using consistent read snapshot_mav_refresh_double_count_preventedFALSEmaterialized view MAV refreshes avoid double counting_mav_refresh_opt0optimizations during refresh of materialized views_mav_refresh_unionall_tables3# tables for union all expansion during materialized view refresh_max_arch_lns_wait120Maximum wait by ARCH to allow NetServer to complete archival_max_exponential_sleep0max sleep during exponential backoff_max_io_size1048576Maximum I/O size in bytes for sequential file accesses_max_large_io0IORM:max number of large I/O’s to issue_max_lns_shutdown_archival_time30Maximum time spent by LNS to archive last log during shutdown_max_protocol_support10000Max occurrence protocols supported in a process_max_shrink_obj_stats0number of segments for which shrink stats will be maintained_max_sleep_holding_latch4max time to sleep while holding a latch_max_small_io0IORM:max number of small I/O’s to issue_max_spacebg_slaves10maximum space management background slaves_max_spacebg_tasks1000maximum space management background tasks_max_temp_overhead0max tempspc overhead_media_recovery_read_batch128media recovery block read batch_mem_annotation_pr_lev0private memory annotation collection level_mem_annotation_scale1memory annotation pre-allocation scaling_mem_annotation_sh_lev0shared memory annotation collection level_mem_annotation_storeFALSEmemory annotation in-memory store_mem_std_extent_size4096standard extent size for fixed-size-extent heaps_memory_broker_log_stat_entries5memory broker num stat entries_memory_broker_marginal_utility_bc12Marginal Utility threshold pct for bc_memory_broker_marginal_utility_sp7Marginal Utility threshold pct for sp_memory_broker_shrink_heaps15memory broker allow policy to shrink shared pool_memory_broker_shrink_java_heaps900memory broker allow policy to shrink java pool_memory_broker_shrink_streams_pool900memory broker allow policy to shrink streams pool_memory_broker_shrink_timeout60000000memory broker policy to timeout shrink shared/java pool_memory_broker_stat_interval30memory broker statistics gathering interval for auto sga_memory_management_tracing0trace memory management activity_memory_nocancel_defsgareqFALSEdo not cancel deferred sga reqs with auto-memory_memory_sanity_check0partial granule sanity check_messages300message queue resources – dependent on # processes & # buffers_midtier_affinity_clusterwait_threshold100cluster wait threshold to enter affinity_midtier_affinity_goodness_threshold2000goodness gradient threshold to dissolve affinity_midtier_affinity_timeout30000default timeout for midtier affinity processing_minfree_plus0max percentage of block space + minfree before we mark block full_minimal_stats_aggregationTRUEprohibit stats aggregation at compile/partition maintenance time_minimum_blocks_to_shrink0minimum number freeable blocks for shrink to be present_minimum_db_flashback_retention60Minimum flashback retention_minimum_extents_to_shrink1minimum number freeable extents for shrink to be present_minimum_giga_scn0Minimum SCN to start with in 2^30 units_mirror_redo_buffersFALSESave buffers for debugging redo corruptions_mmv_query_rewrite_enabledTRUEallow rewrites with multiple MVs and/or base tables_multi_instance_pmrTRUEforce multi instance or single instance parallel recovery_multi_join_key_table_lookupTRUETRUE iff multi-join-key table lookup prefetch is enabled_multiple_instance_recoveryFALSEuse multiple instances for media recovery_mv_refresh_ana0what percent to analyze after complete/PCT refresh_mv_refresh_costingrulerefresh decision based on cost or on rules_mv_refresh_delta_fraction10delta mv as fractional percentage of size of mv_mv_refresh_eutTRUErefresh materialized views using EUT(partition)-based algorithm_mv_refresh_force_parallel_query0force materialized view refreshes to use parallel query_mv_refresh_new_setup_disabledFALSEmaterialized view MV refresh new setup disabling_mv_refresh_rebuild_percentage10minimum percentage change required in MV to force an indexrebuild_mv_refresh_selectionsTRUEcreate materialized views with selections and fast refresh_mv_refresh_use_statsFALSEpass cardinality hints to refresh queries_mv_refsched_timeincr300000proportionality constant for dop vs. time in MV refresh_mv_rolling_invFALSEcreate/alter mv uses rolling cursor invalidation instead of immediate_mwin_scheduleTRUEEnable/disable Maintenance Window Schedules_nchar_imp_cnvTRUENLS allow Implicit Conversion between CHAR and NCHAR_nchar_imp_convTRUEshould implicit conversion bewteen clob and nclob be allowed_ncmb_readahead_enabled0enable multi-block readahead for an index scan_ncmb_readahead_tracing0turn on multi-block readahead tracing_ncomp_shared_objects_dir
native compilation shared objects dir_nested_loop_fudge100nested loop fudge_nested_mav_fast_oncommit_enabledTRUEnested MAV refresh fast on commit allowed_new_initial_join_ordersTRUEenable initial join orders based on new ordering heuristics_new_sort_cost_estimateTRUEenables the use of new cost estimate for sort_newsort_enabledTRUEcontrols whether new sorts can be used as system sort_newsort_ordered_pct63controls when new sort avoids sorting ordered input_newsort_type0specifies options for the new sort algorithm_nlj_batching_enabled1enable batching of the RHS IO in NLJ_nlj_batching_misses_enabled1enable exceptions for buffer cache misses_no_objectsFALSEno object features are used_no_or_expansionFALSEOR expansion during optimization disabled_no_recovery_through_resetlogsFALSEno recovery through this resetlogs operation_notify_crsFALSEnotify cluster ready services of startup and shutdown_ns_max_flush_wt1Flush wait time for NetServer to flush oustanding writes_ns_max_send_delay15Data Loss Time Bound for NetServer_num_longop_child_latches1number of child latches for long op array_number_cached_attributes10maximum number of cached attributes per instance_object_reuse_bast2if 1 or higher, handle object reuse_object_statisticsTRUEenable the object level statistics collection_object_stats_max_entries3072Maximum number of entries to be tracked per stat_offline_rollback_segments
offline undo segment list_ogms_home
GMS home directory_olap_aggregate_buffer_size1048576OLAP Aggregate max buffer size_olap_aggregate_flags0OLAP Aggregate debug flags_olap_aggregate_function_cache_enabledTRUEOLAP Aggregate function cache enabler_olap_aggregate_function_merge_threshold529OLAP Aggregate function merge threshold_olap_aggregate_max_thread_tuples5000OLAP Aggregate max thread tuples creation_olap_aggregate_min_buffer_size1024OLAP Aggregate min buffer size_olap_aggregate_min_thread_status64OLAP Aggregate minimum cardinality of dimensions for thread_olap_aggregate_multipath_hierFALSEOLAP Aggregate Multi-path Hierarhies enabled_olap_aggregate_statlen_thresh1024OLAP Aggregate status array usage threshold_olap_aggregate_store_probability100OLAP Aggregate function storeback probability_olap_aggregate_work_per_thread1024OLAP Aggregate max work parents_olap_aggregate_worklist_max5000OLAP Aggregate max worklists generated at once_olap_allocate_errorlog_format%8p %8y %8z %e (%n)OLAP Allocate Errorlog Format_olap_allocate_errorlog_headerDim Source Basis %-8d %-8s %-8b Description ——– ——– ——– ———–OLAP Allocate Errorlog Header format_olap_analyze_max10000OLAP DML ANALYZE command max cells to analyze_olap_continuous_trace_fileFALSESpecify TRUE to enable continuous OLAP tracing – otherwise only exceptional events will be logged_olap_dbgoutfile_echo_to_eventlogFALSEOLAP DbgOutfile copy output to event log (tracefile)_olap_dimension_corehash_class1OLAP Dimension In-Core Hash Table Class_olap_dimension_corehash_large50000OLAP Dimension In-Core Hash Table Large Threshold_olap_dimension_corehash_pressure90OLAP Dimension In-Core Hash Table Pressure Threshold_olap_dimension_corehash_size30OLAP Dimension In-Core Hash Table Maximum Memory Use_olap_dimension_corehash_small1000OLAP Dimension In-Core Hash Table Small Threshold_olap_eif_export_lob_size2147483647OLAP EIF Export BLOB size_olap_lmgen_dim_size100Limitmap generator dimension column size_olap_lmgen_meas_size1000Limitmap generator measure column size_olap_object_hash_class2OLAP Object Hash Table Class_olap_page_pool_expand_rate20OLAP Page Pool Expand Rate_olap_page_pool_hi50OLAP Page Pool High Watermark_olap_page_pool_hit_target100OLAP Page Pool Hit Target_olap_page_pool_low262144OLAP Page Pool Low Watermark_olap_page_pool_pressure90OLAP Page Pool Pressure Threshold_olap_page_pool_shrink_rate50OLAP Page Pool Shrink Rate_olap_parallel_update_small_group400OLAP parallel update pagespace by group_olap_parallel_update_small_threshold1000OLAP parallel update threshold for number of small pagespaces_olap_parallel_update_threshold1000OLAP parallel update threshold in pages_olap_poutlog_echo_to_eventlogFALSEOLAP POutLog copy output to event log (tracefile)_olap_sesscache_enabledTRUEOLAP Session Cache knob_olap_sort_buffer_size262144OLAP Sort Buffer Size_olap_statbool_corebits20000000OLAP Status Boolean max incore bits_olap_statbool_threshold8100OLAP Status Boolean CBM threshold_olap_table_function_statisticsFALSESpecify TRUE to output OLAP table function timed statistics trace_olap_wrap_errorsFALSEWrap error messages to OLAP outfile_olapi_history_retentionFALSEenable olapi history retention_olapi_iface_object_history1000enable olapi interface object history collection_olapi_iface_object_history_retentionFALSEenable olapi interface object history retention_olapi_iface_operation_history_retentionFALSEenable olapi interface operation history retention_olapi_interface_operation_history1000enable olapi interface operation history collection_olapi_memory_operation_history1000enable olapi memory alloc/free history collection_olapi_memory_operation_history_pause_at_seqno0enable olapi memory alloc/free history collection pausing_olapi_memory_operation_history_retentionFALSEenable olapi memory operation history retention_olapi_session_history300enable olapi session history collection_olapi_session_history_retentionFALSEenable olapi session history retention_old_connect_by_enabledFALSEenable/disable old connect by_ols_cleanup_taskTRUEClean up unnecessary entries in OLS sessinfo table_oltp_compressionTRUEoltp compression enabled_oltp_compression_gain10oltp compression gain_omfenabledenable/disable OMF_oneside_colstat_for_equijoinsTRUEsanity check on default selectivity for like/range predicate_online_patch_disable_stack_checkFALSEdisable check for function on stack for online patches_optim_adjust_for_part_skewsTRUEadjust stats for skews across partitions_optim_dict_stats_at_db_cr_upgTRUEenable/disable dictionary stats gathering at db create/upgrade_optim_enhance_nnull_detectionTRUETRUE to enable index [fast] full scan more often_optim_new_default_join_selTRUEimproves the way default equijoin selectivity are computed_optim_peek_user_bindsTRUEenable peeking of user binds_optimizer_adaptive_cursor_sharingTRUEoptimizer adaptive cursor sharing_optimizer_adjust_for_nullsTRUEadjust selectivity for null values_optimizer_autostats_jobTRUEenable/disable auto stats collection job_optimizer_aw_join_push_enabledTRUEEnables AW Join Push optimization_optimizer_aw_stats_enabledTRUEEnables statistcs on AW olap_table table function_optimizer_better_inlist_costingALLenable improved costing of index access using in-list(s)_optimizer_block_size8192standard block size used by optimizer_optimizer_cache_statsFALSEcost with cache statistics_optimizer_cartesian_enabledTRUEoptimizer cartesian join enabled_optimizer_cbqt_factor50cost factor for cost-based query transformation_optimizer_cbqt_no_size_restrictionTRUEdisable cost based transformation query size restriction_optimizer_ceil_costTRUECEIL cost in CBO_optimizer_choose_permutation0force the optimizer to use the specified permutation_optimizer_complex_pred_selectivityTRUEenable selectivity estimation for builtin functions_optimizer_compute_index_statsTRUEforce index stats collection on index creation/rebuild_optimizer_connect_by_combine_swTRUEcombine no filtering connect by and start with_optimizer_connect_by_cost_basedTRUEuse cost-based transformation for connect by_optimizer_correct_sq_selectivityTRUEforce correct computation of subquery selectivity_optimizer_cost_based_transformationLINEARenables cost-based query transformation_optimizer_cost_filter_predFALSEenables costing of filter predicates in IO cost model_optimizer_cost_hjsmj_multimatchTRUEadd cost of generating result set when #rows per key > 1_optimizer_cost_modelCHOOSEoptimizer cost model_optimizer_degree0force the optimizer to use the same degree of parallelism_optimizer_dim_subq_join_selTRUEuse join selectivity in choosing star transformation dimensions_optimizer_disable_strans_sanity_checks0disable star transformation sanity checks_optimizer_distinct_eliminationTRUEEliminates redundant SELECT DISTNCT’s_optimizer_dyn_smp_blks32number of blocks for optimizer dynamic sampling_optimizer_enable_density_improvementsTRUEuse improved density computation for selectivity estimation_optimizer_enable_extended_statsTRUEuse extended statistics for selectivity estimation_optimizer_enhanced_filter_pushTRUEpush filters before trying cost-based query transformation_optimizer_extend_jppd_view_typesTRUEjoin pred pushdown on group-by, distinct, semi-/anti-joined view_optimizer_extended_cursor_sharingUDOoptimizer extended cursor sharing_optimizer_extended_cursor_sharing_relSIMPLEoptimizer extended cursor sharing for relational operators_optimizer_extended_stats_usage_control240controls the optimizer usage of extended stats_optimizer_filter_pred_pullupTRUEuse cost-based flter predicate pull up transformation_optimizer_fkr_index_cost_bias10Optimizer index bias over FTS/IFFS under first K rows mode_optimizer_free_transformation_heapTRUEfree transformation subheap after each transformation_optimizer_group_by_placementTRUEconsider group-by placement optimization_optimizer_ignore_hintsFALSEenables the embedded hints to be ignored_optimizer_improve_selectivityTRUEimprove table and partial overlap join selectivity computation_optimizer_invalidation_period18000time window for invalidation of cursors of analyzed objects_optimizer_join_elimination_enabledTRUEoptimizer join elimination enabled_optimizer_join_order_control3controls the optimizer join order search algorithm_optimizer_join_sel_sanity_checkTRUEenable/disable sanity check for multi-column join selectivity_optimizer_max_permutations2000optimizer maximum join permutations per query block_optimizer_min_cache_blocks10set minimum cached blocks_optimizer_mjc_enabledTRUEenable merge join cartesian_optimizer_mode_forceTRUEforce setting of optimizer mode for user recursive SQL also_optimizer_multi_level_push_predTRUEconsider join-predicate pushdown that requires multi-level pushdown to base table_optimizer_multiple_cenv
generate and run plans using several compilation environments_optimizer_native_full_outer_joinFORCEexecute full outer join using native implementaion_optimizer_nested_rollup_for_gset100number of groups above which we use nested rollup exec for gset_optimizer_new_join_card_computationTRUEcompute join cardinality using non-rounded input values_optimizer_null_aware_antijoinTRUEnull-aware antijoin parameter_optimizer_or_expansionDEPTHcontrol or expansion approach used_optimizer_or_expansion_subheapTRUEUse subheap for optimizer or-expansion_optimizer_order_by_elimination_enabledTRUEEliminates order bys from views before query transformation_optimizer_outer_to_anti_enabledTRUEEnable transformation of outer-join to anti-join if possible_optimizer_percent_parallel101optimizer percent parallel_optimizer_push_down_distinct0push down distinct from query block to table_optimizer_push_pred_cost_basedTRUEuse cost-based query transformation for push pred optimization_optimizer_random_plan0optimizer seed value for random plans_optimizer_reuse_cost_annotationsTRUEreuse cost annotations during cost-based query transformation_optimizer_rownum_bind_default10Default value to use for rownum bind_optimizer_rownum_pred_based_fkrTRUEenable the use of first K rows due to rownum predicate_optimizer_save_statsTRUEenable/disable saving old versions of optimizer stats_optimizer_search_limit5optimizer search limit_optimizer_self_induced_cache_costFALSEaccount for self-induced caching_optimizer_skip_scan_enabledTRUEenable/disable index skip scan_optimizer_skip_scan_guessFALSEconsider index skip scan for predicates with guessed selectivity_optimizer_sortmerge_join_enabledTRUEenable/disable sort-merge join method_optimizer_sortmerge_join_inequalityTRUEenable/disable sort-merge join using inequality predicates_optimizer_squ_bottomupTRUEenables unnesting of subquery in a bottom-up manner_optimizer_star_tran_in_with_clauseTRUEenable/disable star transformation in with clause queries_optimizer_star_trans_min_cost0optimizer star transformation minimum cost_optimizer_star_trans_min_ratio0optimizer star transformation minimum ratio_optimizer_starplan_enabledTRUEoptimizer star plan enabled_optimizer_system_stats_usageTRUEsystem statistics usage_optimizer_tracenoneoptimizer trace parameter_optimizer_transitivity_retainTRUEretain equi-join pred upon transitive equality pred generation_optimizer_undo_changesFALSEundo changes to query optimizer_optimizer_undo_cost_change11.1.0.6optimizer undo cost change_optimizer_use_subheapTRUEEnables physical optimizer subheap_or_expand_nvl_predicateTRUEenable OR expanded plan for NVL/DECODE predicate_oradbg_pathname
path of oradbg script_oradebug_forceFALSEforce target processes to execute oradebug commands?_ordered_nested_loopTRUEenable ordered nested loop costing_ordered_semijoinTRUEenable ordered semi-join subquery_orph_cln_interval1200qmon periodic interval for removed subscriber messages cleanup_os_sched_high_priority1OS high priority level_other_wait_event_exclusion
exclude event names from _other_wait_threshold calculations_other_wait_threshold0threshold wait percentage for event wait class Other_outline_bitmap_treeTRUEBITMAP_TREE hint enabled in outline_parallel_adaptive_max_users2maximum number of users running with default DOP_parallel_broadcast_enabledTRUEenable broadcasting of small inputs to hash and sort merge joins_parallel_default_max_instances1default maximum number of instances for parallel query_parallel_execution_message_alignFALSEAlignment of PX buffers to OS page boundary_parallel_fake_class_pct0fake db-scheduler percent used for testing_parallel_fixwrite_bucket1000Number of buckets for each round of fix write_parallel_load_bal_unit0number of threads to allocate per instance_parallel_load_balancingTRUEparallel execution load balanced slave allocation_parallel_min_message_pool206592minimum size of shared pool memory to reserve for pq servers_parallel_policyMANUALpolicy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)_parallel_recovery_stopat32767stop at -position- to step through SMON_parallel_replay_msg_limit4000Number of messages for each round of parallel replay_parallel_server_idle_time30000idle time before parallel query server dies (in 1/100 sec)_parallel_server_sleep_time10sleep time between dequeue timeouts (in 1/100ths)_parallel_slave_acquisition_wait1time(in seconds) to wait before retrying slave acquisition_parallel_time_threshold10threshold above which a plan is a candidate for parallelization (in seconds)_parallel_time_unit10unit of work used to derive the degree of parallelism (in seconds)_parallel_txn_globalFALSEenable parallel_txn hint with updates and deletes_parallelism_cost_fudge_factor350set the parallelism cost fudge factor_parameter_table_block_size2048parameter table block size_partial_pwise_join_enabledTRUEenable partial partition-wise join when TRUE_partition_view_enabledTRUEenable/disable partitioned views_passwordfile_enqueue_timeout900password file enqueue timeout in seconds_pct_refresh_double_count_preventedTRUEmaterialized view PCT refreshes avoid double counting_pdml_gim_sampling5000control separation of global index maintenance for PDML_pdml_gim_staggeredFALSEslaves start on different index when doing index maint_pdml_slaves_diff_partTRUEslaves start on different partition when doing index maint_percent_flashback_buf_partial_full50Percent of flashback buffer filled to be considered partial full_pga_large_extent_size1048576PGA large extent size_pga_max_size209715200Maximum size of the PGA memory for one process_ping_level3fusion ping level_pivot_implementation_methodCHOOSEpivot implementation method_pkt_enableFALSEenable progressive kill test_pkt_pmon_interval50PMON process clean-up interval (cs)_pkt_startFALSEstart progressive kill test instrumention_plan_outline_dataTRUEexplain plan outline data enabled_plan_verify_improvement_margin150Performance improvement criterion for evolving plan baselines_plan_verify_local_time_limit0Local time limit to use for an individual plan verification_plsql_anon_block_code_typeINTERPRETEDPL/SQL anonymous block code-type_plsql_cache_enableTRUEPL/SQL Function Cache Enabled_plsql_dump_buffer_events
conditions upon which the PL/SQL circular buffer is dumped_plsql_minimum_cache_hit_percent20plsql minimum cache hit percentage required to keep caching active_plsql_nvl_optimizeFALSEPL/SQL NVL optimize_pmon_load_constants300,192,64,3,10,10,0,0server load balancing constants (S,P,D,I,L,C,M)_pre_rewrite_push_predTRUEpush predicates into views before rewrite_precompute_gid_valuesTRUEprecompute gid values and copy them before returning a row_pred_move_aroundTRUEenables predicate move-around_predicate_elimination_enabledTRUEallow predicate elimination if set to TRUE_prescommFALSEpresume commit of IMU transactions_print_refresh_schedulefalseenable dbms_output of materialized view refresh schedule_private_memory_address
Start address of large extent memory segment_project_view_columnsTRUEenable projecting out unreferenced columns of a view_projection_pushdownTRUEprojection pushdown_projection_pushdown_debug0level for projection pushdown debugging_prop_old_enabledFALSEShift to pre 11g propagation behaviour_protect_frame_heapsFALSEProtect cursor frame heaps_push_join_predicateTRUEenable pushing join predicate inside a view_push_join_union_viewTRUEenable pushing join predicate inside a union all view_push_join_union_view2TRUEenable pushing join predicate inside a union view_px_async_getgranuleFALSEasynchronous get granule in the slave_px_bind_peek_sharingTRUEenables sharing of px cursors that were built using bind peeking_px_broadcast_fudge_factor100set the tq broadcasting fudge factor percentage_px_buffer_ttl30ttl for px mesg buffers in seconds_px_compilation_debug0debug level for parallel compilation_px_compilation_trace0tracing level for parallel compilation_px_dump_12805_sourceTRUEenables or disables tracing of 12805 signal source_px_dynamic_optTRUEturn off/on restartable qerpx dynamic optimization_px_dynamic_sample_size50num of samples for restartable qerpx dynamic optimization_px_execution_services_enabledTRUEenable service-based constraint of px slave allocation_px_granule_size100000default size of a rowid range granule (in KB)_px_index_sampling200parallel query sampling for index create (100000 = 100%)_px_io_process_bandwidth200IO process bandwidth in MB/sec for computing DOP_px_io_system_bandwidth0total IO system bandwidth in MB/sec for computing DOP_px_kxib_tracing0turn on kxib tracing_px_load_publish_interval200interval at which LMON will check whether to publish PX load_px_loc_msg_cost1000CPU cost to send a PX message via shared memory_px_max_granules_per_slave100maximum number of rowid range granules to generate per slave_px_min_granules_per_slave13minimum number of rowid range granules to generate per slave_px_minus_intersectTRUEenables pq for minus/interect operators_px_net_msg_cost10000CPU cost to send a PX message over the internconnect_px_no_granule_sortFALSEprevent parallel partition granules to be sorted on size_px_no_stealingFALSEprevent parallel granule stealing in shared nothing environment_px_nss_planbTRUEenables or disables NSS Plan B reparse with outline_px_proc_constrainTRUEreduce parallel_max_servers if greater than (processes – fudge)_px_pwg_enabledTRUEparallel partition wise group by enabled_px_rownum_pdTRUEturn off/on parallel rownum pushdown optimization_px_send_timeout300IPC message send timeout value in seconds_px_slaves_share_cursors0slaves share cursors with QC_px_tracenonepx trace parameter_px_ual_serial_inputTRUEenables new pq for UNION operators_px_xtgranule_size10000default size of a external table granule (in KB)_qa_control0Oracle internal parameter to control QA_qa_lrg_type0Oracle internal parameter to specify QA lrg type_query_cost_rewriteTRUEperform the cost based rewrite with materialized views_query_execution_cache_max_size65536max size of query execution cache_query_mmvrewrite_maxcmaps20query mmv rewrite maximum number of cmaps per dmap in query disjunct_query_mmvrewrite_maxdmaps10query mmv rewrite maximum number of dmaps per query disjunct_query_mmvrewrite_maxinlists5query mmv rewrite maximum number of in-lists per disjunct_query_mmvrewrite_maxintervals5query mmv rewrite maximum number of intervals per disjunct_query_mmvrewrite_maxmergedcmaps50query mmv rewrite maximum number of merged cmaps_query_mmvrewrite_maxpreds10query mmv rewrite maximum number of predicates per disjunct_query_mmvrewrite_maxqryinlistvals500query mmv rewrite maximum number of query in-list values_query_mmvrewrite_maxregperm512query mmv rewrite maximum number of region permutations_query_rewrite_1TRUEperform query rewrite before&after or only before view merging_query_rewrite_2TRUEperform query rewrite before&after or only after view merging_query_rewrite_drjTRUEmv rewrite and drop redundant joins_query_rewrite_expressionTRUErewrite with cannonical form for expressions_query_rewrite_fpcTRUEmv rewrite fresh partition containment_query_rewrite_fudge90cost based query rewrite with MVs fudge factor_query_rewrite_jgmigrateTRUEmv rewrite with jg migration_query_rewrite_maxdisjunct257query rewrite max disjuncts_query_rewrite_or_errorFALSEallow query rewrite, if referenced tables are not dataless_query_rewrite_setopgrw_enableTRUEperform general rewrite using set operator summaries_query_rewrite_vop_cleanupTRUEprune frocol chain before rewrite after view-merging_rcfg_parallel_fixwriteTRUEif TRUE enables parallel fixwrite at reconfiguration_rcfg_parallel_replayTRUEif TRUE enables parallel replay and cleanup at reconfiguration_rcfg_parallel_verifyTRUEif TRUE enables parallel verify at reconfiguration_rdbms_compatibility10.1default RDBMS compatibility level_rdbms_internal_fplib_enabledFALSEenable SAGE FPLIB filtering within rdbms_rdbms_internal_fplib_raise_errorsFALSEenable reraising of any exceptions in SAGE FPLIB_readable_standby_modeSLFLUSHreadable standby mode_readable_standby_sync_timeout10readable standby query scn sync timeout_real_time_apply_sim0Simulation value with real time apply_realfree_heap_max_size32768minimum max total heap size, in Kbytes_realfree_heap_mode0mode flags for real-free heap_realfree_heap_pagesize_hint65536hint for real-free page size in bytes_recoverable_recovery_batch_percent50Recoverable recovery batch size (percentage of buffer cache)_recovery_assertsFALSEif TRUE, enable expensive integrity checks_recovery_percentage50recovery buffer cache percentage_recovery_verify_writesFALSEenable thread recovery write verify_recursive_imu_transactionsFALSErecursive transactions may be IMU_redo_compatibility_checkFALSEgeneral and redo/undo compatibility sanity check_redo_read_from_memoryTRUEEnable reading redo from memory_redo_transport_compress_allFALSEIs ASYNC LNS compression allowed?_release_insert_threshold5maximum number of unusable blocks to unlink from freelist_reliable_block_sendsFALSEif TRUE, block sends across interconnect are reliable_remove_aggr_subqueryTRUEenables removal of subsumed aggregated subquery_replace_virtual_columnsTRUEreplace expressions with virtual columns_resource_manager_always_offFALSEdisable the resource manager always_resource_manager_always_onTRUEenable the resource manager always_restore_spfile
restore spfile to this location_result_cache_auto_execution_threshold1result cache auto execution threshold_result_cache_auto_size_threshold100result cache auto max size allowed_result_cache_auto_time_distance300result cache auto time distance_result_cache_auto_time_threshold1000result cache auto time threshold_result_cache_block_size1024result cache block size_result_cache_timeout60maximum time (sec) a session waits for a result_reuse_index_loop5number of blocks being examine for index block reuse_right_outer_hash_enableTRUERight Outer/Semi/Anti Hash Enabled_rman_io_priority3priority at which rman backup i/o’s are done_rman_restore_through_linkFALSERMAN restore through link_rollback_segment_count0number of undo segments_rollback_segment_initial1starting undo segment number_rollback_stopat0stop at -position to step rollback_row_cache_cursors20number of cached cursors for row cache management_row_crTRUEenable row cr for all sql_row_lockingalwaysrow-locking_row_shipping_explainFALSEenable row shipping explain plan support_row_shipping_threshold80row shipping column selection threshold_rowsource_execution_statisticsFALSEif TRUE, Oracle will collect rowsource statistics_rowsource_profiling_statisticsTRUEif TRUE, Oracle will capture active row sources in v$active_session_history_rowsource_statistics_sampfreq128frequency of rowsource statistic sampling (must be a power of 2)_rowsrc_trace_level0Row source tree tracing level_rtc_infeasible_threshold10Redo Transport Compression infeasible threshold_sage_enabled1enable real SAGE functionality_sage_fcreTRUEAllow optimized file creation path for SAGE_sample_rows_per_block4number of rows per block used for sampling IO optimization_scatter_gcs_resourcesFALSEif TRUE, gcs resources are scattered uniformly across sub pools_scatter_gcs_shadowsFALSEif TRUE, gcs shadows are scattered uniformly across sub pools_scn_wait_interface_max_backoff_time_secs600max exponential backoff time for scn wait interface in kta_scn_wait_interface_max_timeout_secs2147483647max timeout for scn wait interface in kta_sdiag_crashNONEsql diag crash_sec_enable_test_rpcsFALSEWhether to enable the test RPCs_second_spare_parameter
second spare parameter – integer_securefile_timersFALSEcollect kdlu timers and accumulate per layers_selectivity_for_srf_enabledFALSEenable/disable selectivity for storage reduction factor_selfjoin_mv_duplicatesTRUEcontrol rewrite self-join algorithm_selftune_checkpoint_write_pct3Percentage of total physical i/os for self-tune ckpt_selftune_checkpointing_lag300Self-tune checkpointing lag the tail of the redo log_send_ast_to_foregroundTRUEif TRUE, send ast message to foreground_send_close_with_blockTRUEif TRUE, send close with block even with direct sends_send_requests_to_piTRUEif TRUE, try to send CR requests to PI buffers_serial_direct_readFALSEenable direct read in serial_serial_recoveryFALSEforce serial recovery or parallel recovery_serializableFALSEserializable_session_cached_instantiations60Number of pl/sql instantiations to cache in a session._session_context_size10000session app context size_session_idle_bit_latches0one latch per session or a latch per group of sessions_session_idle_check_interval60Resource Manager session idle limit check interval in seconds_session_kept_cursor_pins0Number of cursors pins to keep in a session_session_wait_history10enable session wait history collection_seventh_spare_parameter
seventh spare parameter – string list_sga_clear_dumpFALSEAllow dumping encrypted blocks in clear for debugging_sga_early_trace0sga early trace event_sga_lockingnonesga granule locking state_shared_io_pool_buf_size1048576Shared IO pool buffer size_shared_io_pool_debug_trc0trace kcbi debug info to tracefile_shared_io_pool_size0Size of shared IO pool_shared_io_set_valueFALSEshared io pool size set internal value – overwrite zero user size_shared_iop_max_size536870912maximum shared io pool size_shared_pool_max_size0shared pool maximum size when auto SGA enabled_shared_pool_minsize_onFALSEshared pool minimum size when auto SGA enabled_shared_pool_reserved_min_alloc4400minimum allocation size in bytes for reserved area of shared pool_shared_pool_reserved_pct5percentage memory of the shared pool allocated for the reserved area_shared_server_load_balance0shared server load balance_shared_server_num_queues1number of shared server common queues_short_stack_timeout_ms30000short stack timeout in ms_shrunk_aggs_disable_threshold60percentage of exceptions at which to switch to full length aggs_shrunk_aggs_enabledTRUEenable use of variable sized buffers for non-distinct aggregates_side_channel_batch_size200number of messages to batch in a side channel message (DFS)_side_channel_batch_timeout6timeout before shipping out the batched side channelmessages in seconds_side_channel_batch_timeout_ms500timeout before shipping out the batched side channelmessages in milliseconds_simple_view_mergingTRUEcontrol simple view merging performed by the optimizer_simulate_mem_transferFALSEsimulate auto memory sga/pga transfers_simulator_bucket_mindelta8192LRU bucket minimum delta_simulator_internal_bound10simulator internal bound percent_simulator_lru_rebalance_sizthr5LRU list rebalance threshold (size)_simulator_lru_rebalance_thresh10240LRU list rebalance threshold (count)_simulator_lru_scan_count8LRU scan count_simulator_pin_inval_maxcnt16maximum count of invalid chunks on pin list_simulator_reserved_heap_count4096simulator reserved heap count_simulator_reserved_obj_count1024simulator reserved object count_simulator_sampling_factor2sampling factor for the simulator_simulator_upper_bound_multiple2upper bound multiple of pool size_single_processFALSErun without detached processes_siop_flashback_scandepth20Shared IO pool flashback io completion scan depth_sixth_spare_parameter
sixth spare parameter – string list_skgxp_reaping1000tune skgxp OSD reaping limit_skgxp_udp_ach_reaping_time120time in minutes before idle ach’s are reaped_skgxp_udp_ack_delay0Enables delayed acks_skgxp_udp_enable_dynamic_credit_mgmt0Enables dynamic credit management_skgxp_udp_hiwat_warn1000ach hiwat mark warning interval_skgxp_udp_interface_detection_time_secs60time in seconds between interface detection checks_skgxp_udp_keep_alive_ping_timer_secs300connection idle time in seconds before keep alive is initiated. min: 30 sec max: 1800 sec default: 300 sec_skgxp_udp_lmp_mtusize0MTU size for UDP LMP testing_skgxp_udp_lmp_onFALSEenable UDP long message protection_skgxp_udp_timed_wait_buffering1024diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd_skgxp_udp_timed_wait_seconds5time in seconds before timed wait is invoked_skgxp_udp_use_tcbTRUEdisable use of high speek timer_skip_assume_msgTRUEif TRUE, skip assume message for consigns at the master_slave_mapping_enabledTRUEenable slave mapping when TRUE_slave_mapping_group_size0force the number of slave group in a slave mapper_small_table_threshold541threshold level of table size for direct reads_smm_advice_enabledTRUEif TRUE, enable v$pga_advice_smm_advice_log_size0overwrites default size of the PGA advice workarea history log_smm_auto_cost_enabledTRUEif TRUE, use the AUTO size policy cost functions_smm_auto_max_io_size248Maximum IO size (in KB) used by sort/hash-join in auto mode_smm_auto_min_io_size56Minimum IO size (in KB) used by sort/hash-join in auto mode_smm_bound0overwrites memory manager automatically computed bound_smm_control0provides controls on the memory manager_smm_freeable_retain5120value in KB of the instance freeable PGA memory to retain_smm_isort_cap102400maximum work area for insertion sort(v1)_smm_max_size40960maximum work area size in auto mode (serial)_smm_min_size204minimum work area size in auto mode_smm_px_max_size102400maximum work area size in auto mode (global)_smm_retain_size0work area retain size in SGA for shared server sessions (0 for AUTO)_smm_trace0Turn on/off tracing for SQL memory manager_smon_internal_errlimit100limit of SMON internal errors_smon_undo_seg_rescan_limit10limit of SMON continous undo segments re-scan_smu_debug_mode0- set debug event for testing SMU operations_smu_error_simulation_site0site ID of error simulation in KTU code_smu_error_simulation_type0error type for error simulation in KTU code_smu_timeouts
comma-separated *AND double-quoted* list of AUM timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl_sort_elimination_cost_ratio0cost ratio for sort eimination under first_rows mode_sort_multiblock_read_count2multi-block read count for sort_space_align_size1048576space align size_spin_count1Amount to spin waiting for a latch_spr_max_rules10000maximum number of rules in sql spreadsheet_spr_push_pred_refsprTRUEpush predicates through reference spreadsheet_spr_use_AW_ASTRUEenable AW for hash table in spreadsheet_spr_use_hash_tableFALSEuse hash table for spreadsheet_sql_analyze_parse_model2SQL Analyze Parse Model control parameter_sql_connect_capability_override0SQL Connect Capability Table Override_sql_connect_capability_table
SQL Connect Capability Table (testing only)_sql_hash_debug0Hash value of the SQL statement to debug_sql_model_unfold_forloopsRUN_TIMEspecifies compile-time unfolding of sql model forloops_sql_plan_baseline_capture_on_1_execFALSEWith auto-capture on, create new SQL plan baseline on first exec_sqlexec_progression_cost1000sql execution progression monitoring cost threshold_sqlmon_max_plan20Maximum number of plans entry that can be monitored. Defaults to 20 per CPU_sqlmon_max_planlines300Number of plan lines beyond which a plan cannot be monitored_sqlmon_threshold5CPU/IO time threshold before a statement is monitored. 0 is disabled_sqltune_category_parsedDEFAULTParsed category qualifier for applying hintsets_srvntfn_job_deq_timeout60srvntfn job deq timeout_srvntfn_jobsubmit_interval3srvntfn job submit interval_srvntfn_max_concurrent_jobs20srvntfn max concurrent jobs_srvntfn_q_msgcount50srvntfn q msg count for job exit_srvntfn_q_msgcount_inc100srvntfn q msg count increase for job submit_sscr_dir
Session State Capture and Restore DIRectory object_sscr_osdir
Session State Capture and Restore OS DIRectory_sta_control0SQL Tuning Advisory control parameter_stack_guard_level0stack guard level_static_backgrounds
static backgrounds_statistics_based_srf_enabledTRUEenable/disable the use of statistics for storage reduction factor_step_down_limit_in_pct1step down limit in percentage_stn_trace0SQL tracing parameter_storage_predicate_access_predicate0put storage predicate into access predicate in explain plan_streams_pool_max_size0streams pool maximum size when auto SGA enabled_subquery_pruning_cost_factor20subquery pruning cost factor_subquery_pruning_enabledTRUEenable the use of subquery predicates to perform pruning_subquery_pruning_mv_enabledFALSEenable the use of subquery predicates with MVs to perform pruning_subquery_pruning_reduction50subquery pruning reduction factor_swrf_metric_frequent_modeFALSEEnable/disable SWRF Metric Frequent Mode Collection_swrf_mmon_dbfusTRUEEnable/disable SWRF MMON DB Feature Usage_swrf_mmon_flushTRUEEnable/disable SWRF MMON FLushing_swrf_mmon_metricsTRUEEnable/disable SWRF MMON Metrics Collection_swrf_on_disk_enabledTRUEParameter to enable/disable SWRF_swrf_test_action0test action parameter for SWRF_swrf_test_dbfusFALSEEnable/disable DB Feature Usage Testing_synonym_repoint_tracingFALSEwhether to trace metadata comparisons for synonym repointing_sysaux_test_param1test parameter for SYSAUX_system_index_caching0optimizer percent system index caching_system_trig_enabledTRUEare system triggers enabled_ta_lns_wait_for_arch_log20LNS Wait time for arhcived version of online log_table_lookup_prefetch_size40table lookup prefetch vector size_table_lookup_prefetch_thresh2table lookup prefetch threshold_table_scan_cost_plus_oneTRUEbump estimated full table scan and index ffs cost by one_target_rba_max_lag_percentage90target rba max log lag percentage_tdb_debug_mode16set debug mode for testing transportable database_temp_tran_block_threshold100number of blocks for a dimension before we temp transform_temp_tran_cacheTRUEdetermines if temp table is created with cache option_test_ksusigskip5test the function ksusigskip_test_param_125test parmeter 1 – integer_test_param_2
test parameter 2 – string_test_param_3
test parameter 3 – string_test_param_4
test parameter 4 – string list_test_param_525test parmeter 5 – deprecated integer_test_param_60test parmeter 6 – size (ub8)_test_spacebg0test space management background task_third_spare_parameter
third spare parameter – integer_threshold_alerts_enable1if 1, issue threshold-based alerts_timemodel_collectionTRUEenable timemodel collection_timeout_actions_enabledTRUEenables or disables KSU timeout actions_timer_precision20VKTM sleep time in milli-sec_total_large_extent_memory0Total memory for allocating large extents_tq_dump_period0time period for duping of TQ statistics (s)_trace_buffer_wait_timeouts0trace buffer busy wait timeouts_trace_buffersALL:256trace buffer sizes per process_trace_dump_all_procsFALSEif TRUE on error buckets of all processes will be dumped to the current trace file_trace_dump_client_bucketsTRUEif TRUE dump client (ie. non-kst) buckets_trace_dump_cur_proc_onlyFALSEif TRUE on error just dump our process bucket_trace_dump_static_onlyFALSEif TRUE filter trace dumps to always loaded dlls_trace_events
trace events enabled at startup_trace_files_publicFALSECreate publicly accessible trace files_trace_kqlidpFALSEtrace kqlidp0 operation_trace_navigation_scopeglobalenabling trace navigation linking_trace_pin_time0trace how long a current pin is held_trace_pool_size
trace pool size in bytes_trace_processesALLenable KST tracing in process_trace_virtual_columnsFALSEtrace virtual columns exprs_transaction_auditingTRUEtransaction auditing records generated in the redo log_transaction_recovery_servers0max number of parallel recovery slaves that may be used_truncate_optimization_enabledTRUEdo truncate optimization if set to TRUE_tsenc_tracing0Enable TS encryption tracing_tsm_connect_string
TSM test connect string_tsm_disable_auto_cleanup1Disable TSM auto cleanup actions_tts_allow_charset_mismatchFALSEallow plugging in a tablespace with an incompatible character set_two_passTRUEenable two-pass thread recovery_two_pass_reverse_polish_enabledTRUEuses two-pass reverse polish alg. to generate canonical forms_uga_cga_large_extent_size262144UGA/CGA large extent size_ultrafast_latch_statisticsTRUEmaintain fast-path statistics for ultrafast latches_undo_autotuneTRUEenable auto tuning of undo_retention_undo_block_compressionTRUEenable undo block compression_undo_debug_mode0debug flag for undo related operations_undo_debug_usage0invoke undo usage functions for testing_union_rewrite_for_gsYES_GSET_MVSexpand queries with GSets into UNIONs for rewrite_unnest_subqueryTRUEenables unnesting of correlated subqueries_unused_block_compressionTRUEenable unused block compression_update_datafile_headers_with_space_informationFALSEuser requested update of datafile headers of locally managed datafiles with space information_use_best_fitFALSEuse best fit to allocate space_use_column_stats_for_functionTRUEenable the use of column statistics for DDP functions_use_ismTRUEEnable Shared Page Tables – ISM_use_ism_for_pgaTRUEUse ISM for allocating large extents_use_nosegment_indexesFALSEuse nosegment indexes in explain plan_use_realfree_heapTRUEuse real-free based allocator for PGA memory_use_seq_process_cacheTRUEwhether to use process local seq cache_use_vector_postTRUEuse vector post_use_zero_copy_ioTRUEShould network vector IO interface be used for data transfer_validate_flashback_databaseFALSEScan database to validate result of flashback database_vendor_lib_loc
Vendor library search root directory_verify_flashback_redoTRUEVerify that the redo logs needed for flashback are available_verify_undo_quotaFALSETRUE – verify consistency of undo quota statistics_very_large_partitioned_table1024very_large_partitioned_table_virtual_column_overload_allowedTRUEoverload virtual columns expression_wait_breakup_threshold_csecs600Wait breakup threshold (in centiseconds)_wait_breakup_time_csecs300Wait breakup time (in centiseconds)_wait_for_syncTRUEwait for sync on commit MUST BE ALWAYS TRUE_walk_insert_threshold0maximum number of unusable blocks to walk across freelist_watchpoint_onFALSEis the watchpointing feature turned on?_wcr_control0Oracle internal test WCR parameter used ONLY for testing!_windowfunc_optimization_settings0settings for window function optimizations_with_subqueryOPTIMIZERWITH subquery transformation_write_clones3write clones flag_xpl_peeked_binds_log_size8192maximum bytes for logging peeked bind values for V$SQL_PLAN (0 = OFF)_xpl_trace0Explain Plan tracing parameter_xsolapi_auto_materialization_bound20OLAP API lower bound for auto materialization._xsolapi_auto_materialization_typePRED_AND_RCOLAP API behavior for auto materialization_xsolapi_build_traceFALSEOLAP API output build info to trace file_xsolapi_debug_outputSUPPRESSOLAP API debug output disposition_xsolapi_densify_cubesTABULAROLAP API cube densification_xsolapi_dimension_group_creationOVERFETCHOLAP API symmetric overfetch_xsolapi_dml_traceFALSEOLAP API output dml commands and expressions to trace file_xsolapi_fetch_typePARTIALOLAP API fetch type_xsolapi_fix_vptrsFALSEOLAP API Enable vptr fixing logic in shared server mode_xsolapi_generate_with_clauseFALSEOLAP API generates WITH clause?_xsolapi_hierarchy_value_typeuniqueOLAP API hierarchy value type_xsolapi_load_at_process_startNEVERWhen to load OLAP API library at server process start_xsolapi_materialization_rowcache_min_rows_for_use1OLAP API min number of rows required to use rowcache in query materialization_xsolapi_materialize_sourcesTRUEOLAP API Enable source materialization_xsolapi_metadata_reader_mode11_ONLYOLAP API metadata reader mode_xsolapi_odbo_modeFALSEOLAP API uses ODBO mode?_xsolapi_opt_aw_positionTRUEOLAP API enables AW position and count optimization?_xsolapi_optimize_suppressionTRUEOLAP API optimizes suppressions?_xsolapi_precompute_subqueryTRUEOLAP API precomputes subqueries?_xsolapi_remove_columns_for_materializationTRUEOLAP API removes columns for materialization?_xsolapi_set_nlsTRUEOLAP API sets NLS?_xsolapi_share_executorsTRUEOLAP API share executors?_xsolapi_source_traceFALSEOLAP API output Source definitions to trace file_xsolapi_sql_all_multi_join_non_base_hints
OLAP API multi-join non-base hints_xsolapi_sql_all_non_base_hints
OLAP API non-base hints_xsolapi_sql_auto_dimension_hintsFALSEOLAP API enable automatic dimension hints_xsolapi_sql_auto_measure_hintsTRUEOLAP API enable automatic measure hints_xsolapi_sql_dimension_hints
OLAP API dimension hints_xsolapi_sql_enable_aw_joinTRUEOLAP API enables AW join?_xsolapi_sql_enable_aw_qdr_mergeTRUEOLAP API enables AW QDR merge?_xsolapi_sql_hints
OLAP API generic hints_xsolapi_sql_measure_hints
OLAP API measure hints_xsolapi_sql_minus_threshold1000OLAP API SQL MINUS threshold_xsolapi_sql_optimizeTRUEOLAP API enable optimization_xsolapi_sql_prepare_stmt_cache_size16OLAP API prepare statement cache size_xsolapi_sql_remove_columnsTRUEOLAP API enable remove unused columns optimizations_xsolapi_sql_result_set_cache_size32OLAP API result set cache size_xsolapi_sql_symmetric_predicateTRUEOLAP API enable symmetric predicate for dimension groups_xsolapi_sql_top_dimension_hints
OLAP API top dimension hints_xsolapi_sql_top_measure_hints
OLAP API top measure hints_xsolapi_sql_use_bind_variablesTRUEOLAP API enable bind variables optimization_xsolapi_stringify_order_levelsFALSEOLAP API stringifies order levels?_xsolapi_support_mtmFALSEOLAP API MTM mapping classes supported?_xsolapi_suppression_aw_mask_threshold1000OLAP API suppression AW mask threshold_xsolapi_suppression_chunk_size4000OLAP API suppression chunk size_xsolapi_use_modelsTRUEOLAP API uses models?_xsolapi_use_olap_dmlTRUEOLAP API uses OLAP DML?_xsolapi_use_olap_dml_for_rankTRUEOLAP API uses OLAP DML for rank?_xt_coveragenoneexternal tables code coverage parameter_xt_tracenoneexternal tables trace parameter_xtbuffer_size0buffer size in KB needed for populate/query operation_xtts_allow_pre10FALSEallow cross platform for pre10 compatible tablespace_xtts_set_platform_infoFALSEset cross platform info during file header read_yield_check_interval100000interval to check whether actses should yield