Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Unsupported Parameters

In Oracle 10.1 there were 918 unsupported parameters; in Oracle 10.2 there are 1127 unsupported parameters

The following table shows the 225 unsupported parameters that were added in Oracle 10.2

Name
__dg_broker_service_names
__streams_pool_size
_accept_versions
_addm_version_check
_adjust_literal_replacement
_alert_message_cleanup
_alert_message_purge
_alert_post_background
_alternate_iot_leaf_block_split_points
_asm_allow_resilver_corruption
_asm_droptimeout
_asm_emulmax
_asm_emultimeout
_asm_kfdpevent
_assm_default
_awr_disabled_flush_tables
_awr_flush_threshold_metrics
_awr_flush_workload_metrics
_awr_mmon_cpuusage
_awr_sql_child_limit
_backup_max_gap_size
_bct_fixtab_file
_bloom_filter_debug
_bloom_filter_enabled
_bufq_flow_control_thrsh
_bufq_max_msg_sz
_build_deferred_mv_skipping_mvlog_update
_cgs_reconfig_timeout
_compilation_call_heap_extent_size
_controlfile_section_init_size
_controlfile_section_max_expand
_ctas_hwm_brokered_loads
_cursor_stats_bucket
_cursor_stats_heap
_db_block_adjcheck
_db_block_adjchk_level
_db_block_align_direct_read
_db_block_cache_history_level
_db_block_cache_protect_internal
_db_block_check_objtyp
_db_block_do_full_mbreads
_db_block_table_scan_buffer_size
_db_block_temp_redo
_db_cache_process_cr_pin_max
_db_change_notification_enable
_db_fast_obj_ckpt
_db_file_exec_read_count
_db_file_optimizer_read_count
_db_hot_block_tracking
_db_index_block_checking
_db_lost_write_checking
_db_obj_ckpt_ordered
_db_obj_enable_ksr
_db_row_overlap_checking
_db_writer_verify_writes
_dead_process_scan_interval
_dedicated_server_poll_count
_default_encrypt_alg
_diag_diagnostics
_dimension_skip_null
_disable_adaptive_shrunk_aggregation
_disable_duplex_link
_disable_fast_aggregation
_disable_incremental_recovery_ckpt
_disable_instance_params_check
_disable_interface_checking
_disable_recovery_read_skip
_disable_streams_pool_auto_tuning
_dm_max_shared_pool_pct
_drop_table_granule
_drop_table_optimization_enabled
_dtree_area_size
_dtree_binning_enabled
_dtree_bintest_id
_dtree_compressbmp_enabled
_dtree_max_surrogates
_dtree_pruning_enabled
_dummy_instance
_dump_qbc_tree
_dump_rcvr_ipc
_enable_dml_lock_escalation
_enable_exchange_validation_using_check
_enable_hwm_sync
_enable_reliable_latch_waits
_enable_rlb
_enqueue_resources
_extended_pruning_enabled
_fic_min_bmsize
_filemap_dir
_flashback_log_io_error_behavior
_flashback_max_n_log_per_thread
_force_rewrite_enable
_gby_hash_aggregation_enabled
_gc_coalesce_recovery_reads
_gc_dynamic_affinity_locks
_gc_maximum_bids
_gc_undo_affinity
_gc_undo_affinity_locks
_ges_health_check
_hang_analysis_num_call_stacks
_hwm_sync_threshold
_immediate_commit_propagation
_imr_disk_voting_interval
_incremental_recovery_ckpt_min_batch
_init_granule_interval
_inject_startup_fault
_io_shared_pool_size
_ior_serialize_fault
_kgl_fixed_extents
_kgl_heap_size
_kgl_large_heap_warning_threshold
_kgx_latches
_kks_use_mutex_pin
_kql_subheap_trace
_ksd_test_param
_ksdxdocmd_default_timeout_ms
_kse_pc_table_size
_ksfd_verify_write
_ksuitm_dont_kill_dumper
_ksxp_diagmode
_ksxp_reporting_process
_ksxp_send_timeout
_lgwr_ta_sim_err
_lm_checksum_batch_msg
_lm_contiguous_res_count
_lm_dd_scan_interval
_lm_drm_xlatch
_lm_num_pt_buckets
_lm_num_pt_latches
_log_archive_avoid_memcpy
_log_archive_network_redo_size
_max_arch_lns_wait
_max_lns_shutdown_archival_time
_max_rfs_connections
_media_recovery_reap_time
_mem_std_extent_size
_memory_broker_shrink_streams_pool
_memory_sanity_check
_mv_rolling_inv
_newsort_enabled
_newsort_ordered_pct
_newsort_type
_no_recovery_through_resetlogs
_ns_max_send_delay
_olap_lmgen_dim_size
_olap_lmgen_meas_size
_olap_parallel_update_small_group
_olap_parallel_update_small_threshold
_olap_wrap_errors
_ols_cleanup_task
_optimizer_better_inlist_costing
_optimizer_cartesian_enabled
_optimizer_cbqt_no_size_restriction
_optimizer_complex_pred_selectivity
_optimizer_cost_hjsmj_multimatch
_optimizer_enhanced_filter_push
_optimizer_extended_cursor_sharing
_optimizer_filter_pred_pullup
_optimizer_join_elimination_enabled
_optimizer_min_cache_blocks
_optimizer_multiple_cenv
_optimizer_or_expansion
_optimizer_order_by_elimination_enabled
_optimizer_outer_to_anti_enabled
_optimizer_rownum_pred_based_fkr
_optimizer_self_induced_cache_cost
_optimizer_star_tran_in_with_clause
_optimizer_starplan_enabled
_optimizer_trace
_optimizer_transitivity_retain
_oradebug_force
_os_sched_high_priority
_other_wait_event_exclusion
_other_wait_threshold
_outline_bitmap_tree
_parallel_replay_msg_limit
_parameter_table_block_size
_plan_outline_data
_plsql_cache_enable
_plsql_minimum_cache_hit_percent
_plsql_nvl_optimize
_px_minus_intersect
_px_nss_planb
_px_pwg_enabled
_px_rownum_pd
_recovery_verify_writes
_redo_compatibility_check
_resource_manager_always_on
_restore_spfile
_rman_io_priority
_rowsrc_trace_level
_selfjoin_mv_duplicates
_session_cached_instantiations
_session_context_size
_session_kept_cursor_pins
_short_stack_timeout_ms
_simple_view_merging
_skgxp_reaping
_skgxp_udp_ach_reaping_time
_skgxp_udp_hiwat_warn
_skgxp_udp_interface_detection_time_secs
_skgxp_udp_keep_alive_ping_timer_secs
_skgxp_udp_timed_wait_buffering
_skgxp_udp_timed_wait_seconds
_smm_isort_cap
_sql_hash_debug
_sql_model_unfold_forloops
_stack_guard_level
_static_backgrounds
_streams_pool_max_size
_synonym_repoint_tracing
_ta_lns_wait_for_arch_log
_target_rba_max_lag_percentage
_tdb_debug_mode
_trace_buffer_wrap_timestamp
_truncate_optimization_enabled
_tsm_connect_string
_tsm_disable_auto_cleanup
_undo_debug_mode
_unused_block_compression
_very_large_partitioned_table
_windowfunc_optimization_settings
_xpl_peeked_binds_log_size
_xpl_trace
_xsolapi_source_trace

The following table shows the 16 unsupported parameters that were removed in Oracle 10.2

Name
_db_block_granule_interval
_db_writer_scan_depth_pct
_ges_trace
_init_tempfile_on_open
_kspptbl_mem_usage
_olap_dimsave_restore_cache_values
_parallel_replay_bucket
_rcfg_parallel_cleanup
_recyclebin
_scn_scheme
_sort_space_for_write_buffers
_trace_instance_termination
_use_new_explain_plan
_xsolapi_cursor_max_rows_to_cache_per_req
_xsolapi_cursor_max_time_for_partial_cache
_xsolapi_cursor_use_row_cache