Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 11.1 Unsupported Parameters

In Oracle 10.2 there were 1127 unsupported parameters; in Oracle 11.1 there are 1631 unsupported parameters

The following table shows the 549 unsupported parameters that were added in Oracle 11.1

Name
__oracle_base
__pga_aggregate_target
__sga_target
__shared_io_pool_size
_add_col_optim_enabled
_allow_drop_snapshot_standby_grsp
_allow_sage_attr
_arch_corrupted_redo_log
_ash_min_mmnl_dump
_asm_compatibility
_asm_dbmsdg_nohdrchk
_asm_kfioevent
_asm_repairquantum
_asm_runtime_capability_volume_support
_asm_skip_resize_check
_async_ts_threshold
_auto_assign_cg_for_sessions
_automatic_maintenance_test
_automemory_broker_interval
_autotask_max_window
_autotask_min_window
_autotune_gtx_idle_time
_autotune_gtx_interval
_autotune_gtx_threshold
_aw_row_source_enabled
_backup_encrypt_opt_mode
_backup_kgc_memlevel
_backup_kgc_perflevel
_backup_kgc_scheme
_backup_kgc_windowbits
_backup_ksfq_bufcnt_max
_blocking_sess_graph_cache_size
_bloom_predicate_enabled
_bloom_pruning_enabled
_bloom_vector_elements
_bsln_adaptive_thresholds_enabled
_buffered_publisher_flow_control_threshold
_capture_buffer_size
_capture_publisher_flow_control_threshold
_case_sensitive_logon
_cgs_tickets
_check_block_new_invariant_for_flashback
_client_result_cache_bypass
_clusterwide_global_transactions
_compression_above_cache
_compression_advisor
_compression_chain
_controlfile_enqueue_holding_time
_cp_num_hash_latches
_cursor_features_enabled
_cvw_enable_weak_checking
_db_block_bad_write_check
_db_block_corruption_recovery_threshold
_db_block_header_guard_level
_db_block_prefetch_fast_longjumps_enabled
_db_block_prefetch_override
_db_block_prefetch_private_cache_enabled
_db_block_prefetch_skip_reading_enabled
_db_block_vlm_check
_db_block_vlm_leak_threshold
_db_blocks_per_hash_latch
_db_disable_temp_encryption
_db_noarch_disble_optim
_db_num_evict_waitevents
_db_required_percent_fairshare_usage
_db_writer_nomemcopy_coalesce
_dbms_sql_security_level
_dde_flood_control_init
_deadlock_diagnostic_level
_deadlock_resolution_incidents_enabled
_deadlock_resolution_level
_deadlock_resolution_min_wait_timeout_secs
_deadlock_resolution_signal_process_thresh_secs
_defer_log_boundary_ckpt
_defer_log_count
_desired_readmem_rate
_diag_adr_auto_purge
_diag_adr_enabled
_diag_adr_test_param
_diag_backward_compat
_diag_cc_enabled
_diag_conf_cap_enabled
_diag_dde_async_age_limit
_diag_dde_async_cputime_limit
_diag_dde_async_mode
_diag_dde_async_msg_capacity
_diag_dde_async_msgs
_diag_dde_async_process_rate
_diag_dde_async_runtime_limit
_diag_dde_async_slaves
_diag_dde_enabled
_diag_dde_fc_enabled
_diag_dde_fc_implicit_time
_diag_dde_fc_macro_time
_diag_dde_inc_proc_delay
_diag_dump_timeout
_diag_hm_rc_enabled
_diag_hm_tc_enabled
_diag_uts_control
_direct_path_insert_features
_disable_12751
_disable_autotune_gtx
_disable_fast_validate
_disable_fastopen
_disable_fba_qrw
_disable_fba_wpr
_disable_flashback_archiver
_disable_flashback_wait_callback
_disable_highres_ticks
_disable_index_block_prefetching
_disable_kcb_flashback_blocknew_opt
_disable_kcbl_flashback_blocknew_opt
_disable_metrics_group
_disable_parallel_conventional_load
_disable_read_only_open_dict_check
_disable_rebalance_space_check
_disable_sec_ticks
_disable_thread_internal_disable
_disable_vktm
_disable_wait_stack
_diskmon_pipe_name
_dra_bmr_number_threshold
_dra_bmr_percent_threshold
_dra_enable_offline_dictionary
_edition_based_redefinition
_emon_regular_ntfn_slaves
_enable_automatic_maintenance
_enable_automatic_sqltune
_enable_ddl_wait_lock
_enable_midtier_affinity
_enable_obj_queues
_enable_online_index_without_s_locking
_enable_query_rewrite_on_remote_objs
_enable_row_shipping
_enable_scn_wait_interface
_enable_separable_transactions
_enable_shared_pool_durations
_enable_shared_server_vector_io
_enable_space_preallocation
_enable_spacebg
_endprot_chunk_comment
_endprot_heap_comment
_endprot_subheaps
_enqueue_deadlock_time_sec
_evolve_plan_baseline_report_level
_evt_system_event_propagation
_fastpin_enable
_fbda_busy_percentage
_fbda_inline2_percentage
_fbda_inline_percentage
_fg_iorm_slaves
_fg_log_checksum
_first_k_rows_dynamic_proration
_fix_control
_flashback_archiver_partition_size
_flashback_format_chunk_mb
_flashback_format_chunk_mb_dwrite
_flashback_marker_cache_enabled
_flashback_marker_cache_size
_flashback_max_standby_sync_span
_flashback_write_max_loop_limit
_force_hsc_compress
_force_oltp_compress
_force_slave_mapping_intra_part_loads
_force_tmp_segment_loads
_forwarded_2pc_threshold
_gc_affinity_locking
_gc_affinity_locks
_gc_affinity_ratio
_gc_async_memcpy
_gc_bypass_readers
_gc_dissolve_undo_affinity
_gc_global_checkpoint_scn
_gc_initiate_undo_affinity
_gc_long_query_threshold
_gc_policy_minimum
_gc_policy_time
_gc_read_mostly_locking
_gc_transfer_ratio
_gc_undo_block_disk_reads
_gc_voluntary_down_convert_obj
_gcs_res_per_bucket
_gcs_testing
_global_hang_analysis_interval_secs
_globalindex_pnum_filter_enabled
_hang_resolution
_heur_deadlock_resolution_secs
_high_priority_processes
_hm_analysis_oradebug_node_dump_level
_hm_analysis_oradebug_sys_dump_level
_hm_analysis_output_disk
_hm_log_incidents
_hm_verification_interval
_idle_session_kill_enabled
_ignore_fg_deps
_imr_avoid_double_voting
_imr_device_type
_imr_evicted_member_kill
_imr_evicted_member_kill_wait
_imr_highload_threshold
_imr_systemload_check
_inline_sql_in_plsql
_io_resource_manager_always_on
_io_statistics
_ioq_fanin_multiplier
_iorm_tout
_k2q_latches
_kcfis_fault_control
_kcfis_max_appliances
_kcfis_oss_io_size
_kcfis_read_buffer_limit
_kcfis_trace_level
_kcfis_work_set_appliances
_kdi_avoid_block_checking
_kdli_STOP_bsz
_kdli_STOP_dba
_kdli_STOP_fsz
_kdli_STOP_nio
_kdli_STOP_tsn
_kdli_allow_corrupt
_kdli_cache_inode
_kdli_cache_read_threshold
_kdli_cache_size
_kdli_cache_verify
_kdli_cache_write_threshold
_kdli_cacheable_length
_kdli_force_cr
_kdli_force_cr_meta
_kdli_force_storage
_kdli_full_readahead_threshold
_kdli_inject_assert
_kdli_inject_crash
_kdli_inline_xfm
_kdli_inode_preference
_kdli_itree_entries
_kdli_memory_protect
_kdli_rci_lobmap_entries
_kdli_readahead_limit
_kdli_readahead_strategy
_kdli_recent_scn
_kdli_reshape
_kdli_safe_callbacks
_kdli_sio_async
_kdli_sio_backoff
_kdli_sio_bps
_kdli_sio_dop
_kdli_sio_fgio
_kdli_sio_fileopen
_kdli_sio_flush
_kdli_sio_free
_kdli_sio_min_read
_kdli_sio_min_write
_kdli_sio_nbufs
_kdli_sio_niods
_kdli_sio_on
_kdli_sio_pga
_kdli_sio_pga_top
_kdli_sio_strategy
_kdli_small_cache_limit
_kdli_sort_dbas
_kdli_space_cache_limit
_kdli_squeeze
_kdli_timer_dmp
_kdli_timer_trc
_kdli_trace
_kdlu_max_bucket_size
_kdlu_max_bucket_size_mts
_kdlu_trace_layer
_kdlu_trace_session
_kdlu_trace_system
_kdlw_enable_ksi_locking
_kdlw_enable_write_gathering
_kdlwp_flush_threshold
_kdlxp_cmp_subunit_size
_kdlxp_dedup_flush_threshold
_kdlxp_dedup_hash_algo
_kdlxp_dedup_prefix_threshold
_kdlxp_lobcompress
_kdlxp_lobdeduplicate
_kdlxp_lobdedupvalidate
_kdlxp_lobencrypt
_kdlxp_min_xfm_size
_kdlxp_mincmp
_kdlxp_spare1
_kdlxp_xfmcache
_kdt_buffering
_kebm_nstrikes
_kebm_suspension_time
_kfm_disable_set_fence
_kgl_debug
_kgl_features_enabled
_kgl_kqr_cap_so_stacks
_kgl_message_locks
_kgl_min_cached_so_count
_kgl_so_stack_depth
_kgsb_threshold_size
_kgx_spin_count
_kill_controlfile_enqueue_blocker
_kill_diagnostics_timeout
_kill_enqueue_blocker
_kill_session_dump
_kkdlgon_max_iter
_kks_free_cursor_stat_pct
_kokli_cache_size
_ksb_disable_diagpid
_ksb_restart_clean_time
_ksb_restart_policy_times
_ksdxdocmd_enabled
_kse_signature_entries
_kse_signature_limit
_kse_snap_ring_size
_ksi_trace_bucket
_ksi_trace_bucket_size
_ksmb_debug
_ksmd_protect_mode
_kspol_tac_timeout
_ksr_unit_test_processes
_kss_quiet
_ksuitm_addon_trccmd
_ksv_max_spawn_fail_limit
_ksv_pool_hang_kill_to
_ksv_pool_wait_timeout
_ksv_spawn_control_all
_ksvppktmode
_ksxp_disable_dynamic_loading
_ksxp_disable_ipc_stats
_ksxp_init_stats_bkts
_ksxp_max_stats_bkts
_ksxp_ping_enable
_ksxp_ping_polling_time
_ksxp_reaping
_ksxp_skgxp_compat_library_path
_ksxp_skgxp_library_path
_ksxp_stats_mem_lmt
_ksxp_testing
_ksxp_unit_test_byte_transformation
_ktslj_segext_warning
_ktspsrch_maxsc
_kttext_warning
_lm_asm_enq_hashing
_lm_better_ddvictim
_lm_dd_max_search_time
_lm_dd_search_cnt
_lm_idle_connection_check
_lm_idle_connection_check_interval
_lm_idle_connection_kill
_lm_lmon_nowait_latch
_lm_postevent_buffer_size
_lm_psrcfg
_lm_rcvr_hang_allow_time
_lm_rcvr_hang_check_frequency
_lm_rcvr_hang_kill
_lmn_compression
_local_hang_analysis_interval_secs
_log_archive_strong_auth
_log_event_queues
_log_read_buffers
_logout_storm_rate
_logout_storm_retrycnt
_logout_storm_timeout
_ltc_trace
_max_io_size
_max_large_io
_max_small_io
_max_spacebg_slaves
_max_spacebg_tasks
_max_temp_overhead
_memory_broker_marginal_utility_bc
_memory_broker_marginal_utility_sp
_memory_nocancel_defsgareq
_midtier_affinity_clusterwait_threshold
_midtier_affinity_goodness_threshold
_midtier_affinity_timeout
_minfree_plus
_minimum_db_flashback_retention
_multi_instance_pmr
_nlj_batching_enabled
_nlj_batching_misses_enabled
_object_reuse_bast
_object_stats_max_entries
_olap_analyze_max
_olap_dimension_corehash_large
_olap_dimension_corehash_pressure
_olap_dimension_corehash_size
_olap_dimension_corehash_small
_oltp_compression
_oltp_compression_gain
_online_patch_disable_stack_check
_optimizer_adaptive_cursor_sharing
_optimizer_aw_join_push_enabled
_optimizer_aw_stats_enabled
_optimizer_connect_by_combine_sw
_optimizer_connect_by_cost_based
_optimizer_distinct_elimination
_optimizer_enable_density_improvements
_optimizer_enable_extended_stats
_optimizer_extend_jppd_view_types
_optimizer_extended_cursor_sharing_rel
_optimizer_extended_stats_usage_control
_optimizer_fkr_index_cost_bias
_optimizer_free_transformation_heap
_optimizer_group_by_placement
_optimizer_improve_selectivity
_optimizer_multi_level_push_pred
_optimizer_native_full_outer_join
_optimizer_nested_rollup_for_gset
_optimizer_null_aware_antijoin
_optimizer_or_expansion_subheap
_optimizer_reuse_cost_annotations
_optimizer_rownum_bind_default
_optimizer_skip_scan_guess
_optimizer_sortmerge_join_inequality
_optimizer_star_trans_min_cost
_optimizer_star_trans_min_ratio
_optimizer_use_subheap
_orph_cln_interval
_parallel_policy
_parallel_time_threshold
_parallel_time_unit
_pivot_implementation_method
_plan_verify_improvement_margin
_plan_verify_local_time_limit
_prop_old_enabled
_protect_frame_heaps
_px_bind_peek_sharing
_px_dump_12805_source
_px_execution_services_enabled
_px_io_process_bandwidth
_px_io_system_bandwidth
_px_ual_serial_input
_query_mmvrewrite_maxcmaps
_query_mmvrewrite_maxdmaps
_query_mmvrewrite_maxinlists
_query_mmvrewrite_maxintervals
_query_mmvrewrite_maxmergedcmaps
_query_mmvrewrite_maxpreds
_query_mmvrewrite_maxqryinlistvals
_query_mmvrewrite_maxregperm
_rdbms_compatibility
_rdbms_internal_fplib_enabled
_rdbms_internal_fplib_raise_errors
_readable_standby_mode
_readable_standby_sync_timeout
_redo_read_from_memory
_redo_transport_compress_all
_replace_virtual_columns
_resource_manager_always_off
_result_cache_auto_execution_threshold
_result_cache_auto_size_threshold
_result_cache_auto_time_distance
_result_cache_auto_time_threshold
_result_cache_block_size
_result_cache_timeout
_rman_restore_through_link
_row_shipping_explain
_row_shipping_threshold
_rowsource_profiling_statistics
_rtc_infeasible_threshold
_sage_enabled
_sage_fcre
_scatter_gcs_resources
_scatter_gcs_shadows
_scn_wait_interface_max_backoff_time_secs
_scn_wait_interface_max_timeout_secs
_sdiag_crash
_sec_enable_test_rpcs
_securefile_timers
_selectivity_for_srf_enabled
_sga_clear_dump
_sga_early_trace
_sga_locking
_shared_io_pool_buf_size
_shared_io_pool_debug_trc
_shared_io_pool_size
_shared_io_set_value
_shared_iop_max_size
_shared_pool_minsize_on
_shared_server_load_balance
_shared_server_num_queues
_side_channel_batch_timeout_ms
_simulate_mem_transfer
_siop_flashback_scandepth
_skgxp_udp_ack_delay
_skgxp_udp_enable_dynamic_credit_mgmt
_skgxp_udp_lmp_mtusize
_skgxp_udp_lmp_on
_skgxp_udp_use_tcb
_smon_undo_seg_rescan_limit
_space_align_size
_sql_analyze_parse_model
_sql_plan_baseline_capture_on_1_exec
_sqlmon_max_plan
_sqlmon_max_planlines
_sqlmon_threshold
_srvntfn_job_deq_timeout
_srvntfn_jobsubmit_interval
_srvntfn_max_concurrent_jobs
_srvntfn_q_msgcount
_srvntfn_q_msgcount_inc
_sscr_dir
_sscr_osdir
_statistics_based_srf_enabled
_step_down_limit_in_pct
_storage_predicate_access_predicate
_test_spacebg
_timemodel_collection
_timeout_actions_enabled
_timer_precision
_trace_dump_all_procs
_trace_dump_client_buckets
_trace_dump_cur_proc_only
_trace_dump_static_only
_trace_kqlidp
_trace_pool_size
_trace_virtual_columns
_tsenc_tracing
_undo_block_compression
_update_datafile_headers_with_space_information
_use_best_fit
_use_zero_copy_io
_UTL_FILE_FOLLOW_SYMLINKS
_virtual_column_overload_allowed
_wait_breakup_threshold_csecs
_wait_breakup_time_csecs
_wcr_control
_with_subquery
_xsolapi_build_trace
_xsolapi_dml_trace
_xsolapi_fix_vptrs
_xsolapi_generate_with_clause
_xsolapi_hierarchy_value_type
_xsolapi_metadata_reader_mode
_xsolapi_odbo_mode
_xsolapi_opt_aw_position
_xsolapi_optimize_suppression
_xsolapi_precompute_subquery
_xsolapi_remove_columns_for_materialization
_xsolapi_set_nls
_xsolapi_share_executors
_xsolapi_sql_enable_aw_join
_xsolapi_sql_enable_aw_qdr_merge
_xsolapi_sql_minus_threshold
_xsolapi_stringify_order_levels
_xsolapi_support_mtm
_xsolapi_suppression_aw_mask_threshold
_xsolapi_suppression_chunk_size
_xsolapi_use_models
_xsolapi_use_olap_dml
_xsolapi_use_olap_dml_for_rank

The following table shows the 45 unsupported parameters that were removed in Oracle 11.1

Name
_asm_droptimeout
_bufq_flow_control_thrsh
_bufq_max_msg_sz
_ctas_hwm_brokered_loads
_cursor_cache_frame_bind_memory
_db_obj_ckpt_ordered
_dlm_send_timeout
_enable_kgh_policy
_fast_start_instance_recovery_target
_flashback_write_size_qm
_gc_affinity_limit
_gc_affinity_minimum
_gc_affinity_time
_gc_dynamic_affinity_locks
_gc_undo_affinity_locks
_kcl_undo_grouping
_kcl_undo_locks
_kgl_keep_cache_pct
_kgl_keep_cache_retain_pct
_kgl_session_cached_objects
_lgwr_async_io
_lm_dynamic_remastering
_lm_min_lms
_lm_msg_cache_thresholds
_lm_num_pcmhv_latches
_lm_rcv_buffer_size
_lm_send_buffers
_log_archive_buffer_size
_log_archive_delta_sync_wait
_log_archive_net_timeout
_log_debug_multi_instance
_log_parallelism
_max_rfs_connections
_media_recovery_reap_time
_olap_dimension_corehash_max
_real_time_apply_arch_delay
_trace_archive
_trace_buffer_flushes
_trace_buffer_gets
_trace_buffer_wrap_timestamp
_trace_cr_buffer_creates
_trace_file_size
_trace_flush_processes
_trace_multi_block_reads
_trace_options