OPTIMIZER_FEATURES_ENABLE('12.1.0.2') |OPTIMIZER_FEATURES_ENABLE('11.2.0.4')
_optimizer_undo_cost_change = 12.1.0.2 | _optimizer_undo_cost_change = 11.2.0.4
_fix_control_key = 0 | _fix_control_key = -1750344682
_optimizer_cube_join_enabled = true | _optimizer_cube_join_enabled = false
_optimizer_hybrid_fpwj_enabled = true | _optimizer_hybrid_fpwj_enabled = false
_px_replication_enabled = true | _px_replication_enabled = false
_optimizer_partial_join_eval = true | _optimizer_partial_join_eval = false
_px_concurrent = true | _px_concurrent = false
_px_object_sampling_enabled = true | _px_object_sampling_enabled = false
_optimizer_unnest_scalar_sq = true | _optimizer_unnest_scalar_sq = false
_px_filter_parallelized = true | _px_filter_parallelized = false
_px_filter_skew_handling = true | _px_filter_skew_handling = false
_optimizer_multi_table_outerjoin = true | _optimizer_multi_table_outerjoin = false
_px_groupby_pushdown = force | _px_groupby_pushdown = choose
_optimizer_ansi_join_lateral_enhance = true | _optimizer_ansi_join_lateral_enhance = false
_px_parallelize_expression = true | _px_parallelize_expression = false
_optimizer_ansi_rearchitecture = true | _optimizer_ansi_rearchitecture = false
_optimizer_gather_stats_on_load = true | _optimizer_gather_stats_on_load = false
_px_adaptive_dist_method = choose | _px_adaptive_dist_method = off
_optimizer_batch_table_access_by_rowid = true | _optimizer_batch_table_access_by_rowid = false
_px_wif_dfo_declumping = choose | _px_wif_dfo_declumping = off
_px_wif_extend_distribution_keys = true | _px_wif_extend_distribution_keys = false
_px_join_skew_handling = true | _px_join_skew_handling = false
_px_partial_rollup_pushdown = adaptive | _px_partial_rollup_pushdown = off
_px_single_server_enabled = true | _px_single_server_enabled = false
_optimizer_dsdir_usage_control = 126 | _optimizer_dsdir_usage_control = 0
_px_cpu_autodop_enabled = true | _px_cpu_autodop_enabled = false
_optimizer_use_gtt_session_stats = true | _optimizer_use_gtt_session_stats = false
_optimizer_adaptive_plans = true | _optimizer_adaptive_plans = false
_optimizer_proc_rate_level = basic | _optimizer_proc_rate_level = off
_adaptive_window_consolidator_enabled = true | _adaptive_window_consolidator_enabled = false
_optimizer_strans_adaptive_pruning = true | _optimizer_strans_adaptive_pruning = false
_optimizer_null_accepting_semijoin = true | _optimizer_null_accepting_semijoin = false
_optimizer_cluster_by_rowid = true | _optimizer_cluster_by_rowid = false
_optimizer_cluster_by_rowid_control = 129 | _optimizer_cluster_by_rowid_control = 3
_distinct_agg_optimization_gsets = choose | _distinct_agg_optimization_gsets = off
_gby_vector_aggregation_enabled = true | _gby_vector_aggregation_enabled = false
_optimizer_vector_transformation = true | _optimizer_vector_transformation = false
_optimizer_aggr_groupby_elim = true | _optimizer_aggr_groupby_elim = false
_optimizer_reduce_groupby_key = true | _optimizer_reduce_groupby_key = false
_optimizer_cluster_by_rowid_batched = true | _optimizer_cluster_by_rowid_batched = false
_optimizer_inmemory_table_expansion = true | _optimizer_inmemory_table_expansion = false
_optimizer_inmemory_gen_pushable_preds = true | _optimizer_inmemory_gen_pushable_preds = false
_optimizer_inmemory_autodop = true | _optimizer_inmemory_autodop = false
_optimizer_inmemory_access_path = true | _optimizer_inmemory_access_path = false
_optimizer_inmemory_bloom_filter = true | _optimizer_inmemory_bloom_filter = false
_optimizer_nlj_hj_adaptive_join = true | _optimizer_nlj_hj_adaptive_join = false
_px_external_table_default_stats = true | _px_external_table_default_stats = false
_optimizer_inmemory_minmax_pruning = true | _optimizer_inmemory_minmax_pruning = false
_optimizer_inmemory_cluster_aware_dop = true | _optimizer_inmemory_cluster_aware_dop = false
fix 9898249 = enabled | fix 9898249 = disabled
fix 10004943 = enabled | fix 10004943 = disabled
fix 9554026 = enabled | fix 9554026 = disabled
fix 9593547 = enabled | fix 9593547 = disabled
fix 9833381 = enabled | fix 9833381 = disabled
fix 10106423 = enabled | fix 10106423 = disabled
fix 10175079 = enabled | fix 10175079 = disabled
fix 10236566 = enabled | fix 10236566 = disabled
fix 9721228 = enabled | fix 9721228 = disabled
fix 9929609 = enabled | fix 9929609 = disabled
fix 10182672 = enabled | fix 10182672 = disabled
fix 9832338 = enabled | fix 9832338 = disabled
fix 11668189 = enabled | fix 11668189 = disabled
fix 11940126 = enabled | fix 11940126 = disabled
fix 12390139 = enabled | fix 12390139 = disabled
fix 11744016 = enabled | fix 11744016 = disabled
fix 10216738 = enabled | fix 10216738 = disabled
fix 12563419 = enabled | fix 12563419 = disabled
fix 12535474 = enabled | fix 12535474 = disabled
fix 12561635 = enabled | fix 12561635 = disabled
fix 12569245 = enabled | fix 12569245 = disabled
fix 12569300 = enabled | fix 12569300 = disabled
fix 12569316 = enabled | fix 12569316 = disabled
fix 12569321 = enabled | fix 12569321 = disabled
fix 9002958 = enabled | fix 9002958 = disabled
fix 12810427 = enabled | fix 12810427 = disabled
fix 12914055 = enabled | fix 12914055 = disabled
fix 12978495 = enabled | fix 12978495 = disabled
fix 13110511 = enabled | fix 13110511 = disabled
fix 13345888 = enabled | fix 13345888 = disabled
fix 13396096 = enabled | fix 13396096 = disabled
fix 12999577 = enabled | fix 12999577 = disabled
fix 12954320 = enabled | fix 12954320 = disabled
fix 13036910 = enabled | fix 13036910 = disabled
fix 12648629 = enabled | fix 12648629 = disabled
fix 13704977 = enabled | fix 13704977 = disabled
fix 11843466 = enabled | fix 11843466 = disabled
fix 13909909 = enabled | fix 13909909 = disabled
fix 12856200 = enabled | fix 12856200 = disabled
fix 9852856 = enabled | fix 9852856 = disabled
fix 14033181 = enabled | fix 14033181 = disabled
fix 13836796 = enabled | fix 13836796 = disabled
fix 13699643 = enabled | fix 13699643 = disabled
fix 13735304 = enabled | fix 13735304 = disabled
fix 14464068 = enabled | fix 14464068 = disabled
fix 13448445 = enabled | fix 13448445 = disabled
fix 9114915 = enabled | fix 9114915 = disabled
fix 13109345 = enabled | fix 13109345 = disabled
fix 14605040 = enabled | fix 14605040 = disabled
fix 14633570 = enabled | fix 14633570 = disabled
fix 13573073 = enabled | fix 13573073 = disabled
fix 16237969 = enabled | fix 16237969 = disabled
fix 13994546 = enabled | fix 13994546 = disabled
fix 14750443 = enabled | fix 14750443 = disabled
fix 14552075 = enabled | fix 14552075 = disabled
fix 16324844 = enabled | fix 16324844 = disabled
fix 13583529 = enabled | fix 13583529 = disabled
fix 14565911 = enabled | fix 14565911 = disabled
fix 16368002 = enabled | fix 16368002 = disabled
fix 16077770 = enabled | fix 16077770 = disabled
fix 11814337 = enabled | fix 11814337 = disabled
fix 14764840 = enabled | fix 14764840 = disabled
fix 16555865 = enabled | fix 16555865 = disabled
fix 16625151 = enabled | fix 16625151 = disabled
fix 16609749 = enabled | fix 16609749 = disabled
fix 16751246 = enabled | fix 16751246 = disabled
fix 16749025 = enabled | fix 16749025 = disabled
fix 16750067 = enabled | fix 16750067 = disabled
fix 15899648 = enabled | fix 15899648 = disabled
fix 16690013 = enabled | fix 16690013 = disabled
fix 16544878 = enabled | fix 16544878 = disabled
fix 16725982 = enabled | fix 16725982 = disabled
fix 14648222 = enabled | fix 14648222 = disabled
fix 16507317 = enabled | fix 16507317 = disabled
fix 16837274 = enabled | fix 16837274 = disabled
fix 14085520 = enabled | fix 14085520 = disabled
fix 16713081 = enabled | fix 16713081 = disabled
fix 14703295 = enabled | fix 14703295 = disabled
fix 16908409 = enabled | fix 16908409 = disabled
fix 16212250 = enabled | fix 16212250 = disabled
fix 17087729 = enabled | fix 17087729 = disabled
fix 17088819 = enabled | fix 17088819 = disabled
fix 13848786 = enabled | fix 13848786 = disabled
fix 13522189 = enabled | fix 13522189 = disabled
fix 16796185 = enabled | fix 16796185 = disabled
fix 15950252 = enabled | fix 15950252 = disabled
fix 16976121 = enabled | fix 16976121 = disabled
fix 16582322 = enabled | fix 16582322 = disabled
fix 16712213 = enabled | fix 16712213 = disabled
fix 17382690 = enabled | fix 17382690 = disabled
fix 14846352 = enabled | fix 14846352 = disabled
fix 16516751 = enabled | fix 16516751 = disabled
fix 8611462 = enabled | fix 8611462 = disabled
fix 14062749 = enabled | fix 14062749 = disabled
fix 16346018 = enabled | fix 16346018 = disabled
fix 12977599 = enabled | fix 12977599 = disabled
fix 14191778 = enabled | fix 14191778 = disabled
fix 15939321 = enabled | fix 15939321 = disabled
fix 17543180 = enabled | fix 17543180 = disabled
fix 17301564 = enabled | fix 17301564 = disabled
fix 12373708 = enabled | fix 12373708 = disabled
fix 17397506 = enabled | fix 17397506 = disabled
fix 14558315 = enabled | fix 14558315 = disabled
fix 16615686 = enabled | fix 16615686 = disabled
fix 16622801 = enabled | fix 16622801 = disabled
fix 16954950 = enabled | fix 16954950 = disabled
fix 17728161 = enabled | fix 17728161 = disabled
fix 17760375 = enabled | fix 17760375 = disabled
fix 17640863 = enabled | fix 17640863 = disabled
fix 17716301 = enabled | fix 17716301 = disabled
fix 17597748 = enabled | fix 17597748 = disabled
fix 17303359 = enabled | fix 17303359 = disabled
fix 16673868 = enabled | fix 16673868 = disabled
fix 17800514 = enabled | fix 17800514 = disabled
fix 14826303 = enabled | fix 14826303 = disabled
fix 17663076 = enabled | fix 17663076 = disabled
fix 17760755 = enabled | fix 17760755 = disabled
fix 17997159 = enabled | fix 17997159 = disabled
fix 14733442 = enabled | fix 14733442 = disabled
fix 17781659 = enabled | fix 17781659 = disabled
fix 17526569 = enabled | fix 17526569 = disabled
fix 17760686 = enabled | fix 17760686 = disabled
fix 17696414 = enabled | fix 17696414 = disabled
fix 18116777 = enabled | fix 18116777 = disabled
fix 16052625 = enabled | fix 16052625 = disabled
fix 18091750 = enabled | fix 18091750 = disabled
fix 17572606 = enabled | fix 17572606 = disabled
fix 18196576 = enabled | fix 18196576 = disabled
fix 17736165 = enabled | fix 17736165 = disabled
fix 16434021 = enabled | fix 16434021 = disabled
fix 18035463 = enabled | fix 18035463 = disabled
fix 18011820 = enabled | fix 18011820 = disabled
fix 16405740 = enabled | fix 16405740 = disabled
fix 18365267 = enabled | fix 18365267 = disabled
fix 17863980 = enabled | fix 17863980 = disabled
fix 18398980 = enabled | fix 18398980 = disabled
fix 18304693 = enabled | fix 18304693 = disabled
fix 18508675 = enabled | fix 18508675 = disabled
fix 18456944 = enabled | fix 18456944 = disabled
fix 17908541 = enabled | fix 17908541 = disabled
fix 18467455 = enabled | fix 18467455 = disabled
fix 16033838 = enabled | fix 16033838 = disabled
fix 16809786 = enabled | fix 16809786 = disabled
fix 18425876 = enabled | fix 18425876 = disabled
fix 18461984 = enabled | fix 18461984 = disabled
fix 17023040 = enabled | fix 17023040 = disabled
fix 14776289 = enabled | fix 14776289 = disabled
