Oracle Internals

Oracle 10.2 Unsupported Optimizer Environment

In Oracle 10.1 there were 152 parameters in the unsupported optimizer environment; in Oracle 10.2 there are 184 parameters in the unsupported optimizer environment.

The following table shows the 34 optimizer parameters that were added to the X$QKSCESYS family of views in Oracle 10.2

Name

flashback_table_rpi

optimizer_secure_view_merging

_bloom_filter_enabled

_db_file_optimizer_read_count

_dimension_skip_null

_dm_max_shared_pool_pct

_enable_dml_lock_escalation

_extended_pruning_enabled

_force_rewrite_enable

_gby_hash_aggregation_enabled

_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_order_by_elimination_enabled

_optimizer_or_expansion

_optimizer_outer_to_anti_enabled

_optimizer_rownum_pred_based_fkr

_optimizer_self_induced_cache_cost

_optimizer_starplan_enabled

_optimizer_star_tran_in_with_clause

_optimizer_transitivity_retain

_px_pwg_enabled

_rowsrc_trace_level

_selfjoin_mv_duplicates

_simple_view_merging

_sql_model_unfold_forloops

_update_bji_ipdml_enabled

The following table shows the two optimizer parameters that were removed from the X$QKSCESYS family of views in Oracle 10.2

Name

db_file_multiblock_read_count

_sort_space_for_write_buffers