Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.1 Supported Optimizer Environment

The X$QKSCESYS family of views were added in Oracle 10.1

The following table shows the 120 unsupported parameters that was reported by the X$QKSCESYS family of views in Oracle 10.1

Name
_add_stale_mv_to_dependency_list
_always_anti_join
_always_semi_join
_always_star_transformation
_bt_mmv_query_rewrite_enabled
_b_tree_bitmap_plans
_complex_view_merging
_convert_set_to_join
_cost_equality_semi_join
_cpu_to_io
_default_non_equality_sel_check
_disable_datalayer_sampling
_disable_function_based_index
_distinct_view_unnesting
_dml_monitoring_enabled
_eliminate_common_subexpr
_enable_type_dep_selectivity
_fast_full_scan_enabled
_fic_area_size
_force_datefold_trunc
_force_temptables_for_gsets
_full_pwise_join_enabled
_generalized_pruning_enabled
_gs_anti_semi_join_allowed
_hash_join_enabled
_hash_multiblock_io_count
_improved_outerjoin_card
_improved_row_length_enabled
_index_join_enabled
_left_nested_loops_random
_like_with_bind_as_equality
_local_communication_costing_enabled
_local_communication_ratio
_minimal_stats_aggregation
_mmv_query_rewrite_enabled
_nested_loop_fudge
_new_initial_join_orders
_new_sort_cost_estimate
_no_or_expansion
_oneside_colstat_for_equijoins
_optimizer_adjust_for_nulls
_optimizer_block_size
_optimizer_cache_stats
_optimizer_cbqt_factor
_optimizer_compute_index_stats
_optimizer_correct_sq_selectivity
_optimizer_cost_based_transformation
_optimizer_cost_filter_pred
_optimizer_cost_model
_optimizer_degree
_optimizer_dim_subq_join_sel
_optimizer_disable_strans_sanity_checks
_optimizer_ignore_hints
_optimizer_join_order_control
_optimizer_join_sel_sanity_check
_optimizer_max_permutations
_optimizer_mjc_enabled
_optimizer_mode_force
_optimizer_new_join_card_computation
_optimizer_percent_parallel
_optimizer_push_down_distinct
_optimizer_push_pred_cost_based
_optimizer_random_plan
_optimizer_search_limit
_optimizer_skip_scan_enabled
_optimizer_sortmerge_join_enabled
_optimizer_squ_bottomup
_optimizer_system_stats_usage
_optimizer_undo_changes
_optimizer_undo_cost_change
_optim_adjust_for_part_skews
_optim_enhance_nnull_detection
_optim_new_default_join_sel
_optim_peek_user_binds
_ordered_nested_loop
_or_expand_nvl_predicate
_parallel_broadcast_enabled
_partial_pwise_join_enabled
_partition_view_enabled
_pga_max_size
_predicate_elimination_enabled
_pred_move_around
_pre_rewrite_push_pred
_project_view_columns
_push_join_predicate
_push_join_union_view
_push_join_union_view2
_px_broadcast_fudge_factor
_query_cost_rewrite
_query_rewrite_1
_query_rewrite_2
_query_rewrite_drj
_query_rewrite_expression
_query_rewrite_fpc
_query_rewrite_fudge
_query_rewrite_jgmigrate
_query_rewrite_maxdisjunct
_query_rewrite_or_error
_query_rewrite_setopgrw_enable
_query_rewrite_vop_cleanup
_remove_aggr_subquery
_right_outer_hash_enable
_slave_mapping_enabled
_smm_auto_cost_enabled
_smm_auto_max_io_size
_smm_auto_min_io_size
_smm_max_size
_smm_min_size
_smm_px_max_size
_sort_elimination_cost_ratio
_sort_multiblock_read_count
_sort_space_for_write_buffers
_spr_push_pred_refspr
_subquery_pruning_enabled
_subquery_pruning_mv_enabled
_system_index_caching
_table_scan_cost_plus_one
_union_rewrite_for_gs
_unnest_subquery
_use_column_stats_for_function