Skip to content

Instantly share code, notes, and snippets.

@mvelikikh

mvelikikh/after.trc

Created August 11, 2022 16:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mvelikikh/ead40e5d7746faf831779a815e8b8e8c to your computer and use it in GitHub Desktop.
Save mvelikikh/ead40e5d7746faf831779a815e8b8e8c to your computer and use it in GitHub Desktop.
Download ZIP
async_gi_maintenance
Raw
after.trc
Trace file /u01/app/oracle/diag/rdbms/racdbb/racdbb1/trace/racdbb1_ora_335870_AFTER.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
Build label: RDBMS_19.11.0.0.0DBRU_LINUX.X64_210412
ORACLE_HOME: /u01/app/oracle/product/19.3.0/dbhome_2
System name: Linux
Node name: rac1.mycompany.mydomain
Release: 5.4.17-2136.308.9.el8uek.x86_64
Version: #2 SMP Mon Jun 13 20:36:40 PDT 2022
Machine: x86_64
Instance name: racdbb1
Redo thread mounted by this instance: 1
Oracle process number: 99
Unix process pid: 335870, image: oracle@rac1.mycompany.mydomain
*** 2022-08-11T15:51:32.903758+00:00 (PDBB1(3))
*** SESSION ID:(359.42854) 2022-08-11T15:51:32.903767+00:00
*** CLIENT ID:() 2022-08-11T15:51:32.903771+00:00
*** SERVICE NAME:(pdbb1) 2022-08-11T15:51:32.903773+00:00
*** MODULE NAME:(SQL*Plus) 2022-08-11T15:51:32.903776+00:00
*** ACTION NAME:() 2022-08-11T15:51:32.903778+00:00
*** CLIENT DRIVER:(SQL*PLUS) 2022-08-11T15:51:32.903781+00:00
*** CONTAINER ID:(3) 2022-08-11T15:51:32.903783+00:00
*** TRACE CONTINUED FROM FILE /u01/app/oracle/diag/rdbms/racdbb/racdbb1/trace/racdbb1_ora_335870_BEFORE.trc ***
Registered qb: SEL$1 0xf3191e60 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$1 nbfros=1 flg=0
fro(0): flg=4 objn=23726 hint_alias="T1"@"SEL$1"
SPM: statement not found in SMB
SPM: capture of plan baseline is OFF
kkoctx(): choosing CBO since query or involved objects are eligible for the same
**************************
Automatic degree of parallelism (AUTODOP)
**************************
Automatic degree of parallelism is disabled: Parameter.
kkopqSetForceParallelProperties: Hint:no
Query: compute:yes forced:no forceDop:0
Global Manual Dop: 1 - Rounded?: no
PM: Considering predicate move-around in query block SEL$1 (#0)
**************************
Predicate Move-Around (PM)
**************************
OPTIMIZER INFORMATION
******************************************
----- Current SQL Statement for this session (sql_id=9s014c27wfym3) -----
select max(id) from t1
*******************************************
Legend
The following abbreviations are used by optimizer trace.
CBQT - cost-based query transformation
JPPD - join predicate push-down
OJPPD - old-style (non-cost-based) JPPD
FPD - filter push-down
PM - predicate move-around
CVM - complex view merging
SPJ - select-project-join
SJC - set join conversion
SU - subquery unnesting
OBYE - order by elimination
OST - old style star transformation
ST - new (cbqt) star transformation
CNT - count(col) to count(*) transformation
JE - Join Elimination
JF - join factorization
CBY - connect by
SLP - select list pruning
DP - distinct placement
VT - vector transformation
AAT - Approximate Aggregate Transformation
ORE - CBQT OR-Expansion
LORE - Legacy OR-Expansion
qb - query block
LB - leaf blocks
DK - distinct keys
LB/K - average number of leaf blocks per key
DB/K - average number of data blocks per key
CLUF - clustering factor
NDV - number of distinct values
Resp - response cost
Card - cardinality
Resc - resource cost
NL - nested loops (join)
SM - sort merge (join)
HA - hash (join)
CPUSPEED - CPU Speed
IOTFRSPEED - I/O transfer speed
IOSEEKTIM - I/O seek time
SREADTIM - average single block read time
MREADTIM - average multiblock read time
MBRC - average multiblock read count
MAXTHR - maximum I/O system throughput
SLAVETHR - average slave I/O throughput
dmeth - distribution method
1: no partitioning required
2: value partitioned
4: right is random (round-robin)
128: left is random (round-robin)
8: broadcast right and partition left
16: broadcast left and partition right
32: partition left using partitioning of right
64: partition right using partitioning of left
256: run the join in serial
0: invalid distribution method
sel - selectivity
ptn - partition
AP - adaptive plans
***************************************
PARAMETERS USED BY THE OPTIMIZER
********************************
*************************************
PARAMETERS WITH ALTERED VALUES
******************************
Compilation Environment Dump
sqlstat_enabled = true
statistics_level = all
total_processor_group_count = 2
Bug Fix Control Environment
*************************************
PARAMETERS WITH DEFAULT VALUES
******************************
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 19.1.0
_optimizer_search_limit = 5
cpu_count = 8
active_instance_count = 2
parallel_threads_per_cpu = 1
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 1572864 KB
_pga_max_size = 314560 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 1024 KB
_smm_max_size_static = 157280 KB
_smm_px_max_size_static = 786432 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 19.1.0
parallel_query_mode = enabled
_enable_parallel_dml = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 100
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 128
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 16
total_cpu_count = 16
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
_parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 0
_px_cpu_autodop_enabled = true
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 256
_use_hidden_partitions = 0
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 0
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 129
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_distinct_agg_optimization_gsets = choose
_array_cdb_view_enabled = true
_optimizer_adaptive_plan_control = 0
_optimizer_adaptive_random_seed = 0
_optimizer_cbqt_or_expansion = on
_inmemory_dbg_scan = 0
_gby_vector_aggregation_enabled = true
_optimizer_vector_transformation = true
_optimizer_vector_fact_dim_ratio = 10
_key_vector_max_size = 0
_key_vector_predicate_enabled = true
_key_vector_predicate_threshold = 0
_vector_operations_control = 0
_optimizer_vector_min_fact_rows = 10000000
parallel_dblink = 0
_px_scalable_invdist = true
_key_vector_offload = predicate
_optimizer_aggr_groupby_elim = true
_optimizer_reduce_groupby_key = true
_vector_serialize_temp_threshold = 1000
_always_vector_transformation = false
_optimizer_cluster_by_rowid_batched = true
_object_link_fixed_enabled = true
optimizer_inmemory_aware = true
_optimizer_inmemory_table_expansion = true
_optimizer_inmemory_gen_pushable_preds = true
_optimizer_inmemory_autodop = true
_optimizer_inmemory_access_path = true
_optimizer_inmemory_bloom_filter = true
_parallel_inmemory_min_time_threshold = 1
_parallel_inmemory_time_unit = 1
_rc_sys_obj_enabled = true
_optimizer_nlj_hj_adaptive_join = true
_indexable_con_id = true
_bloom_serial_filter = on
inmemory_force = default
inmemory_query = enable
_inmemory_query_scan = true
_inmemory_query_fetch_by_rowid = false
_inmemory_pruning = on
_px_autodop_pq_overhead = true
_px_external_table_default_stats = true
_optimizer_key_vector_aggr_factor = 75
_optimizer_vector_cost_adj = 100
_cdb_cross_container = 65535
_cdb_view_parallel_degree = 65535
_optimizer_hll_entry = 4096
_px_cdb_view_join_enabled = true
inmemory_size = 0
_external_table_smart_scan = hadoop_only
_optimizer_inmemory_minmax_pruning = true
_approx_cnt_distinct_gby_pushdown = choose
_approx_cnt_distinct_optimization = 0
_optimizer_ads_use_partial_results = true
_query_execution_time_limit = 0
_optimizer_inmemory_cluster_aware_dop = true
_optimizer_db_blocks_buffers = 0 KB
_query_rewrite_use_on_query_computation = true
_px_scalable_invdist_mcol = true
_optimizer_bushy_join = off
_optimizer_bushy_fact_dim_ratio = 20
_optimizer_bushy_fact_min_size = 100000
_optimizer_bushy_cost_factor = 100
_rmt_for_table_redef_enabled = true
_optimizer_eliminate_subquery = true
_sqlexec_cache_aware_hash_join_enabled = true
_zonemap_usage_tracking = true
_sqlexec_hash_based_distagg_enabled = false
_sqlexec_disable_hash_based_distagg_tiv = false
_sqlexec_hash_based_distagg_ssf_enabled = true
_sqlexec_distagg_optimization_settings = 0
approx_for_aggregation = false
approx_for_count_distinct = false
_optimizer_union_all_gsets = true
_rowsets_use_encoding = true
_rowsets_max_enc_rows = 64
_optimizer_enhanced_join_elimination = true
_optimizer_multicol_join_elimination = true
_key_vector_create_pushdown_threshold = 20000
_optimizer_enable_plsql_stats = true
_recursive_with_parallel = true
_recursive_with_branch_iterations = 7
_px_dist_agg_partial_rollup_pushdown = adaptive
_px_adaptive_dist_bypass_enabled = true
_enable_view_pdb = true
_optimizer_key_vector_pruning_enabled = true
_pwise_distinct_enabled = true
_recursive_with_using_temp_table = false
_partition_read_only = true
_sql_alias_scope = true
_cdb_view_no_skip_migrate = false
_approx_perc_sampling_err_rate = 2
_sqlexec_encoding_aware_hj_enabled = true
rim_node_exist = 0
_enable_containers_subquery = true
_force_containers_subquery = false
_cell_offload_vector_groupby = true
_vector_encoding_mode = manual
_ds_xt_split_count = 1
_ds_sampling_method = PROGRESSIVE
_optimizer_ads_use_spd_cache = true
_optimizer_use_table_scanrate = HADOOP_ONLY
_optimizer_use_xt_rowid = true
_xt_sampling_scan_granules = on
_recursive_with_control = 0
_sqlexec_use_rwo_aware_expr_analysis = true
_optimizer_band_join_aware = true
_optimizer_vector_base_dim_fact_factor = 200
approx_for_percentile = none
_approx_percentile_optimization = 0
_projection_pushdown = true
_px_object_sampling = 200
_optimizer_adaptive_plans_continuous = false
_optimizer_adaptive_plans_iterative = false
_ds_enable_view_sampling = true
_optimizer_generate_ptf_implied_preds = true
_optimizer_inmemory_use_stored_stats = AUTO
_cdb_special_old_xplan = true
uniaud_internal_cursor = 0
_kd_dbg_control = 0
_mv_access_compute_fresh_data = on
_bloom_filter_ratio = 35
_optimizer_control_shard_qry_processing = 65528
containers_parallel_degree = 65535
sql_from_coordinator = 0
_xt_sampling_scan_granules_min_granules = 1
_in_memory_cdt = LIMITED
_in_memory_cdt_maxpx = 4
_px_partition_load_dist_threshold = 64
_px_adaptive_dist_bypass_optimization = 1
_optimizer_interleave_or_expansion = true
optimizer_adaptive_plans = true
optimizer_adaptive_statistics = false
_optimizer_use_feedback_for_join = false
_optimizer_ads_for_pq = false
_px_join_skewed_values_count = 0
optimizer_ignore_parallel_hints = false
parallel_min_degree = 1
_px_nlj_bcast_rr_threshold = 10
_optimizer_gather_stats_on_load_all = false
_optimizer_gather_stats_on_load_hist = false
_optimizer_allow_all_access_paths = true
_key_vector_double_enabled = true
_key_vector_timestamp_enabled = true
_optimizer_answering_query_using_stats = false
_disable_dblink_optim = true
_cell_offload_hybrid_processing = true
_read_optimized_table_lookup = true
_optimizer_key_vector_payload = true
_optimizer_vector_fact_payload_ratio = 20
_bloom_pruning_setops_enabled = true
_bloom_filter_setops_enabled = true
_key_vector_shared_dgk_ht = true
_px_pwise_wif_enabled = true
_sqlexec_reorder_wif_enabled = true
_px_partition_skew_threshold = 80
_sqlexec_pwiseops_with_sqlfuncs_enabled = true
_sqlexec_pwiseops_with_binds_enabled = true
_px_shared_hash_join = false
_px_reuse_server_groups = multi
_px_join_skew_null_handling = true
_px_join_skew_use_histogram = true
_px_join_skew_sampling_time_limit = 50
_px_join_skew_sampling_percent = 0
_cdb_view_no_skip_restricted = false
_inmemory_external_table = true
_sqlexec_use_kgghash3 = true
_cell_offload_vector_groupby_force = false
_hcs_enable_pred_push = true
parallel_dop_doubled = 0
_optimizer_gather_stats_on_load_index = true
_con_map_sql_enforcement = true
_uniq_cons_sql_enforcement = true
_ref_cons_sql_enforcement = true
_is_lock_table_for_split_merge = 0
_cell_offload_vector_groupby_fact_key = true
_px_scalable_gby_invdist = true
_px_dynamic_granules = true
_px_dynamic_granules_adjust = 10
_px_hybrid_partition_execution_enabled = true
_px_hybrid_partition_skew_threshold = 10
_optimizer_key_vector_use_max_size = 1048576
_cell_offload_vector_groupby_withnojoin = true
_key_vector_join_pushdown_enabled = true
_cell_offload_grand_total = true
_optimizer_key_vector_payload_dim_aggs = false
_optimizer_use_auto_indexes = AUTO
_optimizer_use_stats_on_conventional_dml = false
_optimizer_gather_stats_on_conventional_dml = false
_optimizer_use_stats_on_conventional_config = 0
_skip_pset_col_chk = 0
_nls_binary = true
_optimizer_quarantine_sql = true
_optimizer_gather_stats_on_conventional_config = 0
_nls_forced_binary = 0
_utl32k_mv_query = false
optimizer_session_type = NORMAL
BlockChain_ledger_infrastructure = 0
_cell_offload_vector_groupby_external = true
_bigdata_offload_flag = false
container_data = ALL
optimizer_real_time_statistics = false
_update_global_index_from_part_exchange = 0
***************************************
PARAMETERS IN OPT_PARAM HINT
****************************
***************************************
Column Usage Monitoring is ON: tracking level = 53
***************************************
Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
JF: Checking validity of join factorization for query block SEL$1 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$1 (#0)
TE: Bypassed: No relevant table found.
ORE: Checking validity of OR Expansion for query block SEL$1 (#0)
VT: Initial VT validity check for query block SEL$1 (#0)
VT: Bypassed: inmemory is disabled.
BJ: Checking validity for bushy join for query block SEL$1 (#0)
invalid because Not enabled by hint/parameter
BJ: Bypassed: Not enabled by hint/parameter.
CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.
CBQT: Validity checks failed for 9s014c27wfym3.
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
OBYE: Considering Order-by Elimination from view SEL$1 (#0)
***************************
Order-by elimination (OBYE)
***************************
OBYE: OBYE bypassed: no order by to eliminate.
CVM: Considering view merge in query block SEL$1 (#0)
OJE: Begin: find best directive for query block SEL$1 (#0)
OJE: End: finding best directive for query block SEL$1 (#0)
CNT: Considering count(col) to count(*) on query block SEL$1 (#0)
*************************
Count(col) to Count(*) (CNT)
*************************
CNT: COUNT() to COUNT(*) not done.
query block SEL$1 (#0) unchanged
Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
JF: Checking validity of join factorization for query block SEL$1 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$1 (#0)
TE: Bypassed: No relevant table found.
ORE: Checking validity of OR Expansion for query block SEL$1 (#0)
VT: Initial VT validity check for query block SEL$1 (#0)
VT: Bypassed: inmemory is disabled.
BJ: Checking validity for bushy join for query block SEL$1 (#0)
invalid because Not enabled by hint/parameter
BJ: Bypassed: Not enabled by hint/parameter.
CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.
CBQT: Validity checks failed for 9s014c27wfym3.
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
AAT: Considering Approximate Aggregate Transformation on query block SEL$1 (#0)
*******************************************
Approximate Aggregate Transformation (AAT)
*******************************************
AAT: no exact aggregates transformed
SQE: Trying SQ elimination.
SU: Considering subquery unnesting in query block SEL$1 (#0)
********************
Subquery Unnest (SU)
********************
SU: Considering bottom-up subquery unnesting
SJC: Considering set-join conversion in query block SEL$1 (#0)
*************************
Set-Join Conversion (SJC)
*************************
SJC: not performed
DCL: Checking validity of group-by elimination SEL$1 (#0)
DCL: Result of group-by elimination: Invalid
PM: Considering predicate move-around in query block SEL$1 (#0)
**************************
Predicate Move-Around (PM)
**************************
PM: PM bypassed: Outer query contains no views.
PM: PM bypassed: Outer query contains no views.
isReduceGrByValid: Group By Validation (Failed).
isReduceGrByValid: Group By Validation (Failed).
SQT: Considering Statistic-based Query Transformation from query block SEL$1 (#0)
***************************
Statistic-based Query Transformation (SQT)
***************************
SQT: SQT bypassed: Disabled by parameter.
query block SEL$1 (#0) unchanged
FPD: Considering simple filter push in query block SEL$1 (#0)
??
apadrv-start sqlid=11241024667064433251
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
:
call(in-use=1544, alloc=16344), compile(in-use=71312, alloc=72000), execution(in-use=3152, alloc=4032)
*******************************************
Peeked values of the binds in SQL statement
*******************************************
=====================================
SPD: BEGIN context at statement level
=====================================
Stmt: ******* UNPARSED QUERY IS *******
SELECT MAX("T1"."ID") "MAX(ID)" FROM "TC"."T1" "T1"
Objects referenced in the statement
T1[T1] 23726, type = 1
Objects in the hash table
Hash table Object 23726, type = 1, ownerid = 9926208033879849868:
No Dynamic Sampling Directives for the object
Return code in qosdInitDirCtx: ENBLD
===================================
SPD: END context at statement level
===================================
Final query after transformations:******* UNPARSED QUERY IS *******
SELECT MAX("T1"."ID") "MAX(ID)" FROM "TC"."T1" "T1"
kkoqbc: optimizing query block SEL$1 (#0)
:
call(in-use=1544, alloc=16344), compile(in-use=81112, alloc=84488), execution(in-use=3152, alloc=4032)
kkoqbc-subheap (create addr=0x7fe1f318c738)
****************
QUERY BLOCK TEXT
****************
select max(id) from t1
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0
fro(0): flg=0 objn=23726 hint_alias="T1"@"SEL$1"
-----------------------------
SYSTEM STATISTICS INFORMATION
-----------------------------
Using dictionary system stats.
Using NOWORKLOAD Stats
CPUSPEEDNW: 4363 millions instructions/sec (default is 100)
IOTFRSPEED: 4096 bytes per millisecond (default is 4096)
IOSEEKTIM: 10 milliseconds (default is 10)
MBRC: NO VALUE blocks (default is 8)
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T1 Alias: T1 (Using composite stats)
#Rows: 27000 SSZ: 0 LGR: 0 #Blks: 476 AvgRowLen: 110.00 NEB: 0 ChainCnt: 0.00 ScanRate: 0.00 SPC: 0 RFL: 0 RNF: 0 CBK: 0 CHR: 0 KQDFLG: 1
#IMCUs: 0 IMCRowCnt: 0 IMCJournalRowCnt: 0 #IMCBlocks: 0 IMCQuotient: 0.000000
Index Stats::
Index: T1_ID Col#: 1
LVLS: 1 #LB: 68 #DK: 27000 LB/K: 1.00 DB/K: 1.00 CLUF: 432.00 NRW: 27000.00 SSZ: 0.00 LGR: 0.00 CBK: 0.00 GQL: 0.00 CHR: 0.00 KQDFLG: 8192 BSZ: 1
KKEISFLG: 1
Index: T1_N1 Col#: 2
LVLS: 1 #LB: 128 #DK: 600 LB/K: 1.00 DB/K: 42.00 CLUF: 25671.00 NRW: 27000.00 SSZ: 0.00 LGR: 0.00 CBK: 0.00 GQL: 0.00 CHR: 0.00 KQDFLG: 8192 BSZ: 1
KKEISFLG: 1
try to generate single-table filter predicates from ORs for query block SEL$1 (#0)
=======================================
SPD: BEGIN context at query block level
=======================================
Query Block SEL$1 (#0)
Return code in qosdSetupDirCtx4QB: NOCTX
=====================================
SPD: END context at query block level
=====================================
Access path analysis for T1
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T1[T1]
SPD: Return code in qosdDSDirSetup: NOCTX, estType = TABLE
Table: T1 Alias: T1
Card: Original: 27000.000000 Rounded: 27000 Computed: 27000.000000 Non Adjusted: 27000.000000
Scan IO Cost (Disk) = 131.000000
Scan CPU Cost (Disk) = 7439805.440000
Total Scan IO Cost = 131.000000 (scan (Disk))
= 131.000000
Total Scan CPU Cost = 7439805.440000 (scan (Disk))
= 7439805.440000
Access Path: TableScan
Cost: 131.142102 Resp: 131.142102 Degree: 0
Cost_io: 131.000000 Cost_cpu: 7439805
Resp_io: 131.000000 Resp_cpu: 7439805
Access Path: index (index (FFS))
Index: T1_ID
resc_io: 20.000000 resc_cpu: 3724258
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Access Path: index (FFS)
Cost: 20.071134 Resp: 20.071134 Degree: 1
Cost_io: 20.000000 Cost_cpu: 3724258
Resp_io: 20.000000 Resp_cpu: 3724258
****** Costing Index T1_ID
Access Path: index (FullScan)
Index: T1_ID
resc_io: 69.000000 resc_cpu: 5891379
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 69.112527 Resp: 69.112527 Degree: 1
******** Begin index join costing ********
****** trying bitmap/domain indexes ******
****** finished trying bitmap/domain indexes ******
****** Costing Index T1_ID
Access Path: index (FullScan)
Index: T1_ID
resc_io: 69.000000 resc_cpu: 5891379
ix_sel: 1.000000 ix_sel_with_filters: 1.000000
Cost: 69.112527 Resp: 69.112527 Degree: 0
******** End index join costing ********
Best:: AccessPath: IndexFFS
Index: T1_ID
Cost: 20.071134 Degree: 1 Resp: 20.071134 Card: 27000.000000 Bytes: 0.000000
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
PJE: Bypassed; QB has a single table SEL$1 (#0)
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
Join order[1]: T1[T1]#0
***********************
Best so far: Table#: 0 cost: 20.071134 card: 27000.000000 bytes: 135000.000000
***********************
(newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000
*********************************
Number of join permutations tried: 1
*********************************
Enumerating distribution method (advanced)
LORE: Trying or-Expansion on query block SEL$1 (#0)
Transfer Optimizer annotations for query block SEL$1 (#0)
AP: Checking validity for query block SEL$1, sqlid=9s014c27wfym3
AutoDOP: Consider caching for T1[T1](obj#23734)
cost:20.071134 blkSize:8192 objSize:68.00 marObjSize:64.60 bufSize:396819.00 affPercent:80 smallTab:YES affinitized:NO
kkecComputeAPDop: IO Dop: 0.000000 - CPU Dop: 0.000000
Replication not feasible for first input in join order
Transfer optimizer annotations for T1[T1]
Final cost for query block SEL$1 (#0) - All Rows Plan:
Best join order: 1
Cost: 20.071134 Degree: 1 Card: 27000.000000 Bytes: 135000.000000
Resc: 20.071134 Resc_io: 20.000000 Resc_cpu: 3724258
Resp: 20.071134 Resp_io: 20.000000 Resc_cpu: 3724258
kkoqbc-subheap (delete addr=0x7fe1f318c738, in-use=27432, alloc=30136)
kkoqbc-end:
:
call(in-use=14168, alloc=57584), compile(in-use=85304, alloc=88632), execution(in-use=3152, alloc=4032)
kkoqbc: finish optimizing query block SEL$1 (#0)
CBRID: T1 @ SEL$1 - blocking operation in qb SEL$1
apadrv-end
:
call(in-use=14168, alloc=57584), compile(in-use=88688, alloc=92776), execution(in-use=3152, alloc=4032)
Added Filter for Orphaned Entries of Index T1_ID:
TBL$OR$IDX$PART$NUM("T1",0,8,0,"T1".ROWID)=1
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=0(MB) time=1(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=0(MB) time=1(ms)
Starting SQL statement dump
user_id=79 user_name=TC module=SQL*Plus action=
sql_id=9s014c27wfym3 plan_hash_value=-1837937558 problem_type=3 command_type=3
----- Current SQL Statement for this session (sql_id=9s014c27wfym3) -----
select max(id) from t1
sql_text_length=23
sql=select max(id) from t1
----- Explain Plan Dump -----
----- Plan Table -----
============
Plan Table
============
-----------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-----------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 20 | |
| 1 | SORT AGGREGATE | | 1 | 5 | | |
| 2 | INDEX FAST FULL SCAN | T1_ID | 26K | 132K | 20 | 00:00:01 |
-----------------------------------------+-----------------------------------+
Query Block Name / Object Alias (identified by operation id):
------------------------------------------------------------
1 - SEL$1
2 - SEL$1 / "T1"@"SEL$1"
------------------------------------------------------------
Predicate Information:
----------------------
2 - filter(TBL$OR$IDX$PART$NUM(<?>,0,8,0,"T1".ROWID)=1)
Content of other_xml column
===========================
has_user_tab : yes
db_version : 19.0.0.0
parse_schema : TC
plan_hash_full : 402873623
plan_hash : 2457029738
plan_hash_2 : 402873623
-----------------
Optimizer Metrics
-----------------
<stats type="compilation"><stat name="bg">0</stat></stats>
---------------------
QUERY BLOCK REGISTRY
---------------------
<qb_registry><q o="2" f="y"><n><![CDATA[SEL$1]]></n><f><h><t><![CDATA[T1]]></t><s><![CDATA[SEL$1]]></s></h></f></q></qb_registry>
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('19.1.0')
DB_VERSION('19.1.0')
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
INDEX_FFS(@"SEL$1" "T1"@"SEL$1" ("T1"."ID"))
END_OUTLINE_DATA
*/
Optimizer state dump:
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 19.1.0
_optimizer_search_limit = 5
cpu_count = 8
active_instance_count = 2
parallel_threads_per_cpu = 1
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 1572864 KB
_pga_max_size = 314560 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 1024 KB
_smm_max_size_static = 157280 KB
_smm_px_max_size_static = 786432 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 19.1.0
parallel_query_mode = enabled
_enable_parallel_dml = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
sqlstat_enabled = true
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
statistics_level = all
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 100
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 128
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 16
total_cpu_count = 16
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
_parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 0
_px_cpu_autodop_enabled = true
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 256
_use_hidden_partitions = 0
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
total_processor_group_count = 2
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 0
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 129
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_distinct_agg_optimization_gsets = choose
_array_cdb_view_enabled = true
_optimizer_adaptive_plan_control = 0
_optimizer_adaptive_random_seed = 0
_optimizer_cbqt_or_expansion = on
_inmemory_dbg_scan = 0
_gby_vector_aggregation_enabled = true
_optimizer_vector_transformation = true
_optimizer_vector_fact_dim_ratio = 10
_key_vector_max_size = 0
_key_vector_predicate_enabled = true
_key_vector_predicate_threshold = 0
_vector_operations_control = 0
_optimizer_vector_min_fact_rows = 10000000
parallel_dblink = 0
_px_scalable_invdist = true
_key_vector_offload = predicate
_optimizer_aggr_groupby_elim = true
_optimizer_reduce_groupby_key = true
_vector_serialize_temp_threshold = 1000
_always_vector_transformation = false
_optimizer_cluster_by_rowid_batched = true
_object_link_fixed_enabled = true
optimizer_inmemory_aware = true
_optimizer_inmemory_table_expansion = true
_optimizer_inmemory_gen_pushable_preds = true
_optimizer_inmemory_autodop = true
_optimizer_inmemory_access_path = true
_optimizer_inmemory_bloom_filter = true
_parallel_inmemory_min_time_threshold = 1
_parallel_inmemory_time_unit = 1
_rc_sys_obj_enabled = true
_optimizer_nlj_hj_adaptive_join = true
_indexable_con_id = true
_bloom_serial_filter = on
inmemory_force = default
inmemory_query = enable
_inmemory_query_scan = true
_inmemory_query_fetch_by_rowid = false
_inmemory_pruning = on
_px_autodop_pq_overhead = true
_px_external_table_default_stats = true
_optimizer_key_vector_aggr_factor = 75
_optimizer_vector_cost_adj = 100
_cdb_cross_container = 65535
_cdb_view_parallel_degree = 65535
_optimizer_hll_entry = 4096
_px_cdb_view_join_enabled = true
inmemory_size = 0
_external_table_smart_scan = hadoop_only
_optimizer_inmemory_minmax_pruning = true
_approx_cnt_distinct_gby_pushdown = choose
_approx_cnt_distinct_optimization = 0
_optimizer_ads_use_partial_results = true
_query_execution_time_limit = 0
_optimizer_inmemory_cluster_aware_dop = true
_optimizer_db_blocks_buffers = 0 KB
_query_rewrite_use_on_query_computation = true
_px_scalable_invdist_mcol = true
_optimizer_bushy_join = off
_optimizer_bushy_fact_dim_ratio = 20
_optimizer_bushy_fact_min_size = 100000
_optimizer_bushy_cost_factor = 100
_rmt_for_table_redef_enabled = true
_optimizer_eliminate_subquery = true
_sqlexec_cache_aware_hash_join_enabled = true
_zonemap_usage_tracking = true
_sqlexec_hash_based_distagg_enabled = false
_sqlexec_disable_hash_based_distagg_tiv = false
_sqlexec_hash_based_distagg_ssf_enabled = true
_sqlexec_distagg_optimization_settings = 0
approx_for_aggregation = false
approx_for_count_distinct = false
_optimizer_union_all_gsets = true
_rowsets_use_encoding = true
_rowsets_max_enc_rows = 64
_optimizer_enhanced_join_elimination = true
_optimizer_multicol_join_elimination = true
_key_vector_create_pushdown_threshold = 20000
_optimizer_enable_plsql_stats = true
_recursive_with_parallel = true
_recursive_with_branch_iterations = 7
_px_dist_agg_partial_rollup_pushdown = adaptive
_px_adaptive_dist_bypass_enabled = true
_enable_view_pdb = true
_optimizer_key_vector_pruning_enabled = true
_pwise_distinct_enabled = true
_recursive_with_using_temp_table = false
_partition_read_only = true
_sql_alias_scope = true
_cdb_view_no_skip_migrate = false
_approx_perc_sampling_err_rate = 2
_sqlexec_encoding_aware_hj_enabled = true
rim_node_exist = 0
_enable_containers_subquery = true
_force_containers_subquery = false
_cell_offload_vector_groupby = true
_vector_encoding_mode = manual
_ds_xt_split_count = 1
_ds_sampling_method = PROGRESSIVE
_optimizer_ads_use_spd_cache = true
_optimizer_use_table_scanrate = HADOOP_ONLY
_optimizer_use_xt_rowid = true
_xt_sampling_scan_granules = on
_recursive_with_control = 0
_sqlexec_use_rwo_aware_expr_analysis = true
_optimizer_band_join_aware = true
_optimizer_vector_base_dim_fact_factor = 200
approx_for_percentile = none
_approx_percentile_optimization = 0
_projection_pushdown = true
_px_object_sampling = 200
_optimizer_adaptive_plans_continuous = false
_optimizer_adaptive_plans_iterative = false
_ds_enable_view_sampling = true
_optimizer_generate_ptf_implied_preds = true
_optimizer_inmemory_use_stored_stats = AUTO
_cdb_special_old_xplan = true
uniaud_internal_cursor = 0
_kd_dbg_control = 0
_mv_access_compute_fresh_data = on
_bloom_filter_ratio = 35
_optimizer_control_shard_qry_processing = 65528
containers_parallel_degree = 65535
sql_from_coordinator = 0
_xt_sampling_scan_granules_min_granules = 1
_in_memory_cdt = LIMITED
_in_memory_cdt_maxpx = 4
_px_partition_load_dist_threshold = 64
_px_adaptive_dist_bypass_optimization = 1
_optimizer_interleave_or_expansion = true
optimizer_adaptive_plans = true
optimizer_adaptive_statistics = false
_optimizer_use_feedback_for_join = false
_optimizer_ads_for_pq = false
_px_join_skewed_values_count = 0
optimizer_ignore_parallel_hints = false
parallel_min_degree = 1
_px_nlj_bcast_rr_threshold = 10
_optimizer_gather_stats_on_load_all = false
_optimizer_gather_stats_on_load_hist = false
_optimizer_allow_all_access_paths = true
_key_vector_double_enabled = true
_key_vector_timestamp_enabled = true
_optimizer_answering_query_using_stats = false
_disable_dblink_optim = true
_cell_offload_hybrid_processing = true
_read_optimized_table_lookup = true
_optimizer_key_vector_payload = true
_optimizer_vector_fact_payload_ratio = 20
_bloom_pruning_setops_enabled = true
_bloom_filter_setops_enabled = true
_key_vector_shared_dgk_ht = true
_px_pwise_wif_enabled = true
_sqlexec_reorder_wif_enabled = true
_px_partition_skew_threshold = 80
_sqlexec_pwiseops_with_sqlfuncs_enabled = true
_sqlexec_pwiseops_with_binds_enabled = true
_px_shared_hash_join = false
_px_reuse_server_groups = multi
_px_join_skew_null_handling = true
_px_join_skew_use_histogram = true
_px_join_skew_sampling_time_limit = 50
_px_join_skew_sampling_percent = 0
_cdb_view_no_skip_restricted = false
_inmemory_external_table = true
_sqlexec_use_kgghash3 = true
_cell_offload_vector_groupby_force = false
_hcs_enable_pred_push = true
parallel_dop_doubled = 0
_optimizer_gather_stats_on_load_index = true
_con_map_sql_enforcement = true
_uniq_cons_sql_enforcement = true
_ref_cons_sql_enforcement = true
_is_lock_table_for_split_merge = 0
_cell_offload_vector_groupby_fact_key = true
_px_scalable_gby_invdist = true
_px_dynamic_granules = true
_px_dynamic_granules_adjust = 10
_px_hybrid_partition_execution_enabled = true
_px_hybrid_partition_skew_threshold = 10
_optimizer_key_vector_use_max_size = 1048576
_cell_offload_vector_groupby_withnojoin = true
_key_vector_join_pushdown_enabled = true
_cell_offload_grand_total = true
_optimizer_key_vector_payload_dim_aggs = false
_optimizer_use_auto_indexes = AUTO
_optimizer_use_stats_on_conventional_dml = false
_optimizer_gather_stats_on_conventional_dml = false
_optimizer_use_stats_on_conventional_config = 0
_skip_pset_col_chk = 0
_nls_binary = true
_optimizer_quarantine_sql = true
_optimizer_gather_stats_on_conventional_config = 0
_nls_forced_binary = 0
_utl32k_mv_query = false
optimizer_session_type = NORMAL
BlockChain_ledger_infrastructure = 0
_cell_offload_vector_groupby_external = true
_bigdata_offload_flag = false
container_data = ALL
optimizer_real_time_statistics = false
_update_global_index_from_part_exchange = 0
Bug Fix Control Environment
fix 3834770 = 1
fix 3746511 = enabled
fix 4519016 = enabled
fix 3118776 = enabled
fix 4488689 = enabled
fix 2194204 = disabled
fix 2660592 = enabled
fix 2320291 = enabled
fix 2324795 = enabled
fix 4308414 = enabled
fix 3499674 = disabled
fix 4569940 = enabled
fix 4631959 = enabled
fix 4519340 = enabled
fix 4550003 = enabled
fix 1403283 = enabled
fix 4554846 = enabled
fix 4602374 = enabled
fix 4584065 = enabled
fix 4545833 = enabled
fix 4611850 = enabled
fix 4663698 = enabled
fix 4663804 = enabled
fix 4666174 = enabled
fix 4567767 = enabled
fix 4556762 = 15
fix 4728348 = enabled
fix 4708389 = enabled
fix 4175830 = enabled
fix 4752814 = enabled
fix 4583239 = enabled
fix 4386734 = enabled
fix 4887636 = enabled
fix 4483240 = enabled
fix 4872602 = disabled
fix 4711525 = enabled
fix 4545802 = enabled
fix 4605810 = enabled
fix 4704779 = enabled
fix 4900129 = enabled
fix 4924149 = enabled
fix 4663702 = enabled
fix 4878299 = enabled
fix 4658342 = enabled
fix 4881533 = enabled
fix 4676955 = enabled
fix 4273361 = enabled
fix 4967068 = enabled
fix 4969880 = disabled
fix 5005866 = enabled
fix 5015557 = enabled
fix 4705343 = enabled
fix 4904838 = enabled
fix 4716096 = enabled
fix 4483286 = disabled
fix 4722900 = enabled
fix 4615392 = enabled
fix 5096560 = enabled
fix 5029464 = enabled
fix 4134994 = enabled
fix 4904890 = enabled
fix 5104624 = enabled
fix 5014836 = enabled
fix 4768040 = enabled
fix 4600710 = enabled
fix 5129233 = enabled
fix 4595987 = enabled
fix 4908162 = enabled
fix 5139520 = enabled
fix 5084239 = enabled
fix 5143477 = disabled
fix 2663857 = enabled
fix 4717546 = enabled
fix 5240264 = disabled
fix 5099909 = enabled
fix 5240607 = enabled
fix 5195882 = enabled
fix 5220356 = enabled
fix 5263572 = enabled
fix 5385629 = enabled
fix 5302124 = enabled
fix 5391942 = enabled
fix 5384335 = enabled
fix 5482831 = enabled
fix 4158812 = enabled
fix 5387148 = enabled
fix 5383891 = enabled
fix 5466973 = enabled
fix 5396162 = enabled
fix 5394888 = enabled
fix 5395291 = enabled
fix 5236908 = enabled
fix 5509293 = enabled
fix 5449488 = enabled
fix 5567933 = enabled
fix 5570494 = enabled
fix 5288623 = enabled
fix 5505995 = enabled
fix 5505157 = enabled
fix 5112460 = enabled
fix 5554865 = enabled
fix 5112260 = enabled
fix 5112352 = enabled
fix 5547058 = enabled
fix 5618040 = enabled
fix 5585313 = enabled
fix 5547895 = enabled
fix 5634346 = enabled
fix 5620485 = enabled
fix 5483301 = enabled
fix 5657044 = enabled
fix 5694984 = enabled
fix 5868490 = enabled
fix 5650477 = enabled
fix 5611962 = enabled
fix 4279274 = enabled
fix 5741121 = enabled
fix 5714944 = enabled
fix 5391505 = enabled
fix 5762598 = enabled
fix 5578791 = enabled
fix 5259048 = enabled
fix 5882954 = enabled
fix 2492766 = enabled
fix 5707608 = enabled
fix 5891471 = enabled
fix 5884780 = enabled
fix 5680702 = enabled
fix 5371452 = enabled
fix 5838613 = enabled
fix 5949981 = enabled
fix 5624216 = enabled
fix 5741044 = enabled
fix 5976822 = enabled
fix 6006457 = enabled
fix 5872956 = enabled
fix 5923644 = enabled
fix 5943234 = enabled
fix 5844495 = enabled
fix 4168080 = enabled
fix 6020579 = enabled
fix 5842686 = disabled
fix 5996801 = enabled
fix 5593639 = enabled
fix 6133948 = enabled
fix 3151991 = enabled
fix 6146906 = enabled
fix 6239909 = enabled
fix 6267621 = enabled
fix 5909305 = enabled
fix 6279918 = enabled
fix 6141818 = enabled
fix 6151963 = enabled
fix 6251917 = enabled
fix 6282093 = enabled
fix 6119510 = enabled
fix 6119382 = enabled
fix 3801750 = enabled
fix 5705630 = disabled
fix 5944076 = enabled
fix 5406763 = enabled
fix 6070954 = enabled
fix 6282944 = enabled
fix 6138746 = enabled
fix 6082745 = enabled
fix 3426050 = enabled
fix 599680 = enabled
fix 6062266 = enabled
fix 6087237 = enabled
fix 6122894 = enabled
fix 6377505 = enabled
fix 5893768 = enabled
fix 6163564 = enabled
fix 6073325 = enabled
fix 6188881 = enabled
fix 6007259 = enabled
fix 6239971 = enabled
fix 5284200 = disabled
fix 6042205 = enabled
fix 6051211 = enabled
fix 6434668 = enabled
fix 6438752 = enabled
fix 5936366 = enabled
fix 6439032 = enabled
fix 6438892 = enabled
fix 6006300 = enabled
fix 5947231 = enabled
fix 5416118 = 1
fix 6365442 = 1
fix 6239039 = enabled
fix 6502845 = enabled
fix 6913094 = enabled
fix 6029469 = enabled
fix 5919513 = enabled
fix 6057611 = enabled
fix 6469667 = enabled
fix 6608941 = disabled
fix 6368066 = enabled
fix 6329318 = enabled
fix 6656356 = enabled
fix 4507997 = enabled
fix 6671155 = enabled
fix 6694548 = enabled
fix 6688200 = enabled
fix 6612471 = enabled
fix 6708183 = disabled
fix 6326934 = enabled
fix 6520717 = disabled
fix 6714199 = enabled
fix 6681545 = enabled
fix 6748058 = enabled
fix 6167716 = enabled
fix 6674254 = enabled
fix 6468287 = enabled
fix 6503543 = enabled
fix 6808773 = disabled
fix 6766962 = enabled
fix 6120483 = enabled
fix 6670551 = enabled
fix 6771838 = enabled
fix 6626018 = disabled
fix 6530596 = enabled
fix 6778642 = enabled
fix 6699059 = enabled
fix 6376551 = enabled
fix 6429113 = enabled
fix 6782437 = enabled
fix 6776808 = enabled
fix 6765823 = enabled
fix 6768660 = enabled
fix 6782665 = enabled
fix 6610822 = enabled
fix 6514189 = enabled
fix 6818410 = enabled
fix 6827696 = enabled
fix 6773613 = enabled
fix 5902962 = enabled
fix 6956212 = enabled
fix 3056297 = enabled
fix 6440977 = disabled
fix 6972291 = disabled
fix 6904146 = enabled
fix 6221403 = enabled
fix 5475051 = enabled
fix 6845871 = enabled
fix 5468809 = enabled
fix 6917633 = enabled
fix 4444536 = disabled
fix 6955210 = enabled
fix 6994194 = enabled
fix 6399597 = disabled
fix 6951776 = enabled
fix 5648287 = 3
fix 6987082 = disabled
fix 7132036 = enabled
fix 6980350 = enabled
fix 5199213 = enabled
fix 7138405 = enabled
fix 7148689 = enabled
fix 6820988 = enabled
fix 7032684 = enabled
fix 6617866 = enabled
fix 7155968 = enabled
fix 7127980 = enabled
fix 6982954 = enabled
fix 7241819 = enabled
fix 6897034 = enabled
fix 7236148 = enabled
fix 7298570 = enabled
fix 7249095 = enabled
fix 7314499 = enabled
fix 7324224 = enabled
fix 7289023 = enabled
fix 7237571 = enabled
fix 7116357 = enabled
fix 7345484 = enabled
fix 7375179 = enabled
fix 6430500 = disabled
fix 5897486 = enabled
fix 6774209 = enabled
fix 7306637 = enabled
fix 6451322 = enabled
fix 7208131 = enabled
fix 7388652 = enabled
fix 7127530 = enabled
fix 6751206 = enabled
fix 6669103 = enabled
fix 7430474 = enabled
fix 6990305 = enabled
fix 7043307 = enabled
fix 3120429 = enabled
fix 7452823 = disabled
fix 6838105 = enabled
fix 6769711 = enabled
fix 7170213 = enabled
fix 6528872 = enabled
fix 7295298 = enabled
fix 5922070 = enabled
fix 7259468 = enabled
fix 6418552 = enabled
fix 4619997 = enabled
fix 7524366 = enabled
fix 6942476 = enabled
fix 6418771 = enabled
fix 7375077 = enabled
fix 5400639 = enabled
fix 4570921 = enabled
fix 7426911 = enabled
fix 5099019 = disabled
fix 7528216 = enabled
fix 7521266 = enabled
fix 7385140 = enabled
fix 7576516 = enabled
fix 7573526 = enabled
fix 7576476 = enabled
fix 7165898 = enabled
fix 7263214 = enabled
fix 3320140 = enabled
fix 7555510 = enabled
fix 7613118 = enabled
fix 7597059 = enabled
fix 7558911 = enabled
fix 5520732 = enabled
fix 7679490 = disabled
fix 7449971 = enabled
fix 3628118 = enabled
fix 4370840 = enabled
fix 7281191 = enabled
fix 7519687 = enabled
fix 5029592 = 3
fix 6012093 = 1
fix 6053861 = disabled
fix 6941515 = disabled
fix 7696414 = enabled
fix 7272039 = enabled
fix 7834811 = enabled
fix 7640597 = enabled
fix 7341616 = enabled
fix 7168184 = enabled
fix 399198 = enabled
fix 7831070 = enabled
fix 7676897 = disabled
fix 7414637 = enabled
fix 7585456 = enabled
fix 8202421 = enabled
fix 7658097 = disabled
fix 8251486 = enabled
fix 7132684 = enabled
fix 7512227 = enabled
fix 6972987 = enabled
fix 7199035 = enabled
fix 8243446 = enabled
fix 7650462 = enabled
fix 6720701 = enabled
fix 7592673 = enabled
fix 7718694 = enabled
fix 7534027 = enabled
fix 7708267 = enabled
fix 5716785 = enabled
fix 7356191 = enabled
fix 7679161 = enabled
fix 7597159 = enabled
fix 7499258 = enabled
fix 8328363 = enabled
fix 7452863 = enabled
fix 8284930 = enabled
fix 7298626 = enabled
fix 7657126 = enabled
fix 8371884 = enabled
fix 8318020 = enabled
fix 8255423 = enabled
fix 7135745 = enabled
fix 8356253 = enabled
fix 7534257 = enabled
fix 8323407 = enabled
fix 7539815 = enabled
fix 8289316 = enabled
fix 8447850 = enabled
fix 7675944 = enabled
fix 8355120 = enabled
fix 7176746 = enabled
fix 8442891 = enabled
fix 8373261 = enabled
fix 7679164 = enabled
fix 7670533 = enabled
fix 8408665 = enabled
fix 8491399 = enabled
fix 8348392 = enabled
fix 8348585 = enabled
fix 8335178 = enabled
fix 8247017 = enabled
fix 7325597 = enabled
fix 8531490 = enabled
fix 6163600 = enabled
fix 8589278 = disabled
fix 8557992 = enabled
fix 7556098 = enabled
fix 8580883 = enabled
fix 5892599 = disabled
fix 8609714 = enabled
fix 8619631 = disabled
fix 8672915 = enabled
fix 8514561 = enabled
fix 8213977 = enabled
fix 8560951 = disabled
fix 8578587 = enabled
fix 8287870 = enabled
fix 8467123 = enabled
fix 8602185 = enabled
fix 8519457 = enabled
fix 3335182 = enabled
fix 8602840 = enabled
fix 8725296 = enabled
fix 8628970 = enabled
fix 6754080 = enabled
fix 8767442 = enabled
fix 8760135 = enabled
fix 8644935 = enabled
fix 8352378 = enabled
fix 8685327 = enabled
fix 8763472 = enabled
fix 8773324 = enabled
fix 8813674 = enabled
fix 8532236 = enabled
fix 8629716 = enabled
fix 7277732 = enabled
fix 8692170 = enabled
fix 8900973 = enabled
fix 8919133 = enabled
fix 8927050 = enabled
fix 8551880 = enabled
fix 8901237 = enabled
fix 8812372 = enabled
fix 6236862 = enabled
fix 8528517 = enabled
fix 7215982 = enabled
fix 8214022 = enabled
fix 8595392 = enabled
fix 8890233 = enabled
fix 8999317 = enabled
fix 9004800 = enabled
fix 8986163 = enabled
fix 8855396 = enabled
fix 8800514 = 20
fix 9007859 = enabled
fix 8198783 = disabled
fix 9053879 = enabled
fix 6086930 = enabled
fix 7641601 = enabled
fix 9052506 = enabled
fix 9103775 = enabled
fix 9047975 = enabled
fix 8893626 = enabled
fix 9111170 = enabled
fix 8971829 = enabled
fix 7628358 = enabled
fix 9125151 = enabled
fix 9039715 = enabled
fix 9106224 = enabled
fix 9185228 = enabled
fix 9206747 = enabled
fix 9088510 = enabled
fix 9143856 = enabled
fix 8833381 = enabled
fix 8949971 = enabled
fix 8951812 = enabled
fix 9148171 = enabled
fix 8706652 = enabled
fix 9245114 = enabled
fix 8802198 = enabled
fix 9011016 = enabled
fix 9265681 = enabled
fix 7284269 = enabled
fix 9272549 = enabled
fix 8917507 = 7
fix 8531463 = enabled
fix 9263333 = enabled
fix 8675087 = enabled
fix 8896955 = enabled
fix 9041934 = enabled
fix 9344709 = enabled
fix 9024933 = enabled
fix 9033718 = enabled
fix 9240455 = enabled
fix 9081848 = enabled
fix 5982893 = enabled
fix 9287401 = enabled
fix 8590021 = enabled
fix 9340120 = enabled
fix 9355794 = enabled
fix 9356656 = enabled
fix 9385634 = enabled
fix 9069046 = enabled
fix 9239337 = enabled
fix 9300228 = enabled
fix 9298010 = enabled
fix 9384170 = enabled
fix 9407929 = enabled
fix 8836806 = enabled
fix 9344055 = enabled
fix 9274675 = enabled
fix 9203723 = enabled
fix 9443476 = enabled
fix 9195582 = enabled
fix 8226666 = enabled
fix 9433490 = enabled
fix 9065494 = enabled
fix 9303766 = enabled
fix 9437283 = enabled
fix 9116214 = enabled
fix 9456688 = enabled
fix 9456746 = disabled
fix 9342979 = enabled
fix 9465425 = enabled
fix 9092442 = enabled
fix 4926618 = enabled
fix 8792846 = enabled
fix 9474259 = enabled
fix 9495669 = disabled
fix 6472966 = enabled
fix 6408301 = enabled
fix 9380298 = disabled
fix 8500130 = enabled
fix 9584723 = enabled
fix 9270951 = enabled
fix 9508254 = enabled
fix 9593680 = enabled
fix 9196440 = disabled
fix 9309281 = enabled
fix 8693158 = enabled
fix 9381638 = enabled
fix 9383967 = enabled
fix 7711900 = enabled
fix 9218587 = enabled
fix 9728438 = enabled
fix 9038395 = enabled
fix 9577300 = enabled
fix 9171113 = enabled
fix 8973745 = enabled
fix 9732434 = enabled
fix 8937971 = disabled
fix 9102474 = enabled
fix 9243499 = enabled
fix 9791810 = enabled
fix 9785632 = enabled
fix 9898249 = enabled
fix 9153459 = enabled
fix 9680430 = enabled
fix 9841679 = enabled
fix 9912503 = enabled
fix 9850461 = enabled
fix 9762592 = 3
fix 9716877 = enabled
fix 9814067 = enabled
fix 9776736 = enabled
fix 8349119 = enabled
fix 9958518 = enabled
fix 10041074 = enabled
fix 10004943 = enabled
fix 9980661 = enabled
fix 9554026 = enabled
fix 9593547 = enabled
fix 9833381 = enabled
fix 10043801 = enabled
fix 9940732 = enabled
fix 9702850 = enabled
fix 9659125 = 0
fix 9668086 = enabled
fix 9476520 = enabled
fix 10158107 = enabled
fix 10148457 = enabled
fix 10106423 = enabled
fix 9721439 = disabled
fix 10162430 = enabled
fix 10134677 = enabled
fix 10182051 = 3
fix 10175079 = enabled
fix 10026972 = enabled
fix 10192889 = enabled
fix 3566843 = enabled
fix 9550277 = disabled
fix 10236566 = enabled
fix 10227392 = enabled
fix 8961143 = enabled
fix 9721228 = enabled
fix 10080014 = enabled
fix 10101489 = enabled
fix 9929609 = enabled
fix 10015652 = enabled
fix 9918661 = enabled
fix 10333395 = enabled
fix 10336499 = disabled
fix 10182672 = enabled
fix 9578670 = enabled
fix 10232225 = enabled
fix 10330090 = enabled
fix 10232623 = enabled
fix 9630092 = disabled
fix 10271790 = enabled
fix 9227576 = enabled
fix 10197666 = enabled
fix 10376744 = enabled
fix 8274946 = enabled
fix 10046368 = enabled
fix 9569678 = enabled
fix 9002661 = enabled
fix 10038373 = enabled
fix 9477688 = enabled
fix 10013899 = enabled
fix 9832338 = enabled
fix 10623119 = enabled
fix 9898066 = enabled
fix 11699884 = enabled
fix 10640430 = enabled
fix 10428450 = enabled
fix 10117760 = enabled
fix 11720178 = enabled
fix 9881812 = enabled
fix 10428278 = enabled
fix 11741436 = enabled
fix 11668189 = enabled
fix 10359631 = enabled
fix 9829887 = enabled
fix 8275054 = enabled
fix 11814428 = enabled
fix 11676888 = disabled
fix 10348427 = enabled
fix 11843512 = enabled
fix 11657468 = enabled
fix 11877160 = enabled
fix 11738631 = enabled
fix 11744086 = enabled
fix 11830663 = enabled
fix 11853331 = enabled
fix 9748015 = enabled
fix 11834739 = enabled
fix 6055658 = enabled
fix 11740670 = enabled
fix 11940126 = enabled
fix 12315002 = enabled
fix 8275023 = enabled
fix 12352373 = enabled
fix 12390139 = enabled
fix 11935589 = enabled
fix 10226906 = enabled
fix 12327548 = enabled
fix 12388221 = enabled
fix 11892888 = enabled
fix 11814265 = enabled
fix 10230017 = enabled
fix 12341619 = enabled
fix 11744016 = enabled
fix 10216738 = enabled
fix 10298302 = enabled
fix 12563419 = enabled
fix 12399886 = enabled
fix 12584007 = enabled
fix 11881047 = enabled
fix 12534597 = enabled
fix 8683604 = enabled
fix 12410972 = enabled
fix 7147087 = enabled
fix 11846314 = enabled
fix 12535474 = enabled
fix 12561635 = enabled
fix 12432426 = enabled
fix 9913117 = enabled
fix 12432089 = enabled
fix 12587690 = enabled
fix 11858963 = enabled
fix 12569245 = enabled
fix 12569300 = enabled
fix 7308975 = disabled
fix 12569316 = enabled
fix 12569321 = enabled
fix 12335617 = enabled
fix 9002958 = enabled
fix 12591120 = enabled
fix 11876260 = enabled
fix 12313574 = enabled
fix 12569713 = enabled
fix 12348584 = enabled
fix 10420220 = enabled
fix 12559453 = enabled
fix 12727549 = enabled
fix 12728203 = enabled
fix 12828479 = enabled
fix 10181153 = enabled
fix 9971371 = disabled
fix 12864791 = enabled
fix 12810427 = enabled
fix 12605402 = enabled
fix 12861609 = enabled
fix 12915337 = enabled
fix 12942119 = enabled
fix 12622441 = enabled
fix 11072246 = enabled
fix 12739252 = enabled
fix 12953765 = enabled
fix 12905116 = enabled
fix 12978495 = enabled
fix 9633142 = disabled
fix 3639130 = enabled
fix 12827166 = enabled
fix 12944193 = enabled
fix 13020272 = enabled
fix 12673320 = enabled
fix 12975771 = enabled
fix 12882092 = enabled
fix 12379334 = enabled
fix 12723414 = enabled
fix 9488694 = disabled
fix 13255388 = 10
fix 11727871 = enabled
fix 13110511 = enabled
fix 13075297 = enabled
fix 13345888 = enabled
fix 11657903 = disabled
fix 13396096 = enabled
fix 12591379 = enabled
fix 13398214 = enabled
fix 13382280 = enabled
fix 12869367 = enabled
fix 12999577 = enabled
fix 12433153 = enabled
fix 9094254 = enabled
fix 13104618 = enabled
fix 13524237 = enabled
fix 11813257 = enabled
fix 13489017 = enabled
fix 12954320 = enabled
fix 13555551 = enabled
fix 13499154 = enabled
fix 13036910 = enabled
fix 13545925 = enabled
fix 13545956 = enabled
fix 13545989 = enabled
fix 12839247 = enabled
fix 9858777 = enabled
fix 13568366 = enabled
fix 13393357 = enabled
fix 13040171 = enabled
fix 13406619 = enabled
fix 13594757 = enabled
fix 13543207 = enabled
fix 13594712 = enabled
fix 12648629 = enabled
fix 13549808 = enabled
fix 13634700 = enabled
fix 8792821 = enabled
fix 13454409 = enabled
fix 13146487 = enabled
fix 13592248 = enabled
fix 11689541 = enabled
fix 13527374 = enabled
fix 13430622 = enabled
fix 13704562 = enabled
fix 9547706 = enabled
fix 13497184 = enabled
fix 13704977 = enabled
fix 13734456 = enabled
fix 13070532 = enabled
fix 6520878 = enabled
fix 2273284 = enabled
fix 13786127 = enabled
fix 13065064 = enabled
fix 13972896 = enabled
fix 11843466 = enabled
fix 13777823 = enabled
fix 13616573 = enabled
fix 13831671 = enabled
fix 13652216 = enabled
fix 13912192 = enabled
fix 13909909 = enabled
fix 13849486 = enabled
fix 13321547 = enabled
fix 13886606 = disabled
fix 14013502 = enabled
fix 13850256 = enabled
fix 13929275 = enabled
fix 11732303 = enabled
fix 13906168 = enabled
fix 14055128 = enabled
fix 12856200 = enabled
fix 14008590 = enabled
fix 13627489 = disabled
fix 13961105 = enabled
fix 13583722 = enabled
fix 13076238 = enabled
fix 13936229 = enabled
fix 9852856 = enabled
fix 3904125 = enabled
fix 5910187 = enabled
fix 10068316 = enabled
fix 14029891 = enabled
fix 4215125 = enabled
fix 13711083 = enabled
fix 13973691 = enabled
fix 13486825 = enabled
fix 13682550 = enabled
fix 13826669 = enabled
fix 14033181 = enabled
fix 13836796 = enabled
fix 12555499 = enabled
fix 13568506 = enabled
fix 9891396 = enabled
fix 13699643 = enabled
fix 13835788 = enabled
fix 7271518 = enabled
fix 14127824 = enabled
fix 12557401 = enabled
fix 13350470 = enabled
fix 14095362 = enabled
fix 13000118 = enabled
fix 14254795 = enabled
fix 14012261 = enabled
fix 14241953 = enabled
fix 14221012 = enabled
fix 13329748 = enabled
fix 13843964 = enabled
fix 14254052 = enabled
fix 13814866 = enabled
fix 14255600 = disabled
fix 13735304 = enabled
fix 14142884 = disabled
fix 12909121 = enabled
fix 14464068 = enabled
fix 14295250 = 45000
fix 6873091 = enabled
fix 13448445 = enabled
fix 14155722 = enabled
fix 14098180 = enabled
fix 11905801 = enabled
fix 14467202 = enabled
fix 14541122 = enabled
fix 13905599 = disabled
fix 14320077 = enabled
fix 14243782 = enabled
fix 9114915 = enabled
fix 14516175 = enabled
fix 12812697 = enabled
fix 13109345 = enabled
fix 14456124 = enabled
fix 14605040 = enabled
fix 14595273 = disabled
fix 14176247 = enabled
fix 11894476 = enabled
fix 14256885 = enabled
fix 14545269 = disabled
fix 14668404 = disabled
fix 14144611 = enabled
fix 14346182 = enabled
fix 13083139 = enabled
fix 14726188 = enabled
fix 14707009 = enabled
fix 14703133 = enabled
fix 14618560 = enabled
fix 14170552 = enabled
fix 13263174 = enabled
fix 14669785 = enabled
fix 14633570 = enabled
fix 14755138 = enabled
fix 14682092 = enabled
fix 14712222 = enabled
fix 14570575 = enabled
fix 14707748 = disabled
fix 14684079 = enabled
fix 13245379 = enabled
fix 13853916 = enabled
fix 13699007 = enabled
fix 14843189 = enabled
fix 14147762 = enabled
fix 14795969 = enabled
fix 14746036 = 1
fix 14750501 = enabled
fix 13891981 = enabled
fix 15996520 = enabled
fix 16026776 = enabled
fix 13573073 = enabled
fix 13263455 = enabled
fix 16053273 = enabled
fix 16029607 = enabled
fix 14242833 = enabled
fix 13362020 = enabled
fix 13799389 = enabled
fix 12693573 = enabled
fix 15998585 = enabled
fix 16166364 = enabled
fix 14723910 = enabled
fix 15873008 = enabled
fix 14133928 = enabled
fix 16085999 = enabled
fix 14176203 = enabled
fix 16226575 = enabled
fix 16015637 = enabled
fix 15968693 = disabled
fix 16220895 = enabled
fix 16178821 = enabled
fix 11865196 = enabled
fix 16237969 = enabled
fix 16058481 = enabled
fix 13361493 = enabled
fix 16264537 = enabled
fix 14401107 = enabled
fix 13943459 = enabled
fix 13994546 = enabled
fix 7174435 = enabled
fix 14750443 = enabled
fix 14469756 = enabled
fix 14552075 = enabled
fix 16324844 = enabled
fix 13583529 = enabled
fix 14565911 = enabled
fix 13526551 = enabled
fix 16368002 = enabled
fix 16077770 = enabled
fix 16419357 = enabled
fix 15889476 = disabled
fix 16273483 = enabled
fix 16496848 = disabled
fix 14107333 = enabled
fix 11814337 = enabled
fix 15882436 = enabled
fix 14764840 = enabled
fix 16226660 = enabled
fix 16555865 = enabled
fix 16625151 = enabled
fix 16092378 = enabled
fix 16487030 = enabled
fix 9552303 = enabled
fix 16609749 = enabled
fix 16751246 = enabled
fix 13253977 = enabled
fix 14058291 = disabled
fix 16749025 = enabled
fix 16750067 = enabled
fix 16726844 = enabled
fix 15899648 = enabled
fix 16690013 = enabled
fix 15996156 = enabled
fix 16544878 = enabled
fix 9413591 = disabled
fix 16792882 = 0
fix 16725982 = enabled
fix 14648222 = enabled
fix 16799181 = enabled
fix 16516883 = enabled
fix 16507317 = enabled
fix 16837274 = enabled
fix 14085520 = enabled
fix 16713081 = enabled
fix 14703295 = enabled
fix 16908409 = enabled
fix 16212250 = enabled
fix 13692395 = disabled
fix 17087729 = enabled
fix 17088819 = enabled
fix 13848786 = enabled
fix 13522189 = enabled
fix 16400122 = enabled
fix 16796185 = enabled
fix 15950252 = enabled
fix 17070464 = enabled
fix 16976121 = enabled
fix 14580303 = enabled
fix 16554552 = enabled
fix 16582322 = enabled
fix 16712213 = enabled
fix 17382690 = enabled
fix 14846352 = enabled
fix 16516751 = enabled
fix 3174223 = enabled
fix 8611462 = enabled
fix 14851437 = 3
fix 17348895 = enabled
fix 16515789 = enabled
fix 5451645 = disabled
fix 14062749 = enabled
fix 16346018 = enabled
fix 12977599 = enabled
fix 14191778 = enabled
fix 15939321 = enabled
fix 16874299 = enabled
fix 16470836 = enabled
fix 16805362 = disabled
fix 17442009 = disabled
fix 16825679 = enabled
fix 17543180 = enabled
fix 17301564 = enabled
fix 12373708 = enabled
fix 17397506 = enabled
fix 14558315 = enabled
fix 16615686 = enabled
fix 16622801 = enabled
fix 10038517 = enabled
fix 16954950 = enabled
fix 17728161 = enabled
fix 17760375 = enabled
fix 14311185 = enabled
fix 13077335 = disabled
fix 13458979 = disabled
fix 17485514 = enabled
fix 17599514 = enabled
fix 17640863 = enabled
fix 17716301 = enabled
fix 17368047 = disabled
fix 17597748 = enabled
fix 17303359 = enabled
fix 17376322 = disabled
fix 16391176 = disabled
fix 16673868 = enabled
fix 17800514 = enabled
fix 14826303 = enabled
fix 17663076 = enabled
fix 17760755 = enabled
fix 17793460 = enabled
fix 17997159 = enabled
fix 17938754 = enabled
fix 14733442 = enabled
fix 17727676 = enabled
fix 17781659 = enabled
fix 17526569 = enabled
fix 17950612 = enabled
fix 17760686 = enabled
fix 17696414 = enabled
fix 17799716 = enabled
fix 18116777 = enabled
fix 18159664 = disabled
fix 16052625 = enabled
fix 18091750 = enabled
fix 17572606 = enabled
fix 17971955 = enabled
fix 17946915 = enabled
fix 18196576 = enabled
fix 10145667 = enabled
fix 17736165 = enabled
fix 16434021 = enabled
fix 18035463 = enabled
fix 18011820 = enabled
fix 16405740 = enabled
fix 14612201 = enabled
fix 17491018 = enabled
fix 18365267 = enabled
fix 17986549 = enabled
fix 18115594 = enabled
fix 18182018 = enabled
fix 18302923 = enabled
fix 18377553 = enabled
fix 5677419 = enabled
fix 17896018 = disabled
fix 13097308 = enabled
fix 17863980 = enabled
fix 17567154 = enabled
fix 18398980 = enabled
fix 17023040 = enabled
fix 17991403 = 1
fix 16033838 = enabled
fix 17908541 = enabled
fix 18134680 = enabled
fix 18405517 = 0
fix 18304693 = enabled
fix 18456944 = enabled
fix 18467455 = enabled
fix 18425876 = enabled
fix 18508675 = enabled
fix 17473046 = disabled
fix 18636079 = enabled
fix 18388128 = enabled
fix 18415557 = enabled
fix 18385778 = enabled
fix 18308329 = enabled
fix 18461984 = enabled
fix 17973658 = enabled
fix 18558952 = enabled
fix 9912950 = enabled
fix 18751128 = enabled
fix 16809786 = enabled
fix 18795224 = enabled
fix 14776289 = enabled
fix 18823135 = enabled
fix 18874242 = enabled
fix 18770199 = disabled
fix 4185270 = disabled
fix 18765574 = enabled
fix 18754357 = disabled
fix 18959892 = enabled
fix 17324379 = disabled
fix 18952882 = enabled
fix 18924221 = enabled
fix 18422714 = enabled
fix 18798414 = enabled
fix 18969167 = enabled
fix 16191689 = enabled
fix 18907562 = enabled
fix 19055664 = enabled
fix 18898582 = enabled
fix 18960760 = enabled
fix 19070454 = enabled
fix 19230097 = enabled
fix 19063497 = enabled
fix 19046459 = enabled
fix 19269482 = enabled
fix 18876528 = enabled
fix 19227996 = enabled
fix 18864613 = enabled
fix 19239478 = enabled
fix 19451895 = enabled
fix 19450139 = enabled
fix 18907390 = enabled
fix 19025959 = enabled
fix 19309574 = enabled
fix 16774698 = enabled
fix 16923858 = 6
fix 19546825 = enabled
fix 19475484 = enabled
fix 19498595 = enabled
fix 16934526 = enabled
fix 19287919 = enabled
fix 19386746 = enabled
fix 19774486 = enabled
fix 19803410 = enabled
fix 18671960 = enabled
fix 19484911 = enabled
fix 19731940 = enabled
fix 19604408 = enabled
fix 14402409 = enabled
fix 16486095 = enabled
fix 19563657 = enabled
fix 19632232 = enabled
fix 19889960 = enabled
fix 17208933 = enabled
fix 19710102 = enabled
fix 18697515 = enabled
fix 18318631 = enabled
fix 19377983 = enabled
fix 20078639 = enabled
fix 19503668 = enabled
fix 20124288 = enabled
fix 19847091 = enabled
fix 12989345 = enabled
fix 12618642 = enabled
fix 19779920 = enabled
fix 20186282 = enabled
fix 20186295 = enabled
fix 19563433 = enabled
fix 19848804 = enabled
fix 20046257 = enabled
fix 20265690 = enabled
fix 16047938 = enabled
fix 19507904 = enabled
fix 18915345 = enabled
fix 20173686 = disabled
fix 20329321 = enabled
fix 20225191 = enabled
fix 18776755 = enabled
fix 19882842 = enabled
fix 20010996 = enabled
fix 20445764 = disabled
fix 19728543 = disabled
fix 20379571 = enabled
fix 20129763 = enabled
fix 19899588 = enabled
fix 10098852 = enabled
fix 19663421 = disabled
fix 20355502 = 0
fix 20526705 = enabled
fix 20465582 = enabled
fix 20581886 = disabled
fix 16732417 = enabled
fix 20732410 = enabled
fix 20289688 = enabled
fix 20543684 = enabled
fix 20636003 = enabled
fix 20506136 = enabled
fix 20458598 = disabled
fix 20830312 = enabled
fix 19768896 = enabled
fix 20321661 = enabled
fix 19814541 = enabled
fix 20933264 = enabled
fix 17443547 = enabled
fix 20602794 = enabled
fix 19123152 = enabled
fix 19899833 = enabled
fix 20754928 = enabled
fix 20808265 = enabled
fix 20808192 = enabled
fix 20340595 = enabled
fix 14474264 = disabled
fix 20508819 = enabled
fix 21098866 = disabled
fix 18949550 = enabled
fix 14775297 = enabled
fix 19568958 = disabled
fix 20923950 = enabled
fix 21283159 = enabled
fix 17497847 = enabled
fix 21211629 = enabled
fix 20819668 = disabled
fix 20232513 = enabled
fix 20906782 = enabled
fix 20587527 = enabled
fix 20914534 = disabled
fix 20830544 = enabled
fix 16851194 = enabled
fix 19186783 = enabled
fix 19653920 = enabled
fix 21211786 = enabled
fix 21057343 = enabled
fix 21503478 = enabled
fix 19808939 = disabled
fix 21476032 = enabled
fix 20859246 = enabled
fix 20838633 = 2
fix 21639419 = enabled
fix 20951803 = enabled
fix 21683982 = enabled
fix 20216500 = enabled
fix 21614112 = enabled
fix 20906162 = enabled
fix 20854798 = enabled
fix 21509656 = enabled
fix 21833220 = enabled
fix 21802552 = enabled
fix 21452843 = enabled
fix 21553593 = enabled
fix 21093805 = enabled
fix 16220085 = disabled
fix 21800590 = enabled
fix 21273039 = enabled
fix 16750133 = enabled
fix 22013607 = enabled
fix 22152372 = enabled
fix 22077191 = enabled
fix 22123025 = enabled
fix 16913734 = enabled
fix 8357294 = enabled
fix 12670904 = enabled
fix 21979983 = enabled
fix 22158526 = enabled
fix 21971099 = enabled
fix 22090662 = enabled
fix 22149010 = disabled
fix 21300129 = enabled
fix 21339278 = enabled
fix 20270511 = enabled
fix 21424812 = enabled
fix 22114090 = enabled
fix 22310074 = disabled
fix 22159570 = enabled
fix 22272439 = enabled
fix 22372694 = enabled
fix 22514195 = enabled
fix 20413540 = enabled
fix 22520315 = enabled
fix 22649054 = enabled
fix 8617254 = enabled
fix 22020067 = enabled
fix 22864730 = enabled
fix 21099502 = enabled
fix 22904304 = enabled
fix 22967807 = enabled
fix 22879002 = enabled
fix 23019286 = enabled
fix 22760704 = enabled
fix 20853506 = enabled
fix 22540411 = disabled
fix 22513493 = enabled
fix 22518491 = enabled
fix 23103096 = enabled
fix 22143411 = enabled
fix 23180670 = enabled
fix 23002609 = enabled
fix 22928015 = 1
fix 23210039 = enabled
fix 23102649 = enabled
fix 23071621 = enabled
fix 22822245 = enabled
fix 23136865 = enabled
fix 23176721 = enabled
fix 23308385 = enabled
fix 23223113 = enabled
fix 22301868 = disabled
fix 22258300 = enabled
fix 22205301 = enabled
fix 23514473 = 1
fix 23556483 = enabled
fix 21305617 = enabled
fix 22533539 = enabled
fix 23596611 = enabled
fix 20347374 = disabled
fix 22937293 = enabled
fix 20107874 = enabled
fix 19582337 = enabled
fix 22746853 = enabled
fix 23537232 = enabled
fix 23565188 = enabled
fix 20228468 = enabled
fix 22393169 = enabled
fix 24426912 = enabled
fix 24690046 = enabled
fix 23732552 = enabled
fix 20648883 = enabled
fix 24654471 = enabled
fix 23738304 = enabled
fix 24010030 = enabled
fix 22766607 = enabled
fix 24600280 = enabled
fix 24845754 = enabled
fix 24533235 = enabled
fix 22128803 = enabled
fix 24926999 = enabled
fix 24434608 = enabled
fix 25094218 = enabled
fix 24819957 = enabled
fix 23478835 = enabled
fix 24745366 = enabled
fix 24920138 = disabled
fix 24570810 = enabled
fix 25058954 = enabled
fix 24518392 = enabled
fix 23738186 = enabled
fix 25234139 = enabled
fix 25108065 = enabled
fix 22212124 = enabled
fix 25123105 = enabled
fix 25078728 = enabled
fix 23719498 = 0
fix 25090203 = enabled
fix 23197730 = enabled
fix 23738553 = enabled
fix 22070473 = enabled
fix 19956351 = enabled
fix 25393617 = enabled
fix 21130817 = enabled
fix 25342352 = enabled
fix 25167306 = disabled
fix 23473108 = enabled
fix 25501716 = enabled
fix 22973474 = enabled
fix 22153026 = enabled
fix 25367727 = enabled
fix 25477783 = enabled
fix 25493582 = enabled
fix 22205362 = enabled
fix 23249829 = enabled
fix 25120742 = enabled
fix 23853877 = disabled
fix 25796244 = enabled
fix 25575369 = enabled
fix 25643889 = disabled
fix 25436615 = enabled
fix 25478095 = enabled
fix 25405100 = enabled
fix 24952618 = enabled
fix 25809211 = enabled
fix 26094674 = enabled
fix 21183079 = enabled
fix 25948370 = enabled
fix 24545933 = enabled
fix 25926263 = enabled
fix 26019148 = enabled
fix 25995431 = enabled
fix 21870589 = enabled
fix 24584046 = enabled
fix 26374214 = enabled
fix 25476149 = enabled
fix 25345279 = enabled
fix 24478915 = enabled
fix 26541991 = enabled
fix 26338880 = enabled
fix 26270685 = disabled
fix 26560136 = enabled
fix 26671842 = enabled
fix 26712343 = enabled
fix 26585420 = enabled
fix 26677151 = enabled
fix 26367868 = enabled
fix 25323193 = disabled
fix 26552730 = disabled
fix 26177646 = enabled
fix 23643560 = enabled
fix 25792706 = enabled
fix 27057772 = disabled
fix 26986173 = enabled
fix 26423085 = enabled
fix 27077069 = enabled
fix 26536320 = enabled
fix 25138211 = enabled
fix 27321179 = enabled
fix 27343844 = enabled
fix 26790514 = enabled
fix 27282295 = enabled
fix 27432718 = enabled
fix 27268249 = enabled
fix 25507796 = enabled
fix 25507810 = enabled
fix 25507823 = disabled
fix 25507828 = enabled
fix 25660695 = enabled
fix 27311177 = enabled
fix 24841671 = enabled
fix 26842212 = enabled
fix 27559630 = enabled
fix 27436816 = enabled
fix 23098284 = enabled
fix 26660568 = enabled
fix 27693205 = enabled
fix 27096140 = disabled
fix 27174324 = enabled
fix 27000158 = enabled
fix 27208525 = enabled
fix 27745220 = enabled
fix 26527656 = enabled
fix 27675947 = disabled
fix 26566785 = enabled
fix 27175987 = enabled
fix 8932139 = enabled
fix 18816560 = enabled
fix 27466597 = enabled
fix 27210659 = enabled
fix 27643128 = enabled
fix 27782339 = enabled
fix 24761824 = enabled
fix 27634227 = enabled
fix 26733841 = enabled
fix 27971253 = enabled
fix 22174392 = enabled
fix 27730925 = enabled
fix 22559379 = enabled
fix 27622097 = enabled
fix 20424684 = enabled
fix 27593424 = enabled
fix 28096482 = enabled
fix 24573561 = enabled
fix 22582700 = enabled
fix 28201419 = enabled
fix 26836964 = disabled
fix 27991474 = enabled
fix 28210382 = enabled
fix 27500916 = enabled
fix 28012754 = 7
fix 28071742 = enabled
fix 27836278 = enabled
fix 28256899 = enabled
fix 28345522 = 0
fix 28084251 = enabled
fix 23058521 = enabled
fix 28242450 = enabled
fix 28135957 = enabled
fix 27680422 = 1
fix 28378804 = enabled
fix 28660798 = enabled
fix 28606162 = disabled
fix 28816113 = enabled
fix 27541468 = enabled
fix 28725660 = enabled
fix 29450812 = disabled
fix 29687220 = disabled
fix 28072567 = enabled
fix 28835937 = enabled
fix 29331066 = disabled
fix 30232638 = disabled
fix 28498976 = disabled
fix 28965084 = disabled
fix 28776811 = disabled
fix 28567417 = disabled
fix 28558645 = disabled
fix 29132869 = disabled
fix 29939400 = disabled
fix 30001331 = disabled
fix 28776431 = disabled
fix 28144569 = disabled
fix 30028663 = 0
fix 29304314 = disabled
fix 29653132 = disabled
fix 29930457 = disabled
fix 28602253 = disabled
fix 30347410 = disabled
fix 29937655 = disabled
fix 30602828 = disabled
fix 30896685 = disabled
fix 31069997 = disabled
fix 31077481 = disabled
fix 27261477 = disabled
fix 30972817 = disabled
fix 30222669 = disabled
fix 31444353 = 0
fix 30998035 = disabled
fix 30198239 = 0
fix 29487407 = disabled
fix 29302565 = disabled
fix 30486896 = disabled
fix 19138896 = disabled
fix 30681521 = 0
fix 28999046 = disabled
fix 30902655 = disabled
fix 30786641 = disabled
fix 31895670 = disabled
fix 30616738 = disabled
fix 31668694 = disabled
fix 31001490 = disabled
fix 30980115 = disabled
fix 31670824 = disabled
fix 30570982 = disabled
fix 9876287 = disabled
fix 30564898 = disabled
fix 32075777 = disabled
fix 32037237 = disabled
fix 30927440 = disabled
fix 30822446 = disabled
fix 24561942 = disabled
fix 31625959 = disabled
fix 31579233 = disabled
fix 29696242 = disabled
fix 31626438 = disabled
fix 30228422 = disabled
fix 17295505 = disabled
fix 29725425 = disabled
fix 30618230 = disabled
fix 30008456 = 0
fix 30537403 = disabled
fix 30235878 = disabled
fix 30646077 = disabled
fix 29657973 = disabled
fix 29712727 = disabled
fix 20922160 = disabled
fix 30006705 = disabled
fix 29463553 = disabled
fix 30751171 = disabled
fix 31009032 = disabled
fix 30063629 = disabled
fix 30207519 = disabled
fix 31517502 = disabled
fix 30617002 = disabled
fix 30483217 = disabled
fix 30235691 = disabled
fix 30568514 = disabled
fix 28414968 = 0
fix 32014520 = disabled
fix 30249927 = disabled
fix 31580374 = disabled
fix 29590666 = disabled
fix 29435966 = disabled
fix 28173995 = disabled
fix 29867728 = disabled
fix 30776676 = disabled
fix 26577716 = disabled
fix 30470947 = disabled
fix 30979701 = disabled
fix 30483184 = disabled
fix 31001295 = disabled
fix 31191224 = disabled
fix 31974424 = disabled
fix 29385774 = disabled
fix 28234255 = 3
Query Block Registry:
SEL$1 0xf3191e60 (PARSER) [FINAL]
:
call(in-use=22632, alloc=117496), compile(in-use=119728, alloc=180800), execution(in-use=12552, alloc=16200)
End of Optimizer State Dump
Dumping Hints
=============
====================== END SQL Statement Dump ======================
Raw
before.trc
Trace file /u01/app/oracle/diag/rdbms/racdbb/racdbb1/trace/racdbb1_ora_335870_BEFORE.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
Build label: RDBMS_19.11.0.0.0DBRU_LINUX.X64_210412
ORACLE_HOME: /u01/app/oracle/product/19.3.0/dbhome_2
System name: Linux
Node name: rac1.mycompany.mydomain
Release: 5.4.17-2136.308.9.el8uek.x86_64
Version: #2 SMP Mon Jun 13 20:36:40 PDT 2022
Machine: x86_64
Instance name: racdbb1
Redo thread mounted by this instance: 1
Oracle process number: 99
Unix process pid: 335870, image: oracle@rac1.mycompany.mydomain
*** 2022-08-11T15:51:32.028207+00:00 (PDBB1(3))
*** SESSION ID:(359.42854) 2022-08-11T15:51:32.028225+00:00
*** CLIENT ID:() 2022-08-11T15:51:32.028228+00:00
*** SERVICE NAME:(pdbb1) 2022-08-11T15:51:32.028231+00:00
*** MODULE NAME:(SQL*Plus) 2022-08-11T15:51:32.028234+00:00
*** ACTION NAME:() 2022-08-11T15:51:32.028236+00:00
*** CLIENT DRIVER:(SQL*PLUS) 2022-08-11T15:51:32.028238+00:00
*** CONTAINER ID:(3) 2022-08-11T15:51:32.028241+00:00
Registered qb: SEL$1 0xf3191e60 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$1 nbfros=1 flg=0
fro(0): flg=4 objn=23726 hint_alias="T1"@"SEL$1"
SPM: statement not found in SMB
SPM: capture of plan baseline is OFF
kkoctx(): choosing CBO since query or involved objects are eligible for the same
**************************
Automatic degree of parallelism (AUTODOP)
**************************
Automatic degree of parallelism is disabled: Parameter.
kkopqSetForceParallelProperties: Hint:no
Query: compute:yes forced:no forceDop:0
Global Manual Dop: 1 - Rounded?: no
PM: Considering predicate move-around in query block SEL$1 (#0)
**************************
Predicate Move-Around (PM)
**************************
OPTIMIZER INFORMATION
******************************************
----- Current SQL Statement for this session (sql_id=9s014c27wfym3) -----
select max(id) from t1
*******************************************
Legend
The following abbreviations are used by optimizer trace.
CBQT - cost-based query transformation
JPPD - join predicate push-down
OJPPD - old-style (non-cost-based) JPPD
FPD - filter push-down
PM - predicate move-around
CVM - complex view merging
SPJ - select-project-join
SJC - set join conversion
SU - subquery unnesting
OBYE - order by elimination
OST - old style star transformation
ST - new (cbqt) star transformation
CNT - count(col) to count(*) transformation
JE - Join Elimination
JF - join factorization
CBY - connect by
SLP - select list pruning
DP - distinct placement
VT - vector transformation
AAT - Approximate Aggregate Transformation
ORE - CBQT OR-Expansion
LORE - Legacy OR-Expansion
qb - query block
LB - leaf blocks
DK - distinct keys
LB/K - average number of leaf blocks per key
DB/K - average number of data blocks per key
CLUF - clustering factor
NDV - number of distinct values
Resp - response cost
Card - cardinality
Resc - resource cost
NL - nested loops (join)
SM - sort merge (join)
HA - hash (join)
CPUSPEED - CPU Speed
IOTFRSPEED - I/O transfer speed
IOSEEKTIM - I/O seek time
SREADTIM - average single block read time
MREADTIM - average multiblock read time
MBRC - average multiblock read count
MAXTHR - maximum I/O system throughput
SLAVETHR - average slave I/O throughput
dmeth - distribution method
1: no partitioning required
2: value partitioned
4: right is random (round-robin)
128: left is random (round-robin)
8: broadcast right and partition left
16: broadcast left and partition right
32: partition left using partitioning of right
64: partition right using partitioning of left
256: run the join in serial
0: invalid distribution method
sel - selectivity
ptn - partition
AP - adaptive plans
***************************************
PARAMETERS USED BY THE OPTIMIZER
********************************
*************************************
PARAMETERS WITH ALTERED VALUES
******************************
Compilation Environment Dump
sqlstat_enabled = true
statistics_level = all
total_processor_group_count = 2
Bug Fix Control Environment
*************************************
PARAMETERS WITH DEFAULT VALUES
******************************
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 19.1.0
_optimizer_search_limit = 5
cpu_count = 8
active_instance_count = 2
parallel_threads_per_cpu = 1
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 1572864 KB
_pga_max_size = 314560 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 1024 KB
_smm_max_size_static = 157280 KB
_smm_px_max_size_static = 786432 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 19.1.0
parallel_query_mode = enabled
_enable_parallel_dml = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 100
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 128
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 16
total_cpu_count = 16
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
_parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 0
_px_cpu_autodop_enabled = true
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 256
_use_hidden_partitions = 0
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 0
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 129
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_distinct_agg_optimization_gsets = choose
_array_cdb_view_enabled = true
_optimizer_adaptive_plan_control = 0
_optimizer_adaptive_random_seed = 0
_optimizer_cbqt_or_expansion = on
_inmemory_dbg_scan = 0
_gby_vector_aggregation_enabled = true
_optimizer_vector_transformation = true
_optimizer_vector_fact_dim_ratio = 10
_key_vector_max_size = 0
_key_vector_predicate_enabled = true
_key_vector_predicate_threshold = 0
_vector_operations_control = 0
_optimizer_vector_min_fact_rows = 10000000
parallel_dblink = 0
_px_scalable_invdist = true
_key_vector_offload = predicate
_optimizer_aggr_groupby_elim = true
_optimizer_reduce_groupby_key = true
_vector_serialize_temp_threshold = 1000
_always_vector_transformation = false
_optimizer_cluster_by_rowid_batched = true
_object_link_fixed_enabled = true
optimizer_inmemory_aware = true
_optimizer_inmemory_table_expansion = true
_optimizer_inmemory_gen_pushable_preds = true
_optimizer_inmemory_autodop = true
_optimizer_inmemory_access_path = true
_optimizer_inmemory_bloom_filter = true
_parallel_inmemory_min_time_threshold = 1
_parallel_inmemory_time_unit = 1
_rc_sys_obj_enabled = true
_optimizer_nlj_hj_adaptive_join = true
_indexable_con_id = true
_bloom_serial_filter = on
inmemory_force = default
inmemory_query = enable
_inmemory_query_scan = true
_inmemory_query_fetch_by_rowid = false
_inmemory_pruning = on
_px_autodop_pq_overhead = true
_px_external_table_default_stats = true
_optimizer_key_vector_aggr_factor = 75
_optimizer_vector_cost_adj = 100
_cdb_cross_container = 65535
_cdb_view_parallel_degree = 65535
_optimizer_hll_entry = 4096
_px_cdb_view_join_enabled = true
inmemory_size = 0
_external_table_smart_scan = hadoop_only
_optimizer_inmemory_minmax_pruning = true
_approx_cnt_distinct_gby_pushdown = choose
_approx_cnt_distinct_optimization = 0
_optimizer_ads_use_partial_results = true
_query_execution_time_limit = 0
_optimizer_inmemory_cluster_aware_dop = true
_optimizer_db_blocks_buffers = 0 KB
_query_rewrite_use_on_query_computation = true
_px_scalable_invdist_mcol = true
_optimizer_bushy_join = off
_optimizer_bushy_fact_dim_ratio = 20
_optimizer_bushy_fact_min_size = 100000
_optimizer_bushy_cost_factor = 100
_rmt_for_table_redef_enabled = true
_optimizer_eliminate_subquery = true
_sqlexec_cache_aware_hash_join_enabled = true
_zonemap_usage_tracking = true
_sqlexec_hash_based_distagg_enabled = false
_sqlexec_disable_hash_based_distagg_tiv = false
_sqlexec_hash_based_distagg_ssf_enabled = true
_sqlexec_distagg_optimization_settings = 0
approx_for_aggregation = false
approx_for_count_distinct = false
_optimizer_union_all_gsets = true
_rowsets_use_encoding = true
_rowsets_max_enc_rows = 64
_optimizer_enhanced_join_elimination = true
_optimizer_multicol_join_elimination = true
_key_vector_create_pushdown_threshold = 20000
_optimizer_enable_plsql_stats = true
_recursive_with_parallel = true
_recursive_with_branch_iterations = 7
_px_dist_agg_partial_rollup_pushdown = adaptive
_px_adaptive_dist_bypass_enabled = true
_enable_view_pdb = true
_optimizer_key_vector_pruning_enabled = true
_pwise_distinct_enabled = true
_recursive_with_using_temp_table = false
_partition_read_only = true
_sql_alias_scope = true
_cdb_view_no_skip_migrate = false
_approx_perc_sampling_err_rate = 2
_sqlexec_encoding_aware_hj_enabled = true
rim_node_exist = 0
_enable_containers_subquery = true
_force_containers_subquery = false
_cell_offload_vector_groupby = true
_vector_encoding_mode = manual
_ds_xt_split_count = 1
_ds_sampling_method = PROGRESSIVE
_optimizer_ads_use_spd_cache = true
_optimizer_use_table_scanrate = HADOOP_ONLY
_optimizer_use_xt_rowid = true
_xt_sampling_scan_granules = on
_recursive_with_control = 0
_sqlexec_use_rwo_aware_expr_analysis = true
_optimizer_band_join_aware = true
_optimizer_vector_base_dim_fact_factor = 200
approx_for_percentile = none
_approx_percentile_optimization = 0
_projection_pushdown = true
_px_object_sampling = 200
_optimizer_adaptive_plans_continuous = false
_optimizer_adaptive_plans_iterative = false
_ds_enable_view_sampling = true
_optimizer_generate_ptf_implied_preds = true
_optimizer_inmemory_use_stored_stats = AUTO
_cdb_special_old_xplan = true
uniaud_internal_cursor = 0
_kd_dbg_control = 0
_mv_access_compute_fresh_data = on
_bloom_filter_ratio = 35
_optimizer_control_shard_qry_processing = 65528
containers_parallel_degree = 65535
sql_from_coordinator = 0
_xt_sampling_scan_granules_min_granules = 1
_in_memory_cdt = LIMITED
_in_memory_cdt_maxpx = 4
_px_partition_load_dist_threshold = 64
_px_adaptive_dist_bypass_optimization = 1
_optimizer_interleave_or_expansion = true
optimizer_adaptive_plans = true
optimizer_adaptive_statistics = false
_optimizer_use_feedback_for_join = false
_optimizer_ads_for_pq = false
_px_join_skewed_values_count = 0
optimizer_ignore_parallel_hints = false
parallel_min_degree = 1
_px_nlj_bcast_rr_threshold = 10
_optimizer_gather_stats_on_load_all = false
_optimizer_gather_stats_on_load_hist = false
_optimizer_allow_all_access_paths = true
_key_vector_double_enabled = true
_key_vector_timestamp_enabled = true
_optimizer_answering_query_using_stats = false
_disable_dblink_optim = true
_cell_offload_hybrid_processing = true
_read_optimized_table_lookup = true
_optimizer_key_vector_payload = true
_optimizer_vector_fact_payload_ratio = 20
_bloom_pruning_setops_enabled = true
_bloom_filter_setops_enabled = true
_key_vector_shared_dgk_ht = true
_px_pwise_wif_enabled = true
_sqlexec_reorder_wif_enabled = true
_px_partition_skew_threshold = 80
_sqlexec_pwiseops_with_sqlfuncs_enabled = true
_sqlexec_pwiseops_with_binds_enabled = true
_px_shared_hash_join = false
_px_reuse_server_groups = multi
_px_join_skew_null_handling = true
_px_join_skew_use_histogram = true
_px_join_skew_sampling_time_limit = 50
_px_join_skew_sampling_percent = 0
_cdb_view_no_skip_restricted = false
_inmemory_external_table = true
_sqlexec_use_kgghash3 = true
_cell_offload_vector_groupby_force = false
_hcs_enable_pred_push = true
parallel_dop_doubled = 0
_optimizer_gather_stats_on_load_index = true
_con_map_sql_enforcement = true
_uniq_cons_sql_enforcement = true
_ref_cons_sql_enforcement = true
_is_lock_table_for_split_merge = 0
_cell_offload_vector_groupby_fact_key = true
_px_scalable_gby_invdist = true
_px_dynamic_granules = true
_px_dynamic_granules_adjust = 10
_px_hybrid_partition_execution_enabled = true
_px_hybrid_partition_skew_threshold = 10
_optimizer_key_vector_use_max_size = 1048576
_cell_offload_vector_groupby_withnojoin = true
_key_vector_join_pushdown_enabled = true
_cell_offload_grand_total = true
_optimizer_key_vector_payload_dim_aggs = false
_optimizer_use_auto_indexes = AUTO
_optimizer_use_stats_on_conventional_dml = false
_optimizer_gather_stats_on_conventional_dml = false
_optimizer_use_stats_on_conventional_config = 0
_skip_pset_col_chk = 0
_nls_binary = true
_optimizer_quarantine_sql = true
_optimizer_gather_stats_on_conventional_config = 0
_nls_forced_binary = 0
_utl32k_mv_query = false
optimizer_session_type = NORMAL
BlockChain_ledger_infrastructure = 0
_cell_offload_vector_groupby_external = true
_bigdata_offload_flag = false
container_data = ALL
optimizer_real_time_statistics = false
_update_global_index_from_part_exchange = 0
***************************************
PARAMETERS IN OPT_PARAM HINT
****************************
***************************************
Column Usage Monitoring is ON: tracking level = 53
***************************************
Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
JF: Checking validity of join factorization for query block SEL$1 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$1 (#0)
TE: Bypassed: No relevant table found.
ORE: Checking validity of OR Expansion for query block SEL$1 (#0)
VT: Initial VT validity check for query block SEL$1 (#0)
VT: Bypassed: inmemory is disabled.
BJ: Checking validity for bushy join for query block SEL$1 (#0)
invalid because Not enabled by hint/parameter
BJ: Bypassed: Not enabled by hint/parameter.
CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.
CBQT: Validity checks failed for 9s014c27wfym3.
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
OBYE: Considering Order-by Elimination from view SEL$1 (#0)
***************************
Order-by elimination (OBYE)
***************************
OBYE: OBYE bypassed: no order by to eliminate.
CVM: Considering view merge in query block SEL$1 (#0)
OJE: Begin: find best directive for query block SEL$1 (#0)
OJE: End: finding best directive for query block SEL$1 (#0)
CNT: Considering count(col) to count(*) on query block SEL$1 (#0)
*************************
Count(col) to Count(*) (CNT)
*************************
CNT: COUNT() to COUNT(*) not done.
query block SEL$1 (#0) unchanged
Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
JF: Checking validity of join factorization for query block SEL$1 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$1 (#0)
TE: Bypassed: No relevant table found.
ORE: Checking validity of OR Expansion for query block SEL$1 (#0)
VT: Initial VT validity check for query block SEL$1 (#0)
VT: Bypassed: inmemory is disabled.
BJ: Checking validity for bushy join for query block SEL$1 (#0)
invalid because Not enabled by hint/parameter
BJ: Bypassed: Not enabled by hint/parameter.
CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.
CBQT: Validity checks failed for 9s014c27wfym3.
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
AAT: Considering Approximate Aggregate Transformation on query block SEL$1 (#0)
*******************************************
Approximate Aggregate Transformation (AAT)
*******************************************
AAT: no exact aggregates transformed
SQE: Trying SQ elimination.
SU: Considering subquery unnesting in query block SEL$1 (#0)
********************
Subquery Unnest (SU)
********************
SU: Considering bottom-up subquery unnesting
SJC: Considering set-join conversion in query block SEL$1 (#0)
*************************
Set-Join Conversion (SJC)
*************************
SJC: not performed
DCL: Checking validity of group-by elimination SEL$1 (#0)
DCL: Result of group-by elimination: Invalid
PM: Considering predicate move-around in query block SEL$1 (#0)
**************************
Predicate Move-Around (PM)
**************************
PM: PM bypassed: Outer query contains no views.
PM: PM bypassed: Outer query contains no views.
isReduceGrByValid: Group By Validation (Failed).
isReduceGrByValid: Group By Validation (Failed).
SQT: Considering Statistic-based Query Transformation from query block SEL$1 (#0)
***************************
Statistic-based Query Transformation (SQT)
***************************
SQT: SQT bypassed: Disabled by parameter.
query block SEL$1 (#0) unchanged
FPD: Considering simple filter push in query block SEL$1 (#0)
??
apadrv-start sqlid=11241024667064433251
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE: CSE not performed on query block SEL$1 (#0).
:
call(in-use=1544, alloc=16344), compile(in-use=71096, alloc=72000), execution(in-use=3152, alloc=4032)
*******************************************
Peeked values of the binds in SQL statement
*******************************************
=====================================
SPD: BEGIN context at statement level
=====================================
Stmt: ******* UNPARSED QUERY IS *******
SELECT MAX("T1"."ID") "MAX(ID)" FROM "TC"."T1" "T1"
Objects referenced in the statement
T1[T1] 23726, type = 1
Objects in the hash table
Hash table Object 23726, type = 1, ownerid = 9926208033879849868:
No Dynamic Sampling Directives for the object
Return code in qosdInitDirCtx: ENBLD
===================================
SPD: END context at statement level
===================================
Final query after transformations:******* UNPARSED QUERY IS *******
SELECT MAX("T1"."ID") "MAX(ID)" FROM "TC"."T1" "T1"
kkoqbc: optimizing query block SEL$1 (#0)
:
call(in-use=1544, alloc=16344), compile(in-use=80896, alloc=84488), execution(in-use=3152, alloc=4032)
kkoqbc-subheap (create addr=0x7fe1f318c738)
****************
QUERY BLOCK TEXT
****************
select max(id) from t1
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0
fro(0): flg=0 objn=23726 hint_alias="T1"@"SEL$1"
-----------------------------
SYSTEM STATISTICS INFORMATION
-----------------------------
Using dictionary system stats.
Using NOWORKLOAD Stats
CPUSPEEDNW: 4363 millions instructions/sec (default is 100)
IOTFRSPEED: 4096 bytes per millisecond (default is 4096)
IOSEEKTIM: 10 milliseconds (default is 10)
MBRC: NO VALUE blocks (default is 8)
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: T1 Alias: T1 (Using composite stats)
#Rows: 54000 SSZ: 0 LGR: 0 #Blks: 961 AvgRowLen: 110.00 NEB: 0 ChainCnt: 0.00 ScanRate: 0.00 SPC: 0 RFL: 0 RNF: 0 CBK: 0 CHR: 0 KQDFLG: 1
#IMCUs: 0 IMCRowCnt: 0 IMCJournalRowCnt: 0 #IMCBlocks: 0 IMCQuotient: 0.000000
Index Stats::
Index: T1_ID Col#: 1
LVLS: 1 #LB: 134 #DK: 54000 LB/K: 1.00 DB/K: 1.00 CLUF: 863.00 NRW: 54000.00 SSZ: 0.00 LGR: 0.00 CBK: 0.00 GQL: 0.00 CHR: 0.00 KQDFLG: 8192 BSZ: 1
KKEISFLG: 1
Index: T1_N1 Col#: 2
LVLS: 1 #LB: 128 #DK: 600 LB/K: 1.00 DB/K: 85.00 CLUF: 51310.00 NRW: 54000.00 SSZ: 0.00 LGR: 0.00 CBK: 0.00 GQL: 0.00 CHR: 0.00 KQDFLG: 8192 BSZ: 1
KKEISFLG: 1
try to generate single-table filter predicates from ORs for query block SEL$1 (#0)
=======================================
SPD: BEGIN context at query block level
=======================================
Query Block SEL$1 (#0)
Return code in qosdSetupDirCtx4QB: NOCTX
=====================================
SPD: END context at query block level
=====================================
Access path analysis for T1
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for T1[T1]
SPD: Return code in qosdDSDirSetup: NOCTX, estType = TABLE
Table: T1 Alias: T1
Card: Original: 54000.000000 Rounded: 54000 Computed: 54000.000000 Non Adjusted: 54000.000000
Scan IO Cost (Disk) = 262.000000
Scan CPU Cost (Disk) = 14943703.840000
Total Scan IO Cost = 262.000000 (scan (Disk))
= 262.000000
Total Scan CPU Cost = 14943703.840000 (scan (Disk))
= 14943703.840000
Access Path: TableScan
Cost: 262.285428 Resp: 262.285428 Degree: 0
Cost_io: 262.000000 Cost_cpu: 14943704
Resp_io: 262.000000 Resp_cpu: 14943704
Access Path: index (index (FFS))
Index: T1_ID
resc_io: 38.000000 resc_cpu: 7434273
ix_sel: 0.000000 ix_sel_with_filters: 1.000000
Access Path: index (FFS)
Cost: 38.141996 Resp: 38.141996 Degree: 1
Cost_io: 38.000000 Cost_cpu: 7434273
Resp_io: 38.000000 Resp_cpu: 7434273
****** Costing Index T1_ID
Access Path: index (Min/Max)
Index: T1_ID
resc_io: 2.000000 resc_cpu: 14443
ix_sel: 0.000000 ix_sel_with_filters: 0.000000
Cost: 2.000276 Resp: 2.000276 Degree: 1
Best:: AccessPath: IndexRange
Index: T1_ID
Cost: 2.000276 Degree: 1 Resp: 2.000276 Card: 1.000000 Bytes: 0.000000
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
PJE: Bypassed; QB has a single table SEL$1 (#0)
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
Join order[1]: T1[T1]#0
***********************
Best so far: Table#: 0 cost: 2.000276 card: 1.000000 bytes: 5.000000
***********************
(newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000
*********************************
Number of join permutations tried: 1
*********************************
Enumerating distribution method (advanced)
LORE: Trying or-Expansion on query block SEL$1 (#0)
Transfer Optimizer annotations for query block SEL$1 (#0)
AP: Checking validity for query block SEL$1, sqlid=9s014c27wfym3
AutoDOP: Consider caching for T1[T1](obj#-1)
cost:2.000276 blkSize:8192 objSize:961.00 marObjSize:912.95 bufSize:396819.00 affPercent:80 smallTab:YES affinitized:NO
kkecComputeAPDop: IO Dop: 0.000000 - CPU Dop: 0.000000
Replication not feasible for first input in join order
Transfer optimizer annotations for T1[T1]
Final cost for query block SEL$1 (#0) - All Rows Plan:
Best join order: 1
Cost: 2.000276 Degree: 1 Card: 1.000000 Bytes: 5.000000
Resc: 2.000276 Resc_io: 2.000000 Resc_cpu: 14443
Resp: 2.000276 Resp_io: 2.000000 Resc_cpu: 14443
kkoqbc-subheap (delete addr=0x7fe1f318c738, in-use=25672, alloc=30136)
kkoqbc-end:
:
call(in-use=14168, alloc=58768), compile(in-use=84880, alloc=88632), execution(in-use=3152, alloc=4032)
kkoqbc: finish optimizing query block SEL$1 (#0)
CBRID: T1 @ SEL$1 - blocking operation in qb SEL$1
apadrv-end
:
call(in-use=14168, alloc=58768), compile(in-use=88264, alloc=88632), execution(in-use=3152, alloc=4032)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=0(MB) time=0(ms)
kkeCostToTime: using io calibrate stats maxpmbps=200(MB/s)
block_size=8192 mb_io_count=1 mb_io_size=8192 (bytes)
tot_io_size=0(MB) time=0(ms)
Starting SQL statement dump
user_id=79 user_name=TC module=SQL*Plus action=
sql_id=9s014c27wfym3 plan_hash_value=-1875205566 problem_type=3 command_type=3
----- Current SQL Statement for this session (sql_id=9s014c27wfym3) -----
select max(id) from t1
sql_text_length=23
sql=select max(id) from t1
----- Explain Plan Dump -----
----- Plan Table -----
============
Plan Table
============
----------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 2 | |
| 1 | SORT AGGREGATE | | 1 | 5 | | |
| 2 | INDEX FULL SCAN (MIN/MAX) | T1_ID | 1 | 5 | 2 | 00:00:01 |
----------------------------------------------+-----------------------------------+
Query Block Name / Object Alias (identified by operation id):
------------------------------------------------------------
1 - SEL$1
2 - SEL$1 / "T1"@"SEL$1"
------------------------------------------------------------
Predicate Information:
----------------------
Content of other_xml column
===========================
has_user_tab : yes
db_version : 19.0.0.0
parse_schema : TC
plan_hash_full : 3894242316
plan_hash : 2419761730
plan_hash_2 : 3894242316
-----------------
Optimizer Metrics
-----------------
<stats type="compilation"><stat name="bg">0</stat></stats>
---------------------
QUERY BLOCK REGISTRY
---------------------
<qb_registry><q o="2" f="y"><n><![CDATA[SEL$1]]></n><f><h><t><![CDATA[T1]]></t><s><![CDATA[SEL$1]]></s></h></f></q></qb_registry>
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('19.1.0')
DB_VERSION('19.1.0')
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
INDEX(@"SEL$1" "T1"@"SEL$1" ("T1"."ID"))
END_OUTLINE_DATA
*/
Optimizer state dump:
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 0
parallel_dml_forced_dop = 0
parallel_ddl_forced_degree = 0
parallel_ddl_forced_instances = 0
_query_rewrite_fudge = 90
optimizer_features_enable = 19.1.0
_optimizer_search_limit = 5
cpu_count = 8
active_instance_count = 2
parallel_threads_per_cpu = 1
hash_area_size = 131072
bitmap_merge_area_size = 1048576
sort_area_size = 65536
sort_area_retained_size = 0
_sort_elimination_cost_ratio = 0
_optimizer_block_size = 8192
_sort_multiblock_read_count = 2
_hash_multiblock_io_count = 0
_db_file_optimizer_read_count = 8
_optimizer_max_permutations = 2000
pga_aggregate_target = 1572864 KB
_pga_max_size = 314560 KB
_query_rewrite_maxdisjunct = 257
_smm_auto_min_io_size = 56 KB
_smm_auto_max_io_size = 248 KB
_smm_min_size = 1024 KB
_smm_max_size_static = 157280 KB
_smm_px_max_size_static = 786432 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 19.1.0
parallel_query_mode = enabled
_enable_parallel_dml = disabled
parallel_ddl_mode = enabled
optimizer_mode = all_rows
sqlstat_enabled = true
_optimizer_percent_parallel = 101
_always_anti_join = choose
_always_semi_join = choose
_optimizer_mode_force = true
_partition_view_enabled = true
_always_star_transformation = false
_query_rewrite_or_error = false
_hash_join_enabled = true
cursor_sharing = exact
_b_tree_bitmap_plans = true
star_transformation_enabled = false
_optimizer_cost_model = choose
_new_sort_cost_estimate = true
_complex_view_merging = true
_unnest_subquery = true
_eliminate_common_subexpr = true
_pred_move_around = true
_convert_set_to_join = false
_push_join_predicate = true
_push_join_union_view = true
_fast_full_scan_enabled = true
_optim_enhance_nnull_detection = true
_parallel_broadcast_enabled = true
_px_broadcast_fudge_factor = 100
_ordered_nested_loop = true
_no_or_expansion = false
optimizer_index_cost_adj = 100
optimizer_index_caching = 0
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = enforced
_query_cost_rewrite = true
_query_rewrite_2 = true
_query_rewrite_1 = true
_query_rewrite_expression = true
_query_rewrite_jgmigrate = true
_query_rewrite_fpc = true
_query_rewrite_drj = false
_full_pwise_join_enabled = true
_partial_pwise_join_enabled = true
_left_nested_loops_random = true
_improved_row_length_enabled = true
_index_join_enabled = true
_enable_type_dep_selectivity = true
_improved_outerjoin_card = true
_optimizer_adjust_for_nulls = true
_optimizer_degree = 0
_use_column_stats_for_function = true
_subquery_pruning_enabled = true
_subquery_pruning_mv_enabled = false
_or_expand_nvl_predicate = true
_like_with_bind_as_equality = false
_table_scan_cost_plus_one = true
_cost_equality_semi_join = true
_default_non_equality_sel_check = true
_new_initial_join_orders = true
_oneside_colstat_for_equijoins = true
_optim_peek_user_binds = true
_minimal_stats_aggregation = true
_force_temptables_for_gsets = false
workarea_size_policy = auto
_smm_auto_cost_enabled = true
_gs_anti_semi_join_allowed = true
_optim_new_default_join_sel = true
optimizer_dynamic_sampling = 2
_pre_rewrite_push_pred = true
_optimizer_new_join_card_computation = true
_union_rewrite_for_gs = yes_gset_mvs
_generalized_pruning_enabled = true
_optim_adjust_for_part_skews = true
_force_datefold_trunc = false
statistics_level = all
_optimizer_system_stats_usage = true
skip_unusable_indexes = true
_remove_aggr_subquery = true
_optimizer_push_down_distinct = 0
_dml_monitoring_enabled = true
_optimizer_undo_changes = false
_predicate_elimination_enabled = true
_nested_loop_fudge = 100
_project_view_columns = true
_local_communication_costing_enabled = true
_local_communication_ratio = 50
_query_rewrite_vop_cleanup = true
_slave_mapping_enabled = true
_optimizer_cost_based_transformation = linear
_optimizer_mjc_enabled = true
_right_outer_hash_enable = true
_spr_push_pred_refspr = true
_optimizer_cache_stats = false
_optimizer_cbqt_factor = 50
_optimizer_squ_bottomup = true
_fic_area_size = 131072
_optimizer_skip_scan_enabled = true
_optimizer_cost_filter_pred = false
_optimizer_sortmerge_join_enabled = true
_optimizer_join_sel_sanity_check = true
_mmv_query_rewrite_enabled = true
_bt_mmv_query_rewrite_enabled = true
_add_stale_mv_to_dependency_list = true
_distinct_view_unnesting = false
_optimizer_dim_subq_join_sel = true
_optimizer_disable_strans_sanity_checks = 0
_optimizer_compute_index_stats = true
_push_join_union_view2 = true
optimizer_ignore_hints = false
_optimizer_random_plan = 0
_query_rewrite_setopgrw_enable = true
_optimizer_correct_sq_selectivity = true
_disable_function_based_index = false
_optimizer_join_order_control = 3
_optimizer_cartesian_enabled = true
_optimizer_starplan_enabled = true
_extended_pruning_enabled = true
_optimizer_push_pred_cost_based = true
_optimizer_null_aware_antijoin = true
_optimizer_extend_jppd_view_types = true
_sql_model_unfold_forloops = run_time
_enable_dml_lock_escalation = false
_bloom_filter_enabled = true
_update_bji_ipdml_enabled = 0
_optimizer_extended_cursor_sharing = udo
_dm_max_shared_pool_pct = 1
_optimizer_cost_hjsmj_multimatch = true
_optimizer_transitivity_retain = true
_px_pwg_enabled = true
optimizer_secure_view_merging = true
_optimizer_join_elimination_enabled = true
flashback_table_rpi = non_fbt
_optimizer_cbqt_no_size_restriction = true
_optimizer_enhanced_filter_push = true
_optimizer_filter_pred_pullup = true
_rowsrc_trace_level = 0
_simple_view_merging = true
_optimizer_rownum_pred_based_fkr = true
_optimizer_better_inlist_costing = all
_optimizer_self_induced_cache_cost = false
_optimizer_min_cache_blocks = 10
_optimizer_or_expansion = depth
_optimizer_order_by_elimination_enabled = true
_optimizer_outer_to_anti_enabled = true
_selfjoin_mv_duplicates = true
_dimension_skip_null = true
_force_rewrite_enable = false
_optimizer_star_tran_in_with_clause = true
_optimizer_complex_pred_selectivity = true
_optimizer_connect_by_cost_based = true
_gby_hash_aggregation_enabled = true
_globalindex_pnum_filter_enabled = true
_px_minus_intersect = true
_fix_control_key = 0
_force_slave_mapping_intra_part_loads = false
_force_tmp_segment_loads = false
_query_mmvrewrite_maxpreds = 10
_query_mmvrewrite_maxintervals = 5
_query_mmvrewrite_maxinlists = 5
_query_mmvrewrite_maxdmaps = 10
_query_mmvrewrite_maxcmaps = 20
_query_mmvrewrite_maxregperm = 512
_query_mmvrewrite_maxqryinlistvals = 500
_disable_parallel_conventional_load = false
_trace_virtual_columns = false
_replace_virtual_columns = true
_virtual_column_overload_allowed = true
_kdt_buffering = true
_first_k_rows_dynamic_proration = true
_optimizer_sortmerge_join_inequality = true
_optimizer_aw_stats_enabled = true
_bloom_pruning_enabled = true
result_cache_mode = MANUAL
_px_ual_serial_input = true
_optimizer_skip_scan_guess = false
_enable_row_shipping = true
_row_shipping_threshold = 100
_row_shipping_explain = false
transaction_isolation_level = read_commited
_optimizer_distinct_elimination = true
_optimizer_multi_level_push_pred = true
_optimizer_group_by_placement = true
_optimizer_rownum_bind_default = 10
_enable_query_rewrite_on_remote_objs = true
_optimizer_extended_cursor_sharing_rel = simple
_optimizer_adaptive_cursor_sharing = true
_direct_path_insert_features = 0
_optimizer_improve_selectivity = true
optimizer_use_pending_statistics = false
_optimizer_enable_density_improvements = true
_optimizer_aw_join_push_enabled = true
_optimizer_connect_by_combine_sw = true
_enable_pmo_ctas = 0
_optimizer_native_full_outer_join = force
_bloom_predicate_enabled = true
_optimizer_enable_extended_stats = true
_is_lock_table_for_ddl_wait_lock = 0
_pivot_implementation_method = choose
optimizer_capture_sql_plan_baselines = false
optimizer_use_sql_plan_baselines = true
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_with_subquery = OPTIMIZER
_optimizer_fkr_index_cost_bias = 10
_optimizer_use_subheap = true
parallel_degree_policy = manual
parallel_degree = 0
parallel_min_time_threshold = 10
_parallel_time_unit = 10
_optimizer_or_expansion_subheap = true
_optimizer_free_transformation_heap = true
_optimizer_reuse_cost_annotations = true
_result_cache_auto_size_threshold = 100
_result_cache_auto_time_threshold = 1000
_optimizer_nested_rollup_for_gset = 100
_nlj_batching_enabled = 1
parallel_query_default_dop = 0
is_recur_flags = 0
optimizer_use_invisible_indexes = false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force = true
cell_offload_processing = true
_rdbms_internal_fplib_enabled = false
db_file_multiblock_read_count = 128
_bloom_folding_enabled = true
_mv_generalized_oj_refresh_opt = true
cell_offload_compaction = ADAPTIVE
cell_offload_plan_display = AUTO
_bloom_predicate_offload = true
_bloom_filter_size = 0
_bloom_pushing_max = 512
parallel_degree_limit = 65535
parallel_force_local = false
parallel_max_degree = 16
total_cpu_count = 16
_optimizer_coalesce_subqueries = true
_optimizer_fast_pred_transitivity = true
_optimizer_fast_access_pred_analysis = true
_optimizer_unnest_disjunctive_subq = true
_optimizer_unnest_corr_set_subq = true
_optimizer_distinct_agg_transform = true
_aggregation_optimization_settings = 0
_optimizer_connect_by_elim_dups = true
_optimizer_eliminate_filtering_join = true
_connect_by_use_union_all = true
dst_upgrade_insert_conv = true
advanced_queuing_internal_cursor = 0
_optimizer_unnest_all_subqueries = true
parallel_autodop = 0
parallel_ddldml = 0
_parallel_cluster_cache_policy = adaptive
_parallel_scalability = 50
iot_internal_cursor = 0
_optimizer_instance_count = 0
_optimizer_connect_by_cb_whr_only = false
_suppress_scn_chk_for_cqn = nosuppress_1466
_optimizer_join_factorization = true
_optimizer_use_cbqt_star_transformation = true
_optimizer_table_expansion = true
_and_pruning_enabled = true
_deferred_constant_folding_mode = DEFAULT
_optimizer_distinct_placement = true
partition_pruning_internal_cursor = 0
parallel_hinted = none
_sql_compatibility = 0
_optimizer_use_feedback = true
_optimizer_try_st_before_jppd = true
_dml_frequency_tracking = false
_optimizer_interleave_jppd = true
kkb_drop_empty_segments = 0
_px_partition_scan_enabled = true
_px_partition_scan_threshold = 64
_optimizer_false_filter_pred_pullup = true
_bloom_minmax_enabled = true
only_move_row = 0
_optimizer_enable_table_lookup_by_nl = true
parallel_execution_message_size = 16384
_px_loc_msg_cost = 1000
_px_net_msg_cost = 10000
_optimizer_generate_transitive_pred = true
_optimizer_cube_join_enabled = true
_optimizer_filter_pushdown = true
deferred_segment_creation = true
_optimizer_outer_join_to_inner = true
_allow_level_without_connect_by = false
_max_rwgs_groupings = 8192
_optimizer_hybrid_fpwj_enabled = true
_px_replication_enabled = true
ilm_filter = 0
_optimizer_partial_join_eval = true
_px_concurrent = true
_px_object_sampling_enabled = true
_px_back_to_parallel = OFF
_optimizer_unnest_scalar_sq = true
_optimizer_full_outer_join_to_outer = true
_px_filter_parallelized = true
_px_filter_skew_handling = true
_zonemap_use_enabled = true
_zonemap_control = 0
_optimizer_multi_table_outerjoin = true
_px_groupby_pushdown = force
_partition_advisor_srs_active = true
_optimizer_ansi_join_lateral_enhance = true
_px_parallelize_expression = true
_fast_index_maintenance = true
_optimizer_ansi_rearchitecture = true
_optimizer_gather_stats_on_load = true
ilm_access_tracking = 0
ilm_dml_timestamp = 0
_px_adaptive_dist_method = choose
_px_adaptive_dist_method_threshold = 0
_optimizer_batch_table_access_by_rowid = true
optimizer_adaptive_reporting_only = false
_optimizer_ads_max_table_count = 0
_optimizer_ads_time_limit = 0
_optimizer_ads_use_result_cache = true
_px_wif_dfo_declumping = choose
_px_wif_extend_distribution_keys = true
_px_join_skew_handling = true
_px_join_skew_ratio = 10
_px_join_skew_minfreq = 30
CLI_internal_cursor = 0
_parallel_fault_tolerance_enabled = false
_parallel_fault_tolerance_threshold = 3
_px_partial_rollup_pushdown = adaptive
_px_single_server_enabled = true
_optimizer_dsdir_usage_control = 0
_px_cpu_autodop_enabled = true
_px_cpu_process_bandwidth = 200
_sql_hvshare_threshold = 0
_px_tq_rowhvs = true
_optimizer_use_gtt_session_stats = true
_optimizer_proc_rate_level = basic
_px_hybrid_TSM_HWMB_load = true
_optimizer_use_histograms = true
PMO_altidx_rebuild = 0
_cell_offload_expressions = true
_cell_materialize_virtual_columns = true
_cell_materialize_all_expressions = false
_rowsets_enabled = true
_rowsets_target_maxsize = 524288
_rowsets_max_rows = 256
_use_hidden_partitions = 0
_px_load_monitor_threshold = 10000
_px_numa_support_enabled = false
total_processor_group_count = 2
_adaptive_window_consolidator_enabled = true
_optimizer_strans_adaptive_pruning = true
_bloom_rm_filter = false
_optimizer_null_accepting_semijoin = true
_long_varchar_allow_IOT = 0
_parallel_ctas_enabled = true
_cell_offload_complex_processing = true
_optimizer_performance_feedback = off
_optimizer_proc_rate_source = DEFAULT
_hashops_prefetch_size = 4
_cell_offload_sys_context = true
_multi_commit_global_index_maint = 0
_stat_aggs_one_pass_algorithm = false
_dbg_scan = 0
_oltp_comp_dbg_scan = 0
_arch_comp_dbg_scan = 0
_optimizer_gather_feedback = true
_upddel_dba_hash_mask_bits = 0
_px_pwmr_enabled = true
_px_cdb_view_enabled = true
_bloom_sm_enabled = true
_optimizer_cluster_by_rowid = true
_optimizer_cluster_by_rowid_control = 129
_partition_cdb_view_enabled = true
_common_data_view_enabled = true
_pred_push_cdb_view_enabled = true
_rowsets_cdb_view_enabled = true
_distinct_agg_optimization_gsets = choose
_array_cdb_view_enabled = true
_optimizer_adaptive_plan_control = 0
_optimizer_adaptive_random_seed = 0
_optimizer_cbqt_or_expansion = on
_inmemory_dbg_scan = 0
_gby_vector_aggregation_enabled = true
_optimizer_vector_transformation = true
_optimizer_vector_fact_dim_ratio = 10
_key_vector_max_size = 0
_key_vector_predicate_enabled = true
_key_vector_predicate_threshold = 0
_vector_operations_control = 0
_optimizer_vector_min_fact_rows = 10000000
parallel_dblink = 0
_px_scalable_invdist = true
_key_vector_offload = predicate
_optimizer_aggr_groupby_elim = true
_optimizer_reduce_groupby_key = true
_vector_serialize_temp_threshold = 1000
_always_vector_transformation = false
_optimizer_cluster_by_rowid_batched = true
_object_link_fixed_enabled = true
optimizer_inmemory_aware = true
_optimizer_inmemory_table_expansion = true
_optimizer_inmemory_gen_pushable_preds = true
_optimizer_inmemory_autodop = true
_optimizer_inmemory_access_path = true
_optimizer_inmemory_bloom_filter = true
_parallel_inmemory_min_time_threshold = 1
_parallel_inmemory_time_unit = 1
_rc_sys_obj_enabled = true
_optimizer_nlj_hj_adaptive_join = true
_indexable_con_id = true
_bloom_serial_filter = on
inmemory_force = default
inmemory_query = enable
_inmemory_query_scan = true
_inmemory_query_fetch_by_rowid = false
_inmemory_pruning = on
_px_autodop_pq_overhead = true
_px_external_table_default_stats = true
_optimizer_key_vector_aggr_factor = 75
_optimizer_vector_cost_adj = 100
_cdb_cross_container = 65535
_cdb_view_parallel_degree = 65535
_optimizer_hll_entry = 4096
_px_cdb_view_join_enabled = true
inmemory_size = 0
_external_table_smart_scan = hadoop_only
_optimizer_inmemory_minmax_pruning = true
_approx_cnt_distinct_gby_pushdown = choose
_approx_cnt_distinct_optimization = 0
_optimizer_ads_use_partial_results = true
_query_execution_time_limit = 0
_optimizer_inmemory_cluster_aware_dop = true
_optimizer_db_blocks_buffers = 0 KB
_query_rewrite_use_on_query_computation = true
_px_scalable_invdist_mcol = true
_optimizer_bushy_join = off
_optimizer_bushy_fact_dim_ratio = 20
_optimizer_bushy_fact_min_size = 100000
_optimizer_bushy_cost_factor = 100
_rmt_for_table_redef_enabled = true
_optimizer_eliminate_subquery = true
_sqlexec_cache_aware_hash_join_enabled = true
_zonemap_usage_tracking = true
_sqlexec_hash_based_distagg_enabled = false
_sqlexec_disable_hash_based_distagg_tiv = false
_sqlexec_hash_based_distagg_ssf_enabled = true
_sqlexec_distagg_optimization_settings = 0
approx_for_aggregation = false
approx_for_count_distinct = false
_optimizer_union_all_gsets = true
_rowsets_use_encoding = true
_rowsets_max_enc_rows = 64
_optimizer_enhanced_join_elimination = true
_optimizer_multicol_join_elimination = true
_key_vector_create_pushdown_threshold = 20000
_optimizer_enable_plsql_stats = true
_recursive_with_parallel = true
_recursive_with_branch_iterations = 7
_px_dist_agg_partial_rollup_pushdown = adaptive
_px_adaptive_dist_bypass_enabled = true
_enable_view_pdb = true
_optimizer_key_vector_pruning_enabled = true
_pwise_distinct_enabled = true
_recursive_with_using_temp_table = false
_partition_read_only = true
_sql_alias_scope = true
_cdb_view_no_skip_migrate = false
_approx_perc_sampling_err_rate = 2
_sqlexec_encoding_aware_hj_enabled = true
rim_node_exist = 0
_enable_containers_subquery = true
_force_containers_subquery = false
_cell_offload_vector_groupby = true
_vector_encoding_mode = manual
_ds_xt_split_count = 1
_ds_sampling_method = PROGRESSIVE
_optimizer_ads_use_spd_cache = true
_optimizer_use_table_scanrate = HADOOP_ONLY
_optimizer_use_xt_rowid = true
_xt_sampling_scan_granules = on
_recursive_with_control = 0
_sqlexec_use_rwo_aware_expr_analysis = true
_optimizer_band_join_aware = true
_optimizer_vector_base_dim_fact_factor = 200
approx_for_percentile = none
_approx_percentile_optimization = 0
_projection_pushdown = true
_px_object_sampling = 200
_optimizer_adaptive_plans_continuous = false
_optimizer_adaptive_plans_iterative = false
_ds_enable_view_sampling = true
_optimizer_generate_ptf_implied_preds = true
_optimizer_inmemory_use_stored_stats = AUTO
_cdb_special_old_xplan = true
uniaud_internal_cursor = 0
_kd_dbg_control = 0
_mv_access_compute_fresh_data = on
_bloom_filter_ratio = 35
_optimizer_control_shard_qry_processing = 65528
containers_parallel_degree = 65535
sql_from_coordinator = 0
_xt_sampling_scan_granules_min_granules = 1
_in_memory_cdt = LIMITED
_in_memory_cdt_maxpx = 4
_px_partition_load_dist_threshold = 64
_px_adaptive_dist_bypass_optimization = 1
_optimizer_interleave_or_expansion = true
optimizer_adaptive_plans = true
optimizer_adaptive_statistics = false
_optimizer_use_feedback_for_join = false
_optimizer_ads_for_pq = false
_px_join_skewed_values_count = 0
optimizer_ignore_parallel_hints = false
parallel_min_degree = 1
_px_nlj_bcast_rr_threshold = 10
_optimizer_gather_stats_on_load_all = false
_optimizer_gather_stats_on_load_hist = false
_optimizer_allow_all_access_paths = true
_key_vector_double_enabled = true
_key_vector_timestamp_enabled = true
_optimizer_answering_query_using_stats = false
_disable_dblink_optim = true
_cell_offload_hybrid_processing = true
_read_optimized_table_lookup = true
_optimizer_key_vector_payload = true
_optimizer_vector_fact_payload_ratio = 20
_bloom_pruning_setops_enabled = true
_bloom_filter_setops_enabled = true
_key_vector_shared_dgk_ht = true
_px_pwise_wif_enabled = true
_sqlexec_reorder_wif_enabled = true
_px_partition_skew_threshold = 80
_sqlexec_pwiseops_with_sqlfuncs_enabled = true
_sqlexec_pwiseops_with_binds_enabled = true
_px_shared_hash_join = false
_px_reuse_server_groups = multi
_px_join_skew_null_handling = true
_px_join_skew_use_histogram = true
_px_join_skew_sampling_time_limit = 50
_px_join_skew_sampling_percent = 0
_cdb_view_no_skip_restricted = false
_inmemory_external_table = true
_sqlexec_use_kgghash3 = true
_cell_offload_vector_groupby_force = false
_hcs_enable_pred_push = true
parallel_dop_doubled = 0
_optimizer_gather_stats_on_load_index = true
_con_map_sql_enforcement = true
_uniq_cons_sql_enforcement = true
_ref_cons_sql_enforcement = true
_is_lock_table_for_split_merge = 0
_cell_offload_vector_groupby_fact_key = true
_px_scalable_gby_invdist = true
_px_dynamic_granules = true
_px_dynamic_granules_adjust = 10
_px_hybrid_partition_execution_enabled = true
_px_hybrid_partition_skew_threshold = 10
_optimizer_key_vector_use_max_size = 1048576
_cell_offload_vector_groupby_withnojoin = true
_key_vector_join_pushdown_enabled = true
_cell_offload_grand_total = true
_optimizer_key_vector_payload_dim_aggs = false
_optimizer_use_auto_indexes = AUTO
_optimizer_use_stats_on_conventional_dml = false
_optimizer_gather_stats_on_conventional_dml = false
_optimizer_use_stats_on_conventional_config = 0
_skip_pset_col_chk = 0
_nls_binary = true
_optimizer_quarantine_sql = true
_optimizer_gather_stats_on_conventional_config = 0
_nls_forced_binary = 0
_utl32k_mv_query = false
optimizer_session_type = NORMAL
BlockChain_ledger_infrastructure = 0
_cell_offload_vector_groupby_external = true
_bigdata_offload_flag = false
container_data = ALL
optimizer_real_time_statistics = false
_update_global_index_from_part_exchange = 0
Bug Fix Control Environment
fix 3834770 = 1
fix 3746511 = enabled
fix 4519016 = enabled
fix 3118776 = enabled
fix 4488689 = enabled
fix 2194204 = disabled
fix 2660592 = enabled
fix 2320291 = enabled
fix 2324795 = enabled
fix 4308414 = enabled
fix 3499674 = disabled
fix 4569940 = enabled
fix 4631959 = enabled
fix 4519340 = enabled
fix 4550003 = enabled
fix 1403283 = enabled
fix 4554846 = enabled
fix 4602374 = enabled
fix 4584065 = enabled
fix 4545833 = enabled
fix 4611850 = enabled
fix 4663698 = enabled
fix 4663804 = enabled
fix 4666174 = enabled
fix 4567767 = enabled
fix 4556762 = 15
fix 4728348 = enabled
fix 4708389 = enabled
fix 4175830 = enabled
fix 4752814 = enabled
fix 4583239 = enabled
fix 4386734 = enabled
fix 4887636 = enabled
fix 4483240 = enabled
fix 4872602 = disabled
fix 4711525 = enabled
fix 4545802 = enabled
fix 4605810 = enabled
fix 4704779 = enabled
fix 4900129 = enabled
fix 4924149 = enabled
fix 4663702 = enabled
fix 4878299 = enabled
fix 4658342 = enabled
fix 4881533 = enabled
fix 4676955 = enabled
fix 4273361 = enabled
fix 4967068 = enabled
fix 4969880 = disabled
fix 5005866 = enabled
fix 5015557 = enabled
fix 4705343 = enabled
fix 4904838 = enabled
fix 4716096 = enabled
fix 4483286 = disabled
fix 4722900 = enabled
fix 4615392 = enabled
fix 5096560 = enabled
fix 5029464 = enabled
fix 4134994 = enabled
fix 4904890 = enabled
fix 5104624 = enabled
fix 5014836 = enabled
fix 4768040 = enabled
fix 4600710 = enabled
fix 5129233 = enabled
fix 4595987 = enabled
fix 4908162 = enabled
fix 5139520 = enabled
fix 5084239 = enabled
fix 5143477 = disabled
fix 2663857 = enabled
fix 4717546 = enabled
fix 5240264 = disabled
fix 5099909 = enabled
fix 5240607 = enabled
fix 5195882 = enabled
fix 5220356 = enabled
fix 5263572 = enabled
fix 5385629 = enabled
fix 5302124 = enabled
fix 5391942 = enabled
fix 5384335 = enabled
fix 5482831 = enabled
fix 4158812 = enabled
fix 5387148 = enabled
fix 5383891 = enabled
fix 5466973 = enabled
fix 5396162 = enabled
fix 5394888 = enabled
fix 5395291 = enabled
fix 5236908 = enabled
fix 5509293 = enabled
fix 5449488 = enabled
fix 5567933 = enabled
fix 5570494 = enabled
fix 5288623 = enabled
fix 5505995 = enabled
fix 5505157 = enabled
fix 5112460 = enabled
fix 5554865 = enabled
fix 5112260 = enabled
fix 5112352 = enabled
fix 5547058 = enabled
fix 5618040 = enabled
fix 5585313 = enabled
fix 5547895 = enabled
fix 5634346 = enabled
fix 5620485 = enabled
fix 5483301 = enabled
fix 5657044 = enabled
fix 5694984 = enabled
fix 5868490 = enabled
fix 5650477 = enabled
fix 5611962 = enabled
fix 4279274 = enabled
fix 5741121 = enabled
fix 5714944 = enabled
fix 5391505 = enabled
fix 5762598 = enabled
fix 5578791 = enabled
fix 5259048 = enabled
fix 5882954 = enabled
fix 2492766 = enabled
fix 5707608 = enabled
fix 5891471 = enabled
fix 5884780 = enabled
fix 5680702 = enabled
fix 5371452 = enabled
fix 5838613 = enabled
fix 5949981 = enabled
fix 5624216 = enabled
fix 5741044 = enabled
fix 5976822 = enabled
fix 6006457 = enabled
fix 5872956 = enabled
fix 5923644 = enabled
fix 5943234 = enabled
fix 5844495 = enabled
fix 4168080 = enabled
fix 6020579 = enabled
fix 5842686 = disabled
fix 5996801 = enabled
fix 5593639 = enabled
fix 6133948 = enabled
fix 3151991 = enabled
fix 6146906 = enabled
fix 6239909 = enabled
fix 6267621 = enabled
fix 5909305 = enabled
fix 6279918 = enabled
fix 6141818 = enabled
fix 6151963 = enabled
fix 6251917 = enabled
fix 6282093 = enabled
fix 6119510 = enabled
fix 6119382 = enabled
fix 3801750 = enabled
fix 5705630 = disabled
fix 5944076 = enabled
fix 5406763 = enabled
fix 6070954 = enabled
fix 6282944 = enabled
fix 6138746 = enabled
fix 6082745 = enabled
fix 3426050 = enabled
fix 599680 = enabled
fix 6062266 = enabled
fix 6087237 = enabled
fix 6122894 = enabled
fix 6377505 = enabled
fix 5893768 = enabled
fix 6163564 = enabled
fix 6073325 = enabled
fix 6188881 = enabled
fix 6007259 = enabled
fix 6239971 = enabled
fix 5284200 = disabled
fix 6042205 = enabled
fix 6051211 = enabled
fix 6434668 = enabled
fix 6438752 = enabled
fix 5936366 = enabled
fix 6439032 = enabled
fix 6438892 = enabled
fix 6006300 = enabled
fix 5947231 = enabled
fix 5416118 = 1
fix 6365442 = 1
fix 6239039 = enabled
fix 6502845 = enabled
fix 6913094 = enabled
fix 6029469 = enabled
fix 5919513 = enabled
fix 6057611 = enabled
fix 6469667 = enabled
fix 6608941 = disabled
fix 6368066 = enabled
fix 6329318 = enabled
fix 6656356 = enabled
fix 4507997 = enabled
fix 6671155 = enabled
fix 6694548 = enabled
fix 6688200 = enabled
fix 6612471 = enabled
fix 6708183 = disabled
fix 6326934 = enabled
fix 6520717 = disabled
fix 6714199 = enabled
fix 6681545 = enabled
fix 6748058 = enabled
fix 6167716 = enabled
fix 6674254 = enabled
fix 6468287 = enabled
fix 6503543 = enabled
fix 6808773 = disabled
fix 6766962 = enabled
fix 6120483 = enabled
fix 6670551 = enabled
fix 6771838 = enabled
fix 6626018 = disabled
fix 6530596 = enabled
fix 6778642 = enabled
fix 6699059 = enabled
fix 6376551 = enabled
fix 6429113 = enabled
fix 6782437 = enabled
fix 6776808 = enabled
fix 6765823 = enabled
fix 6768660 = enabled
fix 6782665 = enabled
fix 6610822 = enabled
fix 6514189 = enabled
fix 6818410 = enabled
fix 6827696 = enabled
fix 6773613 = enabled
fix 5902962 = enabled
fix 6956212 = enabled
fix 3056297 = enabled
fix 6440977 = disabled
fix 6972291 = disabled
fix 6904146 = enabled
fix 6221403 = enabled
fix 5475051 = enabled
fix 6845871 = enabled
fix 5468809 = enabled
fix 6917633 = enabled
fix 4444536 = disabled
fix 6955210 = enabled
fix 6994194 = enabled
fix 6399597 = disabled
fix 6951776 = enabled
fix 5648287 = 3
fix 6987082 = disabled
fix 7132036 = enabled
fix 6980350 = enabled
fix 5199213 = enabled
fix 7138405 = enabled
fix 7148689 = enabled
fix 6820988 = enabled
fix 7032684 = enabled
fix 6617866 = enabled
fix 7155968 = enabled
fix 7127980 = enabled
fix 6982954 = enabled
fix 7241819 = enabled
fix 6897034 = enabled
fix 7236148 = enabled
fix 7298570 = enabled
fix 7249095 = enabled
fix 7314499 = enabled
fix 7324224 = enabled
fix 7289023 = enabled
fix 7237571 = enabled
fix 7116357 = enabled
fix 7345484 = enabled
fix 7375179 = enabled
fix 6430500 = disabled
fix 5897486 = enabled
fix 6774209 = enabled
fix 7306637 = enabled
fix 6451322 = enabled
fix 7208131 = enabled
fix 7388652 = enabled
fix 7127530 = enabled
fix 6751206 = enabled
fix 6669103 = enabled
fix 7430474 = enabled
fix 6990305 = enabled
fix 7043307 = enabled
fix 3120429 = enabled
fix 7452823 = disabled
fix 6838105 = enabled
fix 6769711 = enabled
fix 7170213 = enabled
fix 6528872 = enabled
fix 7295298 = enabled
fix 5922070 = enabled
fix 7259468 = enabled
fix 6418552 = enabled
fix 4619997 = enabled
fix 7524366 = enabled
fix 6942476 = enabled
fix 6418771 = enabled
fix 7375077 = enabled
fix 5400639 = enabled
fix 4570921 = enabled
fix 7426911 = enabled
fix 5099019 = disabled
fix 7528216 = enabled
fix 7521266 = enabled
fix 7385140 = enabled
fix 7576516 = enabled
fix 7573526 = enabled
fix 7576476 = enabled
fix 7165898 = enabled
fix 7263214 = enabled
fix 3320140 = enabled
fix 7555510 = enabled
fix 7613118 = enabled
fix 7597059 = enabled
fix 7558911 = enabled
fix 5520732 = enabled
fix 7679490 = disabled
fix 7449971 = enabled
fix 3628118 = enabled
fix 4370840 = enabled
fix 7281191 = enabled
fix 7519687 = enabled
fix 5029592 = 3
fix 6012093 = 1
fix 6053861 = disabled
fix 6941515 = disabled
fix 7696414 = enabled
fix 7272039 = enabled
fix 7834811 = enabled
fix 7640597 = enabled
fix 7341616 = enabled
fix 7168184 = enabled
fix 399198 = enabled
fix 7831070 = enabled
fix 7676897 = disabled
fix 7414637 = enabled
fix 7585456 = enabled
fix 8202421 = enabled
fix 7658097 = disabled
fix 8251486 = enabled
fix 7132684 = enabled
fix 7512227 = enabled
fix 6972987 = enabled
fix 7199035 = enabled
fix 8243446 = enabled
fix 7650462 = enabled
fix 6720701 = enabled
fix 7592673 = enabled
fix 7718694 = enabled
fix 7534027 = enabled
fix 7708267 = enabled
fix 5716785 = enabled
fix 7356191 = enabled
fix 7679161 = enabled
fix 7597159 = enabled
fix 7499258 = enabled
fix 8328363 = enabled
fix 7452863 = enabled
fix 8284930 = enabled
fix 7298626 = enabled
fix 7657126 = enabled
fix 8371884 = enabled
fix 8318020 = enabled
fix 8255423 = enabled
fix 7135745 = enabled
fix 8356253 = enabled
fix 7534257 = enabled
fix 8323407 = enabled
fix 7539815 = enabled
fix 8289316 = enabled
fix 8447850 = enabled
fix 7675944 = enabled
fix 8355120 = enabled
fix 7176746 = enabled
fix 8442891 = enabled
fix 8373261 = enabled
fix 7679164 = enabled
fix 7670533 = enabled
fix 8408665 = enabled
fix 8491399 = enabled
fix 8348392 = enabled
fix 8348585 = enabled
fix 8335178 = enabled
fix 8247017 = enabled
fix 7325597 = enabled
fix 8531490 = enabled
fix 6163600 = enabled
fix 8589278 = disabled
fix 8557992 = enabled
fix 7556098 = enabled
fix 8580883 = enabled
fix 5892599 = disabled
fix 8609714 = enabled
fix 8619631 = disabled
fix 8672915 = enabled
fix 8514561 = enabled
fix 8213977 = enabled
fix 8560951 = disabled
fix 8578587 = enabled
fix 8287870 = enabled
fix 8467123 = enabled
fix 8602185 = enabled
fix 8519457 = enabled
fix 3335182 = enabled
fix 8602840 = enabled
fix 8725296 = enabled
fix 8628970 = enabled
fix 6754080 = enabled
fix 8767442 = enabled
fix 8760135 = enabled
fix 8644935 = enabled
fix 8352378 = enabled
fix 8685327 = enabled
fix 8763472 = enabled
fix 8773324 = enabled
fix 8813674 = enabled
fix 8532236 = enabled
fix 8629716 = enabled
fix 7277732 = enabled
fix 8692170 = enabled
fix 8900973 = enabled
fix 8919133 = enabled
fix 8927050 = enabled
fix 8551880 = enabled
fix 8901237 = enabled
fix 8812372 = enabled
fix 6236862 = enabled
fix 8528517 = enabled
fix 7215982 = enabled
fix 8214022 = enabled
fix 8595392 = enabled
fix 8890233 = enabled
fix 8999317 = enabled
fix 9004800 = enabled
fix 8986163 = enabled
fix 8855396 = enabled
fix 8800514 = 20
fix 9007859 = enabled
fix 8198783 = disabled
fix 9053879 = enabled
fix 6086930 = enabled
fix 7641601 = enabled
fix 9052506 = enabled
fix 9103775 = enabled
fix 9047975 = enabled
fix 8893626 = enabled
fix 9111170 = enabled
fix 8971829 = enabled
fix 7628358 = enabled
fix 9125151 = enabled
fix 9039715 = enabled
fix 9106224 = enabled
fix 9185228 = enabled
fix 9206747 = enabled
fix 9088510 = enabled
fix 9143856 = enabled
fix 8833381 = enabled
fix 8949971 = enabled
fix 8951812 = enabled
fix 9148171 = enabled
fix 8706652 = enabled
fix 9245114 = enabled
fix 8802198 = enabled
fix 9011016 = enabled
fix 9265681 = enabled
fix 7284269 = enabled
fix 9272549 = enabled
fix 8917507 = 7
fix 8531463 = enabled
fix 9263333 = enabled
fix 8675087 = enabled
fix 8896955 = enabled
fix 9041934 = enabled
fix 9344709 = enabled
fix 9024933 = enabled
fix 9033718 = enabled
fix 9240455 = enabled
fix 9081848 = enabled
fix 5982893 = enabled
fix 9287401 = enabled
fix 8590021 = enabled
fix 9340120 = enabled
fix 9355794 = enabled
fix 9356656 = enabled
fix 9385634 = enabled
fix 9069046 = enabled
fix 9239337 = enabled
fix 9300228 = enabled
fix 9298010 = enabled
fix 9384170 = enabled
fix 9407929 = enabled
fix 8836806 = enabled
fix 9344055 = enabled
fix 9274675 = enabled
fix 9203723 = enabled
fix 9443476 = enabled
fix 9195582 = enabled
fix 8226666 = enabled
fix 9433490 = enabled
fix 9065494 = enabled
fix 9303766 = enabled
fix 9437283 = enabled
fix 9116214 = enabled
fix 9456688 = enabled
fix 9456746 = disabled
fix 9342979 = enabled
fix 9465425 = enabled
fix 9092442 = enabled
fix 4926618 = enabled
fix 8792846 = enabled
fix 9474259 = enabled
fix 9495669 = disabled
fix 6472966 = enabled
fix 6408301 = enabled
fix 9380298 = disabled
fix 8500130 = enabled
fix 9584723 = enabled
fix 9270951 = enabled
fix 9508254 = enabled
fix 9593680 = enabled
fix 9196440 = disabled
fix 9309281 = enabled
fix 8693158 = enabled
fix 9381638 = enabled
fix 9383967 = enabled
fix 7711900 = enabled
fix 9218587 = enabled
fix 9728438 = enabled
fix 9038395 = enabled
fix 9577300 = enabled
fix 9171113 = enabled
fix 8973745 = enabled
fix 9732434 = enabled
fix 8937971 = disabled
fix 9102474 = enabled
fix 9243499 = enabled
fix 9791810 = enabled
fix 9785632 = enabled
fix 9898249 = enabled
fix 9153459 = enabled
fix 9680430 = enabled
fix 9841679 = enabled
fix 9912503 = enabled
fix 9850461 = enabled
fix 9762592 = 3
fix 9716877 = enabled
fix 9814067 = enabled
fix 9776736 = enabled
fix 8349119 = enabled
fix 9958518 = enabled
fix 10041074 = enabled
fix 10004943 = enabled
fix 9980661 = enabled
fix 9554026 = enabled
fix 9593547 = enabled
fix 9833381 = enabled
fix 10043801 = enabled
fix 9940732 = enabled
fix 9702850 = enabled
fix 9659125 = 0
fix 9668086 = enabled
fix 9476520 = enabled
fix 10158107 = enabled
fix 10148457 = enabled
fix 10106423 = enabled
fix 9721439 = disabled
fix 10162430 = enabled
fix 10134677 = enabled
fix 10182051 = 3
fix 10175079 = enabled
fix 10026972 = enabled
fix 10192889 = enabled
fix 3566843 = enabled
fix 9550277 = disabled
fix 10236566 = enabled
fix 10227392 = enabled
fix 8961143 = enabled
fix 9721228 = enabled
fix 10080014 = enabled
fix 10101489 = enabled
fix 9929609 = enabled
fix 10015652 = enabled
fix 9918661 = enabled
fix 10333395 = enabled
fix 10336499 = disabled
fix 10182672 = enabled
fix 9578670 = enabled
fix 10232225 = enabled
fix 10330090 = enabled
fix 10232623 = enabled
fix 9630092 = disabled
fix 10271790 = enabled
fix 9227576 = enabled
fix 10197666 = enabled
fix 10376744 = enabled
fix 8274946 = enabled
fix 10046368 = enabled
fix 9569678 = enabled
fix 9002661 = enabled
fix 10038373 = enabled
fix 9477688 = enabled
fix 10013899 = enabled
fix 9832338 = enabled
fix 10623119 = enabled
fix 9898066 = enabled
fix 11699884 = enabled
fix 10640430 = enabled
fix 10428450 = enabled
fix 10117760 = enabled
fix 11720178 = enabled
fix 9881812 = enabled
fix 10428278 = enabled
fix 11741436 = enabled
fix 11668189 = enabled
fix 10359631 = enabled
fix 9829887 = enabled
fix 8275054 = enabled
fix 11814428 = enabled
fix 11676888 = disabled
fix 10348427 = enabled
fix 11843512 = enabled
fix 11657468 = enabled
fix 11877160 = enabled
fix 11738631 = enabled
fix 11744086 = enabled
fix 11830663 = enabled
fix 11853331 = enabled
fix 9748015 = enabled
fix 11834739 = enabled
fix 6055658 = enabled
fix 11740670 = enabled
fix 11940126 = enabled
fix 12315002 = enabled
fix 8275023 = enabled
fix 12352373 = enabled
fix 12390139 = enabled
fix 11935589 = enabled
fix 10226906 = enabled
fix 12327548 = enabled
fix 12388221 = enabled
fix 11892888 = enabled
fix 11814265 = enabled
fix 10230017 = enabled
fix 12341619 = enabled
fix 11744016 = enabled
fix 10216738 = enabled
fix 10298302 = enabled
fix 12563419 = enabled
fix 12399886 = enabled
fix 12584007 = enabled
fix 11881047 = enabled
fix 12534597 = enabled
fix 8683604 = enabled
fix 12410972 = enabled
fix 7147087 = enabled
fix 11846314 = enabled
fix 12535474 = enabled
fix 12561635 = enabled
fix 12432426 = enabled
fix 9913117 = enabled
fix 12432089 = enabled
fix 12587690 = enabled
fix 11858963 = enabled
fix 12569245 = enabled
fix 12569300 = enabled
fix 7308975 = disabled
fix 12569316 = enabled
fix 12569321 = enabled
fix 12335617 = enabled
fix 9002958 = enabled
fix 12591120 = enabled
fix 11876260 = enabled
fix 12313574 = enabled
fix 12569713 = enabled
fix 12348584 = enabled
fix 10420220 = enabled
fix 12559453 = enabled
fix 12727549 = enabled
fix 12728203 = enabled
fix 12828479 = enabled
fix 10181153 = enabled
fix 9971371 = disabled
fix 12864791 = enabled
fix 12810427 = enabled
fix 12605402 = enabled
fix 12861609 = enabled
fix 12915337 = enabled
fix 12942119 = enabled
fix 12622441 = enabled
fix 11072246 = enabled
fix 12739252 = enabled
fix 12953765 = enabled
fix 12905116 = enabled
fix 12978495 = enabled
fix 9633142 = disabled
fix 3639130 = enabled
fix 12827166 = enabled
fix 12944193 = enabled
fix 13020272 = enabled
fix 12673320 = enabled
fix 12975771 = enabled
fix 12882092 = enabled
fix 12379334 = enabled
fix 12723414 = enabled
fix 9488694 = disabled
fix 13255388 = 10
fix 11727871 = enabled
fix 13110511 = enabled
fix 13075297 = enabled
fix 13345888 = enabled
fix 11657903 = disabled
fix 13396096 = enabled
fix 12591379 = enabled
fix 13398214 = enabled
fix 13382280 = enabled
fix 12869367 = enabled
fix 12999577 = enabled
fix 12433153 = enabled
fix 9094254 = enabled
fix 13104618 = enabled
fix 13524237 = enabled
fix 11813257 = enabled
fix 13489017 = enabled
fix 12954320 = enabled
fix 13555551 = enabled
fix 13499154 = enabled
fix 13036910 = enabled
fix 13545925 = enabled
fix 13545956 = enabled
fix 13545989 = enabled
fix 12839247 = enabled
fix 9858777 = enabled
fix 13568366 = enabled
fix 13393357 = enabled
fix 13040171 = enabled
fix 13406619 = enabled
fix 13594757 = enabled
fix 13543207 = enabled
fix 13594712 = enabled
fix 12648629 = enabled
fix 13549808 = enabled
fix 13634700 = enabled
fix 8792821 = enabled
fix 13454409 = enabled
fix 13146487 = enabled
fix 13592248 = enabled
fix 11689541 = enabled
fix 13527374 = enabled
fix 13430622 = enabled
fix 13704562 = enabled
fix 9547706 = enabled
fix 13497184 = enabled
fix 13704977 = enabled
fix 13734456 = enabled
fix 13070532 = enabled
fix 6520878 = enabled
fix 2273284 = enabled
fix 13786127 = enabled
fix 13065064 = enabled
fix 13972896 = enabled
fix 11843466 = enabled
fix 13777823 = enabled
fix 13616573 = enabled
fix 13831671 = enabled
fix 13652216 = enabled
fix 13912192 = enabled
fix 13909909 = enabled
fix 13849486 = enabled
fix 13321547 = enabled
fix 13886606 = disabled
fix 14013502 = enabled
fix 13850256 = enabled
fix 13929275 = enabled
fix 11732303 = enabled
fix 13906168 = enabled
fix 14055128 = enabled
fix 12856200 = enabled
fix 14008590 = enabled
fix 13627489 = disabled
fix 13961105 = enabled
fix 13583722 = enabled
fix 13076238 = enabled
fix 13936229 = enabled
fix 9852856 = enabled
fix 3904125 = enabled
fix 5910187 = enabled
fix 10068316 = enabled
fix 14029891 = enabled
fix 4215125 = enabled
fix 13711083 = enabled
fix 13973691 = enabled
fix 13486825 = enabled
fix 13682550 = enabled
fix 13826669 = enabled
fix 14033181 = enabled
fix 13836796 = enabled
fix 12555499 = enabled
fix 13568506 = enabled
fix 9891396 = enabled
fix 13699643 = enabled
fix 13835788 = enabled
fix 7271518 = enabled
fix 14127824 = enabled
fix 12557401 = enabled
fix 13350470 = enabled
fix 14095362 = enabled
fix 13000118 = enabled
fix 14254795 = enabled
fix 14012261 = enabled
fix 14241953 = enabled
fix 14221012 = enabled
fix 13329748 = enabled
fix 13843964 = enabled
fix 14254052 = enabled
fix 13814866 = enabled
fix 14255600 = disabled
fix 13735304 = enabled
fix 14142884 = disabled
fix 12909121 = enabled
fix 14464068 = enabled
fix 14295250 = 45000
fix 6873091 = enabled
fix 13448445 = enabled
fix 14155722 = enabled
fix 14098180 = enabled
fix 11905801 = enabled
fix 14467202 = enabled
fix 14541122 = enabled
fix 13905599 = disabled
fix 14320077 = enabled
fix 14243782 = enabled
fix 9114915 = enabled
fix 14516175 = enabled
fix 12812697 = enabled
fix 13109345 = enabled
fix 14456124 = enabled
fix 14605040 = enabled
fix 14595273 = disabled
fix 14176247 = enabled
fix 11894476 = enabled
fix 14256885 = enabled
fix 14545269 = disabled
fix 14668404 = disabled
fix 14144611 = enabled
fix 14346182 = enabled
fix 13083139 = enabled
fix 14726188 = enabled
fix 14707009 = enabled
fix 14703133 = enabled
fix 14618560 = enabled
fix 14170552 = enabled
fix 13263174 = enabled
fix 14669785 = enabled
fix 14633570 = enabled
fix 14755138 = enabled
fix 14682092 = enabled
fix 14712222 = enabled
fix 14570575 = enabled
fix 14707748 = disabled
fix 14684079 = enabled
fix 13245379 = enabled
fix 13853916 = enabled
fix 13699007 = enabled
fix 14843189 = enabled
fix 14147762 = enabled
fix 14795969 = enabled
fix 14746036 = 1
fix 14750501 = enabled
fix 13891981 = enabled
fix 15996520 = enabled
fix 16026776 = enabled
fix 13573073 = enabled
fix 13263455 = enabled
fix 16053273 = enabled
fix 16029607 = enabled
fix 14242833 = enabled
fix 13362020 = enabled
fix 13799389 = enabled
fix 12693573 = enabled
fix 15998585 = enabled
fix 16166364 = enabled
fix 14723910 = enabled
fix 15873008 = enabled
fix 14133928 = enabled
fix 16085999 = enabled
fix 14176203 = enabled
fix 16226575 = enabled
fix 16015637 = enabled
fix 15968693 = disabled
fix 16220895 = enabled
fix 16178821 = enabled
fix 11865196 = enabled
fix 16237969 = enabled
fix 16058481 = enabled
fix 13361493 = enabled
fix 16264537 = enabled
fix 14401107 = enabled
fix 13943459 = enabled
fix 13994546 = enabled
fix 7174435 = enabled
fix 14750443 = enabled
fix 14469756 = enabled
fix 14552075 = enabled
fix 16324844 = enabled
fix 13583529 = enabled
fix 14565911 = enabled
fix 13526551 = enabled
fix 16368002 = enabled
fix 16077770 = enabled
fix 16419357 = enabled
fix 15889476 = disabled
fix 16273483 = enabled
fix 16496848 = disabled
fix 14107333 = enabled
fix 11814337 = enabled
fix 15882436 = enabled
fix 14764840 = enabled
fix 16226660 = enabled
fix 16555865 = enabled
fix 16625151 = enabled
fix 16092378 = enabled
fix 16487030 = enabled
fix 9552303 = enabled
fix 16609749 = enabled
fix 16751246 = enabled
fix 13253977 = enabled
fix 14058291 = disabled
fix 16749025 = enabled
fix 16750067 = enabled
fix 16726844 = enabled
fix 15899648 = enabled
fix 16690013 = enabled
fix 15996156 = enabled
fix 16544878 = enabled
fix 9413591 = disabled
fix 16792882 = 0
fix 16725982 = enabled
fix 14648222 = enabled
fix 16799181 = enabled
fix 16516883 = enabled
fix 16507317 = enabled
fix 16837274 = enabled
fix 14085520 = enabled
fix 16713081 = enabled
fix 14703295 = enabled
fix 16908409 = enabled
fix 16212250 = enabled
fix 13692395 = disabled
fix 17087729 = enabled
fix 17088819 = enabled
fix 13848786 = enabled
fix 13522189 = enabled
fix 16400122 = enabled
fix 16796185 = enabled
fix 15950252 = enabled
fix 17070464 = enabled
fix 16976121 = enabled
fix 14580303 = enabled
fix 16554552 = enabled
fix 16582322 = enabled
fix 16712213 = enabled
fix 17382690 = enabled
fix 14846352 = enabled
fix 16516751 = enabled
fix 3174223 = enabled
fix 8611462 = enabled
fix 14851437 = 3
fix 17348895 = enabled
fix 16515789 = enabled
fix 5451645 = disabled
fix 14062749 = enabled
fix 16346018 = enabled
fix 12977599 = enabled
fix 14191778 = enabled
fix 15939321 = enabled
fix 16874299 = enabled
fix 16470836 = enabled
fix 16805362 = disabled
fix 17442009 = disabled
fix 16825679 = enabled
fix 17543180 = enabled
fix 17301564 = enabled
fix 12373708 = enabled
fix 17397506 = enabled
fix 14558315 = enabled
fix 16615686 = enabled
fix 16622801 = enabled
fix 10038517 = enabled
fix 16954950 = enabled
fix 17728161 = enabled
fix 17760375 = enabled
fix 14311185 = enabled
fix 13077335 = disabled
fix 13458979 = disabled
fix 17485514 = enabled
fix 17599514 = enabled
fix 17640863 = enabled
fix 17716301 = enabled
fix 17368047 = disabled
fix 17597748 = enabled
fix 17303359 = enabled
fix 17376322 = disabled
fix 16391176 = disabled
fix 16673868 = enabled
fix 17800514 = enabled
fix 14826303 = enabled
fix 17663076 = enabled
fix 17760755 = enabled
fix 17793460 = enabled
fix 17997159 = enabled
fix 17938754 = enabled
fix 14733442 = enabled
fix 17727676 = enabled
fix 17781659 = enabled
fix 17526569 = enabled
fix 17950612 = enabled
fix 17760686 = enabled
fix 17696414 = enabled
fix 17799716 = enabled
fix 18116777 = enabled
fix 18159664 = disabled
fix 16052625 = enabled
fix 18091750 = enabled
fix 17572606 = enabled
fix 17971955 = enabled
fix 17946915 = enabled
fix 18196576 = enabled
fix 10145667 = enabled
fix 17736165 = enabled
fix 16434021 = enabled
fix 18035463 = enabled
fix 18011820 = enabled
fix 16405740 = enabled
fix 14612201 = enabled
fix 17491018 = enabled
fix 18365267 = enabled
fix 17986549 = enabled
fix 18115594 = enabled
fix 18182018 = enabled
fix 18302923 = enabled
fix 18377553 = enabled
fix 5677419 = enabled
fix 17896018 = disabled
fix 13097308 = enabled
fix 17863980 = enabled
fix 17567154 = enabled
fix 18398980 = enabled
fix 17023040 = enabled
fix 17991403 = 1
fix 16033838 = enabled
fix 17908541 = enabled
fix 18134680 = enabled
fix 18405517 = 0
fix 18304693 = enabled
fix 18456944 = enabled
fix 18467455 = enabled
fix 18425876 = enabled
fix 18508675 = enabled
fix 17473046 = disabled
fix 18636079 = enabled
fix 18388128 = enabled
fix 18415557 = enabled
fix 18385778 = enabled
fix 18308329 = enabled
fix 18461984 = enabled
fix 17973658 = enabled
fix 18558952 = enabled
fix 9912950 = enabled
fix 18751128 = enabled
fix 16809786 = enabled
fix 18795224 = enabled
fix 14776289 = enabled
fix 18823135 = enabled
fix 18874242 = enabled
fix 18770199 = disabled
fix 4185270 = disabled
fix 18765574 = enabled
fix 18754357 = disabled
fix 18959892 = enabled
fix 17324379 = disabled
fix 18952882 = enabled
fix 18924221 = enabled
fix 18422714 = enabled
fix 18798414 = enabled
fix 18969167 = enabled
fix 16191689 = enabled
fix 18907562 = enabled
fix 19055664 = enabled
fix 18898582 = enabled
fix 18960760 = enabled
fix 19070454 = enabled
fix 19230097 = enabled
fix 19063497 = enabled
fix 19046459 = enabled
fix 19269482 = enabled
fix 18876528 = enabled
fix 19227996 = enabled
fix 18864613 = enabled
fix 19239478 = enabled
fix 19451895 = enabled
fix 19450139 = enabled
fix 18907390 = enabled
fix 19025959 = enabled
fix 19309574 = enabled
fix 16774698 = enabled
fix 16923858 = 6
fix 19546825 = enabled
fix 19475484 = enabled
fix 19498595 = enabled
fix 16934526 = enabled
fix 19287919 = enabled
fix 19386746 = enabled
fix 19774486 = enabled
fix 19803410 = enabled
fix 18671960 = enabled
fix 19484911 = enabled
fix 19731940 = enabled
fix 19604408 = enabled
fix 14402409 = enabled
fix 16486095 = enabled
fix 19563657 = enabled
fix 19632232 = enabled
fix 19889960 = enabled
fix 17208933 = enabled
fix 19710102 = enabled
fix 18697515 = enabled
fix 18318631 = enabled
fix 19377983 = enabled
fix 20078639 = enabled
fix 19503668 = enabled
fix 20124288 = enabled
fix 19847091 = enabled
fix 12989345 = enabled
fix 12618642 = enabled
fix 19779920 = enabled
fix 20186282 = enabled
fix 20186295 = enabled
fix 19563433 = enabled
fix 19848804 = enabled
fix 20046257 = enabled
fix 20265690 = enabled
fix 16047938 = enabled
fix 19507904 = enabled
fix 18915345 = enabled
fix 20173686 = disabled
fix 20329321 = enabled
fix 20225191 = enabled
fix 18776755 = enabled
fix 19882842 = enabled
fix 20010996 = enabled
fix 20445764 = disabled
fix 19728543 = disabled
fix 20379571 = enabled
fix 20129763 = enabled
fix 19899588 = enabled
fix 10098852 = enabled
fix 19663421 = disabled
fix 20355502 = 0
fix 20526705 = enabled
fix 20465582 = enabled
fix 20581886 = disabled
fix 16732417 = enabled
fix 20732410 = enabled
fix 20289688 = enabled
fix 20543684 = enabled
fix 20636003 = enabled
fix 20506136 = enabled
fix 20458598 = disabled
fix 20830312 = enabled
fix 19768896 = enabled
fix 20321661 = enabled
fix 19814541 = enabled
fix 20933264 = enabled
fix 17443547 = enabled
fix 20602794 = enabled
fix 19123152 = enabled
fix 19899833 = enabled
fix 20754928 = enabled
fix 20808265 = enabled
fix 20808192 = enabled
fix 20340595 = enabled
fix 14474264 = disabled
fix 20508819 = enabled
fix 21098866 = disabled
fix 18949550 = enabled
fix 14775297 = enabled
fix 19568958 = disabled
fix 20923950 = enabled
fix 21283159 = enabled
fix 17497847 = enabled
fix 21211629 = enabled
fix 20819668 = disabled
fix 20232513 = enabled
fix 20906782 = enabled
fix 20587527 = enabled
fix 20914534 = disabled
fix 20830544 = enabled
fix 16851194 = enabled
fix 19186783 = enabled
fix 19653920 = enabled
fix 21211786 = enabled
fix 21057343 = enabled
fix 21503478 = enabled
fix 19808939 = disabled
fix 21476032 = enabled
fix 20859246 = enabled
fix 20838633 = 2
fix 21639419 = enabled
fix 20951803 = enabled
fix 21683982 = enabled
fix 20216500 = enabled
fix 21614112 = enabled
fix 20906162 = enabled
fix 20854798 = enabled
fix 21509656 = enabled
fix 21833220 = enabled
fix 21802552 = enabled
fix 21452843 = enabled
fix 21553593 = enabled
fix 21093805 = enabled
fix 16220085 = disabled
fix 21800590 = enabled
fix 21273039 = enabled
fix 16750133 = enabled
fix 22013607 = enabled
fix 22152372 = enabled
fix 22077191 = enabled
fix 22123025 = enabled
fix 16913734 = enabled
fix 8357294 = enabled
fix 12670904 = enabled
fix 21979983 = enabled
fix 22158526 = enabled
fix 21971099 = enabled
fix 22090662 = enabled
fix 22149010 = disabled
fix 21300129 = enabled
fix 21339278 = enabled
fix 20270511 = enabled
fix 21424812 = enabled
fix 22114090 = enabled
fix 22310074 = disabled
fix 22159570 = enabled
fix 22272439 = enabled
fix 22372694 = enabled
fix 22514195 = enabled
fix 20413540 = enabled
fix 22520315 = enabled
fix 22649054 = enabled
fix 8617254 = enabled
fix 22020067 = enabled
fix 22864730 = enabled
fix 21099502 = enabled
fix 22904304 = enabled
fix 22967807 = enabled
fix 22879002 = enabled
fix 23019286 = enabled
fix 22760704 = enabled
fix 20853506 = enabled
fix 22540411 = disabled
fix 22513493 = enabled
fix 22518491 = enabled
fix 23103096 = enabled
fix 22143411 = enabled
fix 23180670 = enabled
fix 23002609 = enabled
fix 22928015 = 1
fix 23210039 = enabled
fix 23102649 = enabled
fix 23071621 = enabled
fix 22822245 = enabled
fix 23136865 = enabled
fix 23176721 = enabled
fix 23308385 = enabled
fix 23223113 = enabled
fix 22301868 = disabled
fix 22258300 = enabled
fix 22205301 = enabled
fix 23514473 = 1
fix 23556483 = enabled
fix 21305617 = enabled
fix 22533539 = enabled
fix 23596611 = enabled
fix 20347374 = disabled
fix 22937293 = enabled
fix 20107874 = enabled
fix 19582337 = enabled
fix 22746853 = enabled
fix 23537232 = enabled
fix 23565188 = enabled
fix 20228468 = enabled
fix 22393169 = enabled
fix 24426912 = enabled
fix 24690046 = enabled
fix 23732552 = enabled
fix 20648883 = enabled
fix 24654471 = enabled
fix 23738304 = enabled
fix 24010030 = enabled
fix 22766607 = enabled
fix 24600280 = enabled
fix 24845754 = enabled
fix 24533235 = enabled
fix 22128803 = enabled
fix 24926999 = enabled
fix 24434608 = enabled
fix 25094218 = enabled
fix 24819957 = enabled
fix 23478835 = enabled
fix 24745366 = enabled
fix 24920138 = disabled
fix 24570810 = enabled
fix 25058954 = enabled
fix 24518392 = enabled
fix 23738186 = enabled
fix 25234139 = enabled
fix 25108065 = enabled
fix 22212124 = enabled
fix 25123105 = enabled
fix 25078728 = enabled
fix 23719498 = 0
fix 25090203 = enabled
fix 23197730 = enabled
fix 23738553 = enabled
fix 22070473 = enabled
fix 19956351 = enabled
fix 25393617 = enabled
fix 21130817 = enabled
fix 25342352 = enabled
fix 25167306 = disabled
fix 23473108 = enabled
fix 25501716 = enabled
fix 22973474 = enabled
fix 22153026 = enabled
fix 25367727 = enabled
fix 25477783 = enabled
fix 25493582 = enabled
fix 22205362 = enabled
fix 23249829 = enabled
fix 25120742 = enabled
fix 23853877 = disabled
fix 25796244 = enabled
fix 25575369 = enabled
fix 25643889 = disabled
fix 25436615 = enabled
fix 25478095 = enabled
fix 25405100 = enabled
fix 24952618 = enabled
fix 25809211 = enabled
fix 26094674 = enabled
fix 21183079 = enabled
fix 25948370 = enabled
fix 24545933 = enabled
fix 25926263 = enabled
fix 26019148 = enabled
fix 25995431 = enabled
fix 21870589 = enabled
fix 24584046 = enabled
fix 26374214 = enabled
fix 25476149 = enabled
fix 25345279 = enabled
fix 24478915 = enabled
fix 26541991 = enabled
fix 26338880 = enabled
fix 26270685 = disabled
fix 26560136 = enabled
fix 26671842 = enabled
fix 26712343 = enabled
fix 26585420 = enabled
fix 26677151 = enabled
fix 26367868 = enabled
fix 25323193 = disabled
fix 26552730 = disabled
fix 26177646 = enabled
fix 23643560 = enabled
fix 25792706 = enabled
fix 27057772 = disabled
fix 26986173 = enabled
fix 26423085 = enabled
fix 27077069 = enabled
fix 26536320 = enabled
fix 25138211 = enabled
fix 27321179 = enabled
fix 27343844 = enabled
fix 26790514 = enabled
fix 27282295 = enabled
fix 27432718 = enabled
fix 27268249 = enabled
fix 25507796 = enabled
fix 25507810 = enabled
fix 25507823 = disabled
fix 25507828 = enabled
fix 25660695 = enabled
fix 27311177 = enabled
fix 24841671 = enabled
fix 26842212 = enabled
fix 27559630 = enabled
fix 27436816 = enabled
fix 23098284 = enabled
fix 26660568 = enabled
fix 27693205 = enabled
fix 27096140 = disabled
fix 27174324 = enabled
fix 27000158 = enabled
fix 27208525 = enabled
fix 27745220 = enabled
fix 26527656 = enabled
fix 27675947 = disabled
fix 26566785 = enabled
fix 27175987 = enabled
fix 8932139 = enabled
fix 18816560 = enabled
fix 27466597 = enabled
fix 27210659 = enabled
fix 27643128 = enabled
fix 27782339 = enabled
fix 24761824 = enabled
fix 27634227 = enabled
fix 26733841 = enabled
fix 27971253 = enabled
fix 22174392 = enabled
fix 27730925 = enabled
fix 22559379 = enabled
fix 27622097 = enabled
fix 20424684 = enabled
fix 27593424 = enabled
fix 28096482 = enabled
fix 24573561 = enabled
fix 22582700 = enabled
fix 28201419 = enabled
fix 26836964 = disabled
fix 27991474 = enabled
fix 28210382 = enabled
fix 27500916 = enabled
fix 28012754 = 7
fix 28071742 = enabled
fix 27836278 = enabled
fix 28256899 = enabled
fix 28345522 = 0
fix 28084251 = enabled
fix 23058521 = enabled
fix 28242450 = enabled
fix 28135957 = enabled
fix 27680422 = 1
fix 28378804 = enabled
fix 28660798 = enabled
fix 28606162 = disabled
fix 28816113 = enabled
fix 27541468 = enabled
fix 28725660 = enabled
fix 29450812 = disabled
fix 29687220 = disabled
fix 28072567 = enabled
fix 28835937 = enabled
fix 29331066 = disabled
fix 30232638 = disabled
fix 28498976 = disabled
fix 28965084 = disabled
fix 28776811 = disabled
fix 28567417 = disabled
fix 28558645 = disabled
fix 29132869 = disabled
fix 29939400 = disabled
fix 30001331 = disabled
fix 28776431 = disabled
fix 28144569 = disabled
fix 30028663 = 0
fix 29304314 = disabled
fix 29653132 = disabled
fix 29930457 = disabled
fix 28602253 = disabled
fix 30347410 = disabled
fix 29937655 = disabled
fix 30602828 = disabled
fix 30896685 = disabled
fix 31069997 = disabled
fix 31077481 = disabled
fix 27261477 = disabled
fix 30972817 = disabled
fix 30222669 = disabled
fix 31444353 = 0
fix 30998035 = disabled
fix 30198239 = 0
fix 29487407 = disabled
fix 29302565 = disabled
fix 30486896 = disabled
fix 19138896 = disabled
fix 30681521 = 0
fix 28999046 = disabled
fix 30902655 = disabled
fix 30786641 = disabled
fix 31895670 = disabled
fix 30616738 = disabled
fix 31668694 = disabled
fix 31001490 = disabled
fix 30980115 = disabled
fix 31670824 = disabled
fix 30570982 = disabled
fix 9876287 = disabled
fix 30564898 = disabled
fix 32075777 = disabled
fix 32037237 = disabled
fix 30927440 = disabled
fix 30822446 = disabled
fix 24561942 = disabled
fix 31625959 = disabled
fix 31579233 = disabled
fix 29696242 = disabled
fix 31626438 = disabled
fix 30228422 = disabled
fix 17295505 = disabled
fix 29725425 = disabled
fix 30618230 = disabled
fix 30008456 = 0
fix 30537403 = disabled
fix 30235878 = disabled
fix 30646077 = disabled
fix 29657973 = disabled
fix 29712727 = disabled
fix 20922160 = disabled
fix 30006705 = disabled
fix 29463553 = disabled
fix 30751171 = disabled
fix 31009032 = disabled
fix 30063629 = disabled
fix 30207519 = disabled
fix 31517502 = disabled
fix 30617002 = disabled
fix 30483217 = disabled
fix 30235691 = disabled
fix 30568514 = disabled
fix 28414968 = 0
fix 32014520 = disabled
fix 30249927 = disabled
fix 31580374 = disabled
fix 29590666 = disabled
fix 29435966 = disabled
fix 28173995 = disabled
fix 29867728 = disabled
fix 30776676 = disabled
fix 26577716 = disabled
fix 30470947 = disabled
fix 30979701 = disabled
fix 30483184 = disabled
fix 31001295 = disabled
fix 31191224 = disabled
fix 31974424 = disabled
fix 29385774 = disabled
fix 28234255 = 3
Query Block Registry:
SEL$1 0xf3191e60 (PARSER) [FINAL]
:
call(in-use=17376, alloc=124240), compile(in-use=111768, alloc=174784), execution(in-use=9248, alloc=12144)
End of Optimizer State Dump
Dumping Hints
=============
====================== END SQL Statement Dump ======================
*** 2022-08-11T15:51:32.903593+00:00 (PDBB1(3))
*** TRACE CONTINUES IN FILE /u01/app/oracle/diag/rdbms/racdbb/racdbb1/trace/racdbb1_ora_335870_AFTER.trc ***
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment