Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.1 Unsupported Parameters

In Oracle 9.2 there were 587 unsupported parameters; in Oracle 10.1 there are 914 unsupported parameters

The following table shows the 355 unsupported parameters that were added in Oracle 10.1

Name
_4031_dump_bitvec
_4031_dump_interval
_4031_max_dumps
_4031_sga_dump_interval
_4031_sga_max_dumps
_add_stale_mv_to_dependency_list
_addm_auto_enable
_addm_skiprules
_alert_expiration
_allow_commutativity
_allow_level_without_connect_by
_array_update_vector_read_enabled
_ash_disk_filter_ratio
_ash_disk_write_enable
_ash_dummy_test_param
_ash_eflush_trigger
_ash_enable
_ash_sample_all
_ash_sampling_interval
_ash_size
_asm_acd_chunks
_asm_allow_only_raw_disks
_asm_ausize
_asm_blksize
_asm_disk_repair_time
_asm_libraries
_asm_maxio
_asm_stripesize
_asm_stripewidth
_asm_wait_time
_asmlib_test
_asmsid
_awr_corrupt_mode
_awr_restrict_mode
_backup_kgc_bufsz
_backup_kgc_niters
_backup_kgc_type
_backup_ksfq_bufcnt
_backup_ksfq_bufsz
_bct_bitmaps_per_file
_bct_buffer_allocation_max
_bct_buffer_allocation_min_extents
_bct_buffer_allocation_size
_bct_chunk_size
_bct_crash_reserve_size
_bct_file_block_size
_bct_file_extent_size
_bct_initial_private_dba_buffer_size
_bct_public_dba_buffer_size
_block_change_tracking
_blocks_per_cache_server
_bt_mmv_query_rewrite_enabled
_bufq_stop_flow_control
_cache_stats_monitor
_check_ts_threshold
_cluster_library
_collapse_wait_history
_column_compression_factor
_controlfile_block_size
_controlfile_enqueue_dump
_controlfile_update_check
_convert_set_to_join
_coord_message_buffer
_cursor_bind_capture_area_size
_cursor_bind_capture_interval
_cursor_cache_frame_bind_memory
_cursor_plan_hash_version
_cursor_plan_unparse_enabled
_db_block_cache_history
_db_block_known_clean_pct
_db_block_prefetch_limit
_db_cache_crx_check
_db_cache_pre_warm
_db_fast_obj_check
_db_fast_obj_truncate
_db_file_format_io_buffers
_db_percpu_create_cachesize
_db_recovery_temporal_file_dest
_db_todefer_cache_create
_db_writer_coalesce_area_size
_db_writer_coalesce_write_limit
_db_writer_flush_imu
_dedicated_server_post_wait
_dedicated_server_post_wait_call
_delay_index_maintain
_disable_datalayer_sampling
_disable_function_based_index
_disable_health_check
_disable_image_check
_disable_sample_io_optim
_disable_selftune_checkpointing
_disable_txn_alert
_distinct_view_unnesting
_dml_monitoring_enabled
_ds_iocount_iosize
_dump_common_subexpressions
_dump_connect_by_loop_data
_dump_cursor_heap_sizes
_enable_fast_ref_after_mv_tbs
_enable_hash_overflow
_enable_nativenet_tcpip
_enable_refresh_schedule
_enable_tablespace_alerts
_expand_aggregates
_fair_remote_cvt
_fast_dual_enabled
_fast_start_instance_recovery_target
_fic_algorithm_set
_fic_area_size
_fic_max_length
_fic_outofmem_candidates
_flashback_allow_noarchivelog
_flashback_barrier_interval
_flashback_copy_latches
_flashback_fuzzy_barrier
_flashback_generation_buffer_size
_flashback_hint_barrier_percent
_flashback_log_min_size
_flashback_log_size
_flashback_logfile_enqueue_timeout
_flashback_max_log_size
_flashback_n_log_per_thread
_flashback_standby_barrier_interval
_flashback_verbose_info
_flashback_write_size_qm
_gc_affinity_minimum
_gc_check_bscn
_gc_element_percent
_gc_global_lru
_gc_keep_recovery_buffers
_gc_statistics
_gc_use_cr
_gc_vector_read
_gcs_process_in_recovery
_ges_dd_debug
_ges_diagnostics
_ges_trace
_hang_detection
_hash_join_enabled
_hj_bit_filter_threshold
_idxrb_rowincr
_imu_pools
_in_memory_undo
_init_tempfile_on_open
_kernel_message_network_driver
_kffmap_hash_size
_kffmop_hash_size
_kgl_hash_collision
_kgl_keep_cache_pct
_kgl_keep_cache_retain_pct
_kgl_session_cached_objects
_kgl_time_to_wait_for_locks
_kill_java_threads_on_eoc
_kse_die_timeout
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count
_kspptbl_mem_usage
_ktc_debug
_ku_trace
_lgwr_async_broadcasts
_lightweight_hdrs
_lm_drm_max_requests
_lm_enqueue_freelist
_lm_send_mode
_lm_sendproxy_reserve
_lm_sq_batch_type
_lm_sq_batch_waittick
_log_archive_compress_enable
_log_archive_prot_auto_demote
_log_archive_security_enabled
_log_deletion_policy
_log_parallelism
_log_parallelism_dynamic
_log_parallelism_max
_log_private_mul
_log_private_parallelism
_log_private_parallelism_mul
_longops_enabled
_max_protocol_support
_max_shrink_obj_stats
_media_recovery_read_batch
_mem_annotation_pr_lev
_mem_annotation_scale
_mem_annotation_sh_lev
_mem_annotation_store
_memory_broker_log_stat_entries
_memory_broker_shrink_heaps
_memory_broker_shrink_java_heaps
_memory_broker_shrink_timeout
_memory_broker_stat_interval
_memory_management_tracing
_minimum_blocks_to_shrink
_minimum_extents_to_shrink
_mirror_redo_buffers
_mmv_query_rewrite_enabled
_multiple_instance_recovery
_mv_refresh_ana
_mv_refresh_costing
_mv_refresh_force_parallel_query
_mv_refresh_rebuild_percentage
_mv_refsched_timeincr
_mwin_schedule
_nchar_imp_conv
_notify_crs
_olap_dbgoutfile_echo_to_eventlog
_olap_dimension_corehash_class
_olap_dimension_corehash_max
_olap_page_pool_expand_rate
_olap_page_pool_hi
_olap_page_pool_hit_target
_olap_page_pool_low
_olap_page_pool_pressure
_olap_page_pool_shrink_rate
_olap_sesscache_enabled
_olap_statbool_corebits
_olap_table_function_statistics
_olapi_history_retention
_olapi_iface_object_history
_olapi_iface_object_history_retention
_olapi_iface_operation_history_retention
_olapi_interface_operation_history
_olapi_memory_operation_history
_olapi_memory_operation_history_pause_at_seqno
_olapi_memory_operation_history_retention
_olapi_session_history
_olapi_session_history_retention
_optim_dict_stats_at_db_cr_upg
_optimizer_autostats_job
_optimizer_block_size
_optimizer_cache_stats
_optimizer_cbqt_factor
_optimizer_ceil_cost
_optimizer_compute_index_stats
_optimizer_correct_sq_selectivity
_optimizer_cost_based_transformation
_optimizer_cost_filter_pred
_optimizer_dim_subq_join_sel
_optimizer_disable_strans_sanity_checks
_optimizer_ignore_hints
_optimizer_invalidation_period
_optimizer_join_order_control
_optimizer_max_permutations
_optimizer_mjc_enabled
_optimizer_push_down_distinct
_optimizer_push_pred_cost_based
_optimizer_random_plan
_optimizer_save_stats
_optimizer_squ_bottomup
_oradbg_pathname
_parallel_fixwrite_bucket
_parallel_replay_bucket
_parallel_slave_acquisition_wait
_partition_view_enabled
_percent_flashback_buf_partial_full
_pga_large_extent_size
_pkt_enable
_pkt_pmon_interval
_pkt_start
_plsql_anon_block_code_type
_prescomm
_print_refresh_schedule
_private_memory_address
_projection_pushdown
_projection_pushdown_debug
_push_join_union_view2
_px_buffer_ttl
_px_compilation_debug
_px_compilation_trace
_px_loc_msg_cost
_px_net_msg_cost
_px_no_granule_sort
_px_proc_constrain
_px_send_timeout
_px_slaves_share_cursors
_px_xtgranule_size
_qa_control
_qa_lrg_type
_query_execution_cache_max_size
_query_rewrite_setopgrw_enable
_rcfg_parallel_cleanup
_rcfg_parallel_fixwrite
_rcfg_parallel_replay
_rcfg_parallel_verify
_real_time_apply_arch_delay
_real_time_apply_sim
_realfree_heap_pagesize_hint
_recursive_imu_transactions
_recyclebin
_remove_aggr_subquery
_right_outer_hash_enable
_rollback_stopat
_row_locking
_rowsource_statistics_sampfreq
_sample_rows_per_block
_selftune_checkpoint_write_pct
_selftune_checkpointing_lag
_send_requests_to_pi
_serial_recovery
_serializable
_session_idle_check_interval
_session_wait_history
_shared_pool_max_size
_simulator_bucket_mindelta
_simulator_internal_bound
_simulator_lru_rebalance_sizthr
_simulator_lru_rebalance_thresh
_simulator_lru_scan_count
_simulator_pin_inval_maxcnt
_simulator_reserved_heap_count
_simulator_reserved_obj_count
_simulator_sampling_factor
_simulator_upper_bound_multiple
_smm_freeable_retain
_smm_retain_size
_smu_timeouts
_spr_max_rules
_spr_push_pred_refspr
_spr_use_AW_AS
_spr_use_hash_table
_sqltune_category_parsed
_sta_control
_stn_trace
_swrf_metric_frequent_mode
_swrf_mmon_dbfus
_swrf_mmon_flush
_swrf_mmon_metrics
_swrf_on_disk_enabled
_swrf_test_action
_swrf_test_dbfus
_sysaux_test_param
_threshold_alerts_enable
_total_large_extent_memory
_trace_navigation_scope
_transaction_auditing
_tts_allow_charset_mismatch
_uga_cga_large_extent_size
_ultrafast_latch_statistics
_undo_autotune
_undo_debug_usage
_use_ism_for_pga
_validate_flashback_database
_vendor_lib_loc
_verify_flashback_redo
_xsolapi_auto_materialization_bound
_xsolapi_auto_materialization_type
_xsolapi_densify_cubes
_xsolapi_load_at_process_start
_xsolapi_materialization_rowcache_min_rows_for_use
_xsolapi_materialize_sources
_xsolapi_sql_use_bind_variables
_xt_coverage
_xt_trace
_xtbuffer_size
_xtts_allow_pre10
_xtts_set_platform_info

The following table shows the 28 unsupported parameters that were removed in Oracle 10.1

Name
_attach_count_slack
_compatible_no_recovery
_cpu_count
_db_block_max_dirty_target
_defer_multiple_waiters
_dump_MTTR_to_trace
_enable_multitable_sampling
_initial_file_size
_instance_type
_kcl_name_table_latches
_kcl_recovery_read_batch
_kcl_use_cr
_keep_recovery_buffers
_lm_direct_sends
_lm_enqeue_freelist
_olap_aggregate_child_fragment_size
_olap_aggregate_child_max_size
_open_files_limit
_oracle_trace_events
_oracle_trace_facility_version
_realfree_heap_free_threshold
_recovery_claim_batch_size
_send_requests_to_PI
_smon_consume_post
_sortmerge_inequality_join_off
_tts_allow_nchar_mismatch
_unnest_notexists_sq
_xsolapi_sql_use_bind_variables.