Created
June 6, 2015 20:44
-
-
Save xtender/44e996bee18c41e6abda to your computer and use it in GitHub Desktop.
parallel with dual
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alter session force parallel query parallel 8; | |
| with v as (select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5) | |
| select/*+ parallel(v 8) dynalic_sampling(v 10) */ distinct userenv('sid') | |
| from v; | |
| USERENV('SID') | |
| -------------- | |
| 18 | |
| 79 | |
| 2 rows selected. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Trace file N:\ORACLE\diag\rdbms\baikal\baikal\trace\baikal_ora_17080_parallel_dual.trc | |
| Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production | |
| With the Partitioning, OLAP, Data Mining and Real Application Testing options | |
| Windows NT Version V6.1 Service Pack 1 | |
| CPU : 4 - type 8664, 4 Physical Cores | |
| Process Affinity : 0x0x0000000000000000 | |
| Memory (Avail/Total): Ph:129M/4094M, Ph+PgF:3083M/11427M | |
| Instance name: baikal | |
| Redo thread mounted by this instance: 1 | |
| Oracle process number: 29 | |
| Windows thread id: 17080, image: ORACLE.EXE (SHAD) | |
| *** 2015-06-06 23:37:30.938 | |
| *** SESSION ID:(69.1945) 2015-06-06 23:37:30.938 | |
| *** CLIENT ID:() 2015-06-06 23:37:30.938 | |
| *** SERVICE NAME:(baikal) 2015-06-06 23:37:30.938 | |
| *** MODULE NAME:(SQL*Plus) 2015-06-06 23:37:30.938 | |
| *** ACTION NAME:() 2015-06-06 23:37:30.938 | |
| Registered qb: SEL$1 0x176d7d78 (PARSER) | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (): qb_name=SEL$1 nbfros=1 flg=0 | |
| fro(0): flg=4 objn=116 hint_alias="DUAL"@"SEL$1" | |
| Registered qb: SEL$2 0x176d5f78 (PARSER) | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (): qb_name=SEL$2 nbfros=1 flg=0 | |
| fro(0): flg=5 objn=0 hint_alias="V"@"SEL$2" | |
| SPM: statement not found in SMB | |
| ************************** | |
| Automatic degree of parallelism (ADOP) | |
| ************************** | |
| Automatic degree of parallelism is disabled: Parameter. | |
| PM: Considering predicate move-around in query block SEL$2 (#0) | |
| ************************** | |
| Predicate Move-Around (PM) | |
| ************************** | |
| OPTIMIZER INFORMATION | |
| ****************************************** | |
| ----- Current SQL Statement for this session (sql_id=dcg7nggm1n96h) ----- | |
| with v as (select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5) | |
| select/*+ parallel(v 8) dynalic_sampling(v 10) */ distinct userenv('sid') | |
| from v | |
| ******************************************* | |
| 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 | |
| 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 | |
| *************************************** | |
| PARAMETERS USED BY THE OPTIMIZER | |
| ******************************** | |
| ************************************* | |
| PARAMETERS WITH ALTERED VALUES | |
| ****************************** | |
| Compilation Environment Dump | |
| parallel_query_forced_dop = 8 | |
| parallel_query_mode = forced | |
| parallel_query_default_dop = 8 | |
| parallel_degree_limit = 32 | |
| 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_dml_forced_dop = 0 | |
| parallel_ddl_forced_degree = 0 | |
| parallel_ddl_forced_instances = 0 | |
| _query_rewrite_fudge = 90 | |
| optimizer_features_enable = 11.2.0.4 | |
| _optimizer_search_limit = 5 | |
| cpu_count = 4 | |
| active_instance_count = 1 | |
| parallel_threads_per_cpu = 2 | |
| 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 = 589824 KB | |
| _pga_max_size = 204800 KB | |
| _query_rewrite_maxdisjunct = 257 | |
| _smm_auto_min_io_size = 56 KB | |
| _smm_auto_max_io_size = 248 KB | |
| _smm_min_size = 589 KB | |
| _smm_max_size_static = 102400 KB | |
| _smm_px_max_size_static = 294912 KB | |
| _cpu_to_io = 0 | |
| _optimizer_undo_cost_change = 11.2.0.4 | |
| parallel_dml_mode = disabled | |
| parallel_ddl_mode = enabled | |
| optimizer_mode = all_rows | |
| sqlstat_enabled = false | |
| _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 = true | |
| _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 = typical | |
| _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 = 80 | |
| _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 | |
| 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_pushdown_to_storage = true | |
| _bloom_vector_elements = 0 | |
| _bloom_pushing_max = 512 | |
| parallel_force_local = false | |
| parallel_max_degree = 8 | |
| total_cpu_count = 4 | |
| _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 | |
| deferred_segment_creation = true | |
| _optimizer_filter_pushdown = true | |
| _allow_level_without_connect_by = false | |
| _max_rwgs_groupings = 8192 | |
| _optimizer_outer_join_to_inner = true | |
| _optimizer_full_outer_join_to_outer = true | |
| _px_numa_support_enabled = true | |
| total_processor_group_count = 1 | |
| _bloom_sm_enabled = false | |
| _bloom_serial_filter = on | |
| _parallel_degree_level = 100 | |
| _optimizer_ads_max_table_count = 0 | |
| _optimizer_ads_time_limit = 0 | |
| _optimizer_ads_use_result_cache = true | |
| parallel_dblink = 0 | |
| _optimizer_cluster_by_rowid = false | |
| _optimizer_cluster_by_rowid_control = 3 | |
| 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 8508056 = enabled | |
| fix 8335178 = enabled | |
| fix 8515269 = 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 8571403 = 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 9301862 = disabled | |
| 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 9912503 = enabled | |
| fix 9153459 = enabled | |
| fix 9762592 = 3 | |
| fix 9785632 = enabled | |
| fix 9659125 = 0 | |
| fix 9702850 = enabled | |
| fix 9958518 = enabled | |
| fix 8349119 = enabled | |
| fix 10041074 = enabled | |
| fix 10134677 = enabled | |
| fix 9716877 = enabled | |
| fix 8961143 = enabled | |
| fix 10080014 = enabled | |
| fix 10026972 = enabled | |
| fix 9476520 = enabled | |
| fix 9841679 = enabled | |
| fix 10004943 = enabled | |
| fix 9791810 = enabled | |
| fix 9668086 = enabled | |
| fix 9850461 = enabled | |
| fix 9940732 = enabled | |
| fix 9578670 = enabled | |
| fix 10197666 = enabled | |
| fix 9630092 = disabled | |
| fix 10271790 = enabled | |
| fix 10015652 = enabled | |
| fix 8274946 = enabled | |
| fix 10192889 = enabled | |
| fix 10336499 = disabled | |
| fix 9814067 = enabled | |
| fix 10158107 = enabled | |
| fix 10182051 = 3 | |
| fix 10376744 = enabled | |
| fix 10043801 = enabled | |
| fix 9832338 = disabled | |
| fix 9002661 = enabled | |
| fix 9898066 = enabled | |
| fix 9569678 = enabled | |
| fix 11741436 = enabled | |
| fix 10232623 = enabled | |
| fix 10232225 = enabled | |
| fix 9829887 = enabled | |
| fix 10359631 = enabled | |
| fix 8275054 = enabled | |
| fix 10640430 = enabled | |
| fix 10227392 = enabled | |
| fix 10117760 = enabled | |
| fix 9554026 = disabled | |
| fix 9593547 = disabled | |
| fix 9833381 = disabled | |
| fix 9881812 = enabled | |
| fix 10333395 = enabled | |
| fix 9776736 = enabled | |
| fix 9748015 = enabled | |
| fix 11744086 = enabled | |
| fix 11834739 = enabled | |
| fix 11830663 = enabled | |
| fix 11877160 = enabled | |
| fix 9227576 = enabled | |
| fix 11814428 = enabled | |
| fix 11843512 = enabled | |
| fix 11853331 = enabled | |
| fix 6055658 = enabled | |
| fix 11657468 = enabled | |
| fix 11720178 = enabled | |
| fix 10428278 = enabled | |
| fix 8275023 = enabled | |
| fix 11740670 = enabled | |
| fix 9477688 = enabled | |
| fix 9980661 = enabled | |
| fix 11676888 = disabled | |
| fix 10623119 = enabled | |
| fix 10162430 = enabled | |
| fix 10330090 = enabled | |
| fix 9680430 = enabled | |
| fix 10101489 = enabled | |
| fix 12315002 = enabled | |
| fix 12352373 = enabled | |
| fix 10428450 = enabled | |
| fix 11892888 = enabled | |
| fix 10226906 = enabled | |
| fix 10230017 = enabled | |
| fix 11668189 = enabled | |
| fix 11814265 = enabled | |
| fix 11935589 = enabled | |
| fix 10148457 = enabled | |
| fix 10038373 = enabled | |
| fix 11699884 = enabled | |
| fix 10348427 = enabled | |
| fix 11738631 = enabled | |
| fix 12410972 = enabled | |
| fix 11881047 = enabled | |
| fix 10298302 = enabled | |
| fix 12399886 = enabled | |
| fix 7147087 = enabled | |
| fix 11846314 = enabled | |
| fix 12432426 = enabled | |
| fix 12584007 = enabled | |
| fix 8683604 = enabled | |
| fix 12432089 = enabled | |
| fix 12591120 = enabled | |
| fix 11876260 = enabled | |
| fix 9913117 = enabled | |
| fix 12348584 = enabled | |
| fix 10420220 = enabled | |
| fix 3639130 = enabled | |
| fix 12827166 = enabled | |
| fix 12559453 = enabled | |
| fix 12723414 = enabled | |
| fix 12739252 = enabled | |
| fix 12975771 = enabled | |
| fix 12864791 = enabled | |
| fix 13398214 = enabled | |
| fix 12882092 = enabled | |
| fix 11072246 = enabled | |
| fix 13075297 = enabled | |
| fix 11657903 = disabled | |
| fix 12605402 = enabled | |
| fix 13040171 = enabled | |
| fix 12915337 = enabled | |
| fix 11813257 = enabled | |
| fix 12999577 = enabled | |
| fix 13594712 = enabled | |
| fix 13406619 = enabled | |
| fix 10013899 = enabled | |
| fix 6923730 = 0 | |
| fix 13634700 = enabled | |
| fix 12828479 = enabled | |
| fix 11689541 = enabled | |
| fix 9547706 = enabled | |
| fix 13396096 = enabled | |
| fix 13146487 = enabled | |
| fix 13543207 = enabled | |
| fix 13972896 = enabled | |
| fix 13430622 = enabled | |
| fix 12673320 = enabled | |
| fix 13070532 = enabled | |
| fix 13704562 = enabled | |
| fix 12313574 = enabled | |
| fix 12727549 = enabled | |
| fix 12569713 = enabled | |
| fix 13592248 = enabled | |
| fix 12433153 = enabled | |
| fix 2273284 = enabled | |
| fix 13454409 = enabled | |
| fix 12728203 = enabled | |
| fix 13065064 = enabled | |
| fix 13616573 = enabled | |
| fix 11858963 = enabled | |
| fix 13929275 = enabled | |
| fix 8792821 = enabled | |
| fix 13831671 = enabled | |
| fix 13850256 = enabled | |
| fix 13906168 = enabled | |
| fix 13583722 = enabled | |
| fix 13076238 = enabled | |
| fix 14013502 = enabled | |
| fix 13912192 = enabled | |
| fix 14029891 = enabled | |
| fix 10181153 = enabled | |
| fix 13973691 = enabled | |
| fix 12622441 = enabled | |
| fix 9891396 = enabled | |
| fix 13321547 = enabled | |
| fix 13486825 = enabled | |
| fix 7271518 = enabled | |
| fix 12944193 = enabled | |
| fix 13020272 = enabled | |
| fix 12341619 = enabled | |
| fix 14254795 = enabled | |
| fix 13350470 = enabled | |
| fix 12379334 = enabled | |
| fix 12591379 = enabled | |
| fix 12839247 = enabled | |
| fix 4215125 = enabled | |
| fix 13936229 = enabled | |
| fix 13777823 = enabled | |
| fix 13886606 = disabled | |
| fix 13786127 = enabled | |
| fix 13549808 = enabled | |
| fix 13961105 = enabled | |
| fix 14255600 = disabled | |
| fix 13527374 = enabled | |
| fix 13814866 = enabled | |
| fix 14254052 = enabled | |
| fix 13329748 = enabled | |
| fix 14127824 = enabled | |
| fix 14012261 = enabled | |
| fix 3566843 = enabled | |
| fix 9550277 = disabled | |
| fix 6873091 = enabled | |
| fix 14467202 = enabled | |
| fix 14541122 = enabled | |
| fix 14098180 = enabled | |
| fix 14243782 = enabled | |
| fix 13255388 = 10 | |
| fix 11727871 = enabled | |
| fix 9633142 = disabled | |
| fix 12869367 = enabled | |
| fix 14055128 = enabled | |
| fix 13652216 = enabled | |
| fix 13849486 = enabled | |
| fix 14008590 = enabled | |
| fix 13594757 = enabled | |
| fix 9114915 = enabled | |
| fix 14668404 = disabled | |
| fix 14295250 = 45000 | |
| fix 14221012 = enabled | |
| fix 12812697 = enabled | |
| fix 14456124 = enabled | |
| fix 14595273 = disabled | |
| fix 14545269 = enabled | |
| fix 14703133 = enabled | |
| fix 11894476 = enabled | |
| fix 13393357 = enabled | |
| fix 12534597 = enabled | |
| fix 13489017 = enabled | |
| fix 12335617 = enabled | |
| fix 9094254 = enabled | |
| fix 13104618 = enabled | |
| fix 12942119 = enabled | |
| fix 14256885 = enabled | |
| fix 13943459 = enabled | |
| fix 13263174 = enabled | |
| fix 14311185 = enabled | |
| fix 14795969 = enabled | |
| fix 9971371 = disabled | |
| fix 13843964 = enabled | |
| fix 13853916 = enabled | |
| fix 14755138 = enabled | |
| fix 15996520 = enabled | |
| fix 14147762 = enabled | |
| fix 13263455 = enabled | |
| fix 14750501 = enabled | |
| fix 13497184 = enabled | |
| fix 14707009 = enabled | |
| fix 14684079 = enabled | |
| fix 14669785 = enabled | |
| fix 11905801 = enabled | |
| fix 14142884 = disabled | |
| fix 13711083 = enabled | |
| fix 16053273 = disabled | |
| fix 14346182 = enabled | |
| fix 13627489 = disabled | |
| fix 13891981 = enabled | |
| fix 14320077 = enabled | |
| fix 13083139 = enabled | |
| fix 6520878 = enabled | |
| fix 13362020 = enabled | |
| fix 13799389 = enabled | |
| fix 14170552 = enabled | |
| fix 14144611 = enabled | |
| fix 13499154 = enabled | |
| fix 13382280 = enabled | |
| fix 12557401 = enabled | |
| fix 12861609 = enabled | |
| fix 12555499 = enabled | |
| fix 14723910 = enabled | |
| fix 12693573 = enabled | |
| fix 13524237 = enabled | |
| fix 9858777 = enabled | |
| fix 13568366 = enabled | |
| fix 14242833 = enabled | |
| fix 14133928 = enabled | |
| fix 16220895 = enabled | |
| fix 13826669 = enabled | |
| fix 14176247 = enabled | |
| fix 13361493 = enabled | |
| fix 16264537 = enabled | |
| fix 11865196 = enabled | |
| fix 13905599 = disabled | |
| fix 14712222 = enabled | |
| fix 15998585 = enabled | |
| fix 13526551 = enabled | |
| fix 14107333 = enabled | |
| fix 15882436 = enabled | |
| fix 16273483 = enabled | |
| fix 13682550 = enabled | |
| fix 15889476 = disabled | |
| fix 16202455 = disabled | |
| fix 16226660 = enabled | |
| fix 16093509 = 0 | |
| fix 16092378 = enabled | |
| fix 16487030 = enabled | |
| fix 16419357 = enabled | |
| fix 16690013 = enabled | |
| fix 15996156 = enabled | |
| fix 12914055 = disabled | |
| fix 16792882 = 0 | |
| fix 16726844 = enabled | |
| fix 14682092 = enabled | |
| fix 16799181 = enabled | |
| fix 16582322 = enabled | |
| fix 16712213 = enabled | |
| fix 16516883 = enabled | |
| fix 16725982 = enabled | |
| fix 13253977 = enabled | |
| fix 16554552 = enabled | |
| *************************************** | |
| PARAMETERS IN OPT_PARAM HINT | |
| **************************** | |
| *************************************** | |
| Column Usage Monitoring is ON: tracking level = 1 | |
| *************************************** | |
| Considering Query Transformations on query block SEL$2 (#0) | |
| ************************** | |
| Query transformations (QT) | |
| ************************** | |
| CBQT: copy not possible on query block SEL$2 (#0) because linked to with clause | |
| CBQT bypassed for query block SEL$2 (#0): Cannot copy query block. | |
| CBQT: Validity checks failed for dcg7nggm1n96h. | |
| CSE: Considering common sub-expression elimination in query block SEL$2 (#0) | |
| ************************* | |
| Common Subexpression elimination (CSE) | |
| ************************* | |
| 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). | |
| CSE: CSE not performed on query block SEL$2 (#0). | |
| OBYE: Considering Order-by Elimination from view SEL$2 (#0) | |
| *************************** | |
| Order-by elimination (OBYE) | |
| *************************** | |
| OBYE: OBYE bypassed: no order by to eliminate. | |
| CVM: Considering view merge in query block SEL$2 (#0) | |
| OJE: Begin: find best directive for query block SEL$2 (#0) | |
| OJE: End: finding best directive for query block SEL$2 (#0) | |
| CVM: Checking validity of merging in query block SEL$1 (#0) | |
| 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) | |
| SVM: SVM bypassed: view query block is going to be materialized. | |
| query block SEL$2 (#0) unchanged | |
| Considering Query Transformations on query block SEL$2 (#0) | |
| ************************** | |
| Query transformations (QT) | |
| ************************** | |
| CBQT: copy not possible on query block SEL$2 (#0) because linked to with clause | |
| CBQT bypassed for query block SEL$2 (#0): Cannot copy query block. | |
| CBQT: Validity checks failed for dcg7nggm1n96h. | |
| CSE: Considering common sub-expression elimination in query block SEL$2 (#0) | |
| ************************* | |
| Common Subexpression elimination (CSE) | |
| ************************* | |
| 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). | |
| CSE: CSE not performed on query block SEL$2 (#0). | |
| SU: Considering subquery unnesting in query block SEL$2 (#0) | |
| ******************** | |
| Subquery Unnest (SU) | |
| ******************** | |
| SJC: Considering set-join conversion in query block SEL$2 (#0) | |
| ************************* | |
| Set-Join Conversion (SJC) | |
| ************************* | |
| SJC: not performed | |
| PM: Considering predicate move-around in query block SEL$2 (#0) | |
| ************************** | |
| Predicate Move-Around (PM) | |
| ************************** | |
| PM: PM bypassed: Outer query contains no views. | |
| PM: PM bypassed: Outer query contains no views. | |
| query block SEL$2 (#0) unchanged | |
| FPD: Considering simple filter push in query block SEL$2 (#0) | |
| ?? | |
| FPD: Considering simple filter push in query block SEL$1 (#0) | |
| ?? | |
| apadrv-start sqlid=15437482435697845456 | |
| : | |
| call(in-use=2816, alloc=16344), compile(in-use=64880, alloc=70752), execution(in-use=3280, alloc=4032) | |
| ******************************************* | |
| Peeked values of the binds in SQL statement | |
| ******************************************* | |
| Final query after transformations:******* UNPARSED QUERY IS ******* | |
| SELECT /*+ PARALLEL ("V",8) */ DISTINCT USERENV('SID') "USERENV('SID')" FROM (SELECT /*+ OPT_ESTIMATE (QUERY_BLOCK ROWS=100000.000000 ) PARALLEL ("DUAL",8) */ '1' "X",ROWNUM "RN",'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' "PADDING" FROM "SYS"."DUAL" "DUAL" WHERE ROWNUM>0 CONNECT BY LEVEL<=3e5) "V" | |
| ************************* | |
| First K Rows: Setup begin | |
| kkoqbc: optimizing query block SEL$1 (#0) | |
| : | |
| call(in-use=2864, alloc=16344), compile(in-use=71176, alloc=72720), execution(in-use=3360, alloc=4032) | |
| kkoqbc-subheap (create addr=0x000000001646F9D0) | |
| **************** | |
| QUERY BLOCK TEXT | |
| **************** | |
| select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5 | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0 | |
| fro(0): flg=0 objn=116 hint_alias="DUAL"@"SEL$1" | |
| ----------------------------- | |
| SYSTEM STATISTICS INFORMATION | |
| ----------------------------- | |
| Using NOWORKLOAD Stats | |
| CPUSPEEDNW: 2903 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: DUAL Alias: DUAL | |
| #Rows: 1 #Blks: 1 AvgRowLen: 2.00 ChainCnt: 0.00 | |
| Access path analysis for DUAL | |
| *************************************** | |
| SINGLE TABLE ACCESS PATH | |
| Single Table Cardinality Estimation for DUAL[DUAL] | |
| Table: DUAL Alias: DUAL | |
| Card: Original: 1.000000 Rounded: 1 Computed: 1.00 Non Adjusted: 1.00 | |
| Access Path: TableScan | |
| Cost: 2.00 Resp: 2.00 Degree: 0 | |
| Cost_io: 2.00 Cost_cpu: 150 | |
| Resp_io: 2.00 Resp_cpu: 21 | |
| Best:: AccessPath: TableScan | |
| Cost: 2.00 Degree: 8 Resp: 2.00 Card: 1.00 Bytes: 0 | |
| *************************************** | |
| OPTIMIZER STATISTICS AND COMPUTATIONS | |
| *************************************** | |
| GENERAL PLANS | |
| *************************************** | |
| Considering cardinality-based initial join order. | |
| Permutations for Starting Table :0 | |
| Join order[1]: DUAL[DUAL]#0 | |
| *********************** | |
| Best so far: Table#: 0 cost: 2.0000 card: 1.0000 bytes: 0 | |
| *********************** | |
| ********************************* | |
| Number of join permutations tried: 1 | |
| ********************************* | |
| Enumerating distribution method (advanced) | |
| Or-Expansion validity checks failed on query block SEL$1 (#0) because NO_EXPAND hint | |
| Transfer Optimizer annotations for query block SEL$1 (#0) | |
| Final cost for query block SEL$1 (#0) - All Rows Plan: | |
| Best join order: 1 | |
| Cost: 2.0000 Degree: 8 Card: 1.0000 Bytes: 0 | |
| Resc: 2.0000 Resc_io: 2.0000 Resc_cpu: 150 | |
| Resp: 2.0000 Resp_io: 2.0000 Resc_cpu: 21 | |
| >> Query Blk Card adjusted from 1.000000 to: 100000.000000 | |
| kkoqbc-subheap (delete addr=0x000000001646F9D0, in-use=23784, alloc=32840) | |
| kkoqbc-end: | |
| : | |
| call(in-use=8112, alloc=49288), compile(in-use=71648, alloc=72720), execution(in-use=3360, alloc=4032) | |
| kkoqbc: finish optimizing query block SEL$1 (#0) | |
| kkoqbc: optimizing query block SEL$2 (#0) | |
| : | |
| call(in-use=5904, alloc=49288), compile(in-use=77328, alloc=78056), execution(in-use=3440, alloc=4032) | |
| kkoqbc-subheap (create addr=0x000000001646F9D0) | |
| **************** | |
| QUERY BLOCK TEXT | |
| **************** | |
| with v as (select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5) | |
| select/*+ parallel(v 8) dynalic_sampling(v 10) */ distinct userenv('sid') | |
| from v | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (optimizer): qb_name=SEL$2 nbfros=1 flg=0 | |
| fro(0): flg=1 objn=0 hint_alias="V"@"SEL$2" | |
| ----------------------------- | |
| SYSTEM STATISTICS INFORMATION | |
| ----------------------------- | |
| Using NOWORKLOAD Stats | |
| CPUSPEEDNW: 2903 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: V Alias: V (NOT ANALYZED) | |
| #Rows: 0 #Blks: 0 AvgRowLen: 0.00 ChainCnt: 0.00 | |
| Access path analysis for V | |
| *************************************** | |
| OPTIMIZER STATISTICS AND COMPUTATIONS | |
| *************************************** | |
| GENERAL PLANS | |
| *************************************** | |
| Considering cardinality-based initial join order. | |
| Permutations for Starting Table :0 | |
| Join order[1]: V[V]#0 | |
| *********************** | |
| Best so far: Table#: 0 cost: 5.0000 card: 100000.0000 bytes: 0 | |
| *********************** | |
| ********************************* | |
| Number of join permutations tried: 1 | |
| ********************************* | |
| Enumerating distribution method (advanced) | |
| Or-Expansion validity checks failed on query block SEL$2 (#0) because NO_EXPAND hint | |
| SORT ressource Sort statistics | |
| Sort width: 598 Area size: 603136 Max Area size: 104857600 | |
| Degree: 1 | |
| Blocks to Sort: 123 Row size: 10 Total Rows: 100000 | |
| Initial runs: 2 Merge passes: 1 IO Cost / pass: 68 | |
| Total IO sort cost: 191 Total CPU sort cost: 112693988 | |
| Total Temp space used: 410000 | |
| Transfer Optimizer annotations for query block SEL$2 (#0) | |
| Final cost for query block SEL$2 (#0) - All Rows Plan: | |
| Best join order: 1 | |
| Cost: 194.2355 Degree: 0 Card: 100000.0000 Bytes: 0 | |
| Resc: 194.2355 Resc_io: 191.0000 Resc_cpu: 112693988 | |
| Resp: 194.2355 Resp_io: 191.0000 Resc_cpu: 112693988 | |
| kkoqbc-subheap (delete addr=0x000000001646F9D0, in-use=23784, alloc=32840) | |
| kkoqbc-end: | |
| : | |
| call(in-use=11144, alloc=49288), compile(in-use=77736, alloc=78056), execution(in-use=3808, alloc=4032) | |
| kkoqbc: finish optimizing query block SEL$2 (#0) | |
| First K Rows: Setup end | |
| *********************** | |
| kkoqbc: optimizing query block SEL$1 (#0) | |
| : | |
| call(in-use=8936, alloc=49288), compile(in-use=82928, alloc=86344), execution(in-use=3888, alloc=4032) | |
| kkoqbc-subheap (create addr=0x000000001646DF30) | |
| **************** | |
| QUERY BLOCK TEXT | |
| **************** | |
| select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5 | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0 | |
| fro(0): flg=0 objn=116 hint_alias="DUAL"@"SEL$1" | |
| ----------------------------- | |
| SYSTEM STATISTICS INFORMATION | |
| ----------------------------- | |
| Using NOWORKLOAD Stats | |
| CPUSPEEDNW: 2903 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: DUAL Alias: DUAL | |
| #Rows: 1 #Blks: 1 AvgRowLen: 2.00 ChainCnt: 0.00 | |
| Access path analysis for DUAL | |
| *************************************** | |
| SINGLE TABLE ACCESS PATH | |
| Single Table Cardinality Estimation for DUAL[DUAL] | |
| Table: DUAL Alias: DUAL | |
| Card: Original: 1.000000 Rounded: 1 Computed: 1.00 Non Adjusted: 1.00 | |
| Access Path: TableScan | |
| Cost: 2.00 Resp: 2.00 Degree: 0 | |
| Cost_io: 2.00 Cost_cpu: 150 | |
| Resp_io: 2.00 Resp_cpu: 21 | |
| Best:: AccessPath: TableScan | |
| Cost: 2.00 Degree: 8 Resp: 2.00 Card: 1.00 Bytes: 0 | |
| *************************************** | |
| OPTIMIZER STATISTICS AND COMPUTATIONS | |
| *************************************** | |
| GENERAL PLANS | |
| *************************************** | |
| Considering cardinality-based initial join order. | |
| Permutations for Starting Table :0 | |
| Join order[1]: DUAL[DUAL]#0 | |
| *********************** | |
| Best so far: Table#: 0 cost: 2.0000 card: 1.0000 bytes: 0 | |
| *********************** | |
| ********************************* | |
| Number of join permutations tried: 1 | |
| ********************************* | |
| Enumerating distribution method (advanced) | |
| Or-Expansion validity checks failed on query block SEL$1 (#0) because NO_EXPAND hint | |
| Transfer Optimizer annotations for query block SEL$1 (#0) | |
| Final cost for query block SEL$1 (#0) - All Rows Plan: | |
| Best join order: 1 | |
| Cost: 2.0000 Degree: 8 Card: 1.0000 Bytes: 0 | |
| Resc: 2.0000 Resc_io: 2.0000 Resc_cpu: 150 | |
| Resp: 2.0000 Resp_io: 2.0000 Resc_cpu: 21 | |
| >> Query Blk Card adjusted from 1.000000 to: 100000.000000 | |
| kkoqbc-subheap (delete addr=0x000000001646DF30, in-use=23784, alloc=32840) | |
| kkoqbc-end: | |
| : | |
| call(in-use=13352, alloc=49288), compile(in-use=83160, alloc=86344), execution(in-use=3888, alloc=4032) | |
| kkoqbc: finish optimizing query block SEL$1 (#0) | |
| Copy query block qb# -1 (<unnamed>) : SELECT /*+ CACHE_TEMP_TABLE(T1) */ "C0", "C1", "C2" FROM "SYS"."SYS_TEMP_0FD9D6AD4_AB10D34" T1 | |
| Registered qb: SEL$D67CB2D2 0x176fd980 (MAP QUERY BLOCK SEL$1) | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (): qb_name=SEL$D67CB2D2 nbfros=1 flg=0 | |
| fro(0): flg=6 objn=0 hint_alias="T1"@"SEL$D67CB2D2" | |
| kkoqbc: optimizing query block SEL$1 (#0) | |
| : | |
| call(in-use=12752, alloc=49288), compile(in-use=93952, alloc=94632), execution(in-use=5600, alloc=8088) | |
| kkoqbc-subheap (create addr=0x000000001646DF30) | |
| **************** | |
| QUERY BLOCK TEXT | |
| **************** | |
| select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5 | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0 | |
| fro(0): flg=0 objn=116 hint_alias="DUAL"@"SEL$1" | |
| ----------------------------- | |
| SYSTEM STATISTICS INFORMATION | |
| ----------------------------- | |
| Using NOWORKLOAD Stats | |
| CPUSPEEDNW: 2903 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: DUAL Alias: DUAL | |
| #Rows: 1 #Blks: 1 AvgRowLen: 2.00 ChainCnt: 0.00 | |
| Access path analysis for DUAL | |
| *************************************** | |
| SINGLE TABLE ACCESS PATH | |
| Single Table Cardinality Estimation for DUAL[DUAL] | |
| Table: DUAL Alias: DUAL | |
| Card: Original: 1.000000 Rounded: 1 Computed: 1.00 Non Adjusted: 1.00 | |
| Access Path: TableScan | |
| Cost: 2.00 Resp: 2.00 Degree: 0 | |
| Cost_io: 2.00 Cost_cpu: 150 | |
| Resp_io: 2.00 Resp_cpu: 21 | |
| Best:: AccessPath: TableScan | |
| Cost: 2.00 Degree: 8 Resp: 2.00 Card: 1.00 Bytes: 0 | |
| *************************************** | |
| OPTIMIZER STATISTICS AND COMPUTATIONS | |
| *************************************** | |
| GENERAL PLANS | |
| *************************************** | |
| Considering cardinality-based initial join order. | |
| Permutations for Starting Table :0 | |
| Join order[1]: DUAL[DUAL]#0 | |
| *********************** | |
| Best so far: Table#: 0 cost: 2.0000 card: 1.0000 bytes: 0 | |
| *********************** | |
| (newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000 | |
| ********************************* | |
| Number of join permutations tried: 1 | |
| ********************************* | |
| Enumerating distribution method (advanced) | |
| Trying or-Expansion on query block SEL$1 (#0) | |
| Transfer Optimizer annotations for query block SEL$1 (#0) | |
| Final cost for query block SEL$1 (#0) - All Rows Plan: | |
| Best join order: 1 | |
| Cost: 2.0000 Degree: 8 Card: 1.0000 Bytes: 0 | |
| Resc: 2.0000 Resc_io: 2.0000 Resc_cpu: 150 | |
| Resp: 2.0000 Resp_io: 2.0000 Resc_cpu: 21 | |
| >> Query Blk Card adjusted from 1.000000 to: 100000.000000 | |
| kkoqbc-subheap (delete addr=0x000000001646DF30, in-use=23784, alloc=32840) | |
| kkoqbc-end: | |
| : | |
| call(in-use=17168, alloc=65656), compile(in-use=94288, alloc=94632), execution(in-use=5600, alloc=8088) | |
| kkoqbc: finish optimizing query block SEL$1 (#0) | |
| kkoqbc: optimizing query block SEL$D67CB2D2 (#0) | |
| : | |
| call(in-use=17168, alloc=65656), compile(in-use=94768, alloc=98776), execution(in-use=5600, alloc=8088) | |
| kkoqbc-subheap (create addr=0x000000001646DF30) | |
| **************** | |
| QUERY BLOCK TEXT | |
| **************** | |
| with v as (select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padd | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (optimizer): qb_name=SEL$D67CB2D2 nbfros=1 flg=0 | |
| fro(0): flg=2 objn=0 hint_alias="T1"@"SEL$D67CB2D2" | |
| ----------------------------- | |
| SYSTEM STATISTICS INFORMATION | |
| ----------------------------- | |
| Using NOWORKLOAD Stats | |
| CPUSPEEDNW: 2903 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: SYS_TEMP_0FD9D6AD4_AB10D34 Alias: T1 | |
| #Rows: 100000 #Blks: 1 AvgRowLen: 0.00 ChainCnt: 0.00 | |
| Access path analysis for SYS_TEMP_0FD9D6AD4_AB10D34 | |
| *************************************** | |
| SINGLE TABLE ACCESS PATH | |
| Single Table Cardinality Estimation for SYS_TEMP_0FD9D6AD4_AB10D34[T1] | |
| Table: SYS_TEMP_0FD9D6AD4_AB10D34 Alias: T1 | |
| Card: Original: 100000.000000 Rounded: 100000 Computed: 100000.00 Non Adjusted: 100000.00 | |
| Access Path: TableScan | |
| Cost: 2.55 Resp: 2.08 Degree: 0 | |
| Cost_io: 2.00 Cost_cpu: 19000000 | |
| Resp_io: 2.00 Resp_cpu: 2638889 | |
| Best:: AccessPath: TableScan | |
| Cost: 2.08 Degree: 8 Resp: 2.08 Card: 100000.00 Bytes: 0 | |
| *************************************** | |
| OPTIMIZER STATISTICS AND COMPUTATIONS | |
| *************************************** | |
| GENERAL PLANS | |
| *************************************** | |
| Considering cardinality-based initial join order. | |
| Permutations for Starting Table :0 | |
| Join order[1]: SYS_TEMP_0FD9D6AD4_AB10D34[T1]#0 | |
| *********************** | |
| Best so far: Table#: 0 cost: 2.0758 card: 100000.0000 bytes: 51800000 | |
| *********************** | |
| (newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000 | |
| ********************************* | |
| Number of join permutations tried: 1 | |
| ********************************* | |
| Enumerating distribution method (advanced) | |
| Trying or-Expansion on query block SEL$D67CB2D2 (#0) | |
| Transfer Optimizer annotations for query block SEL$D67CB2D2 (#0) | |
| Final cost for query block SEL$D67CB2D2 (#0) - All Rows Plan: | |
| Best join order: 1 | |
| Cost: 2.0758 Degree: 8 Card: 100000.0000 Bytes: 51800000 | |
| Resc: 2.5455 Resc_io: 2.0000 Resc_cpu: 19000000 | |
| Resp: 2.0758 Resp_io: 2.0000 Resc_cpu: 2638889 | |
| kkoqbc-subheap (delete addr=0x000000001646DF30, in-use=23784, alloc=32840) | |
| kkoqbc-end: | |
| : | |
| call(in-use=22408, alloc=65656), compile(in-use=97728, alloc=98776), execution(in-use=5600, alloc=8088) | |
| kkoqbc: finish optimizing query block SEL$D67CB2D2 (#0) | |
| kkoqbc: optimizing query block SEL$2 (#0) | |
| : | |
| call(in-use=22408, alloc=65656), compile(in-use=97728, alloc=98776), execution(in-use=5600, alloc=8088) | |
| kkoqbc-subheap (create addr=0x000000001646DF30) | |
| **************** | |
| QUERY BLOCK TEXT | |
| **************** | |
| with v as (select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5) | |
| select/*+ parallel(v 8) dynalic_sampling(v 10) */ distinct userenv('sid') | |
| from v | |
| --------------------- | |
| QUERY BLOCK SIGNATURE | |
| --------------------- | |
| signature (optimizer): qb_name=SEL$2 nbfros=1 flg=0 | |
| fro(0): flg=1 objn=0 hint_alias="V"@"SEL$2" | |
| ----------------------------- | |
| SYSTEM STATISTICS INFORMATION | |
| ----------------------------- | |
| Using NOWORKLOAD Stats | |
| CPUSPEEDNW: 2903 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: V Alias: V (NOT ANALYZED) | |
| #Rows: 0 #Blks: 0 AvgRowLen: 0.00 ChainCnt: 0.00 | |
| Access path analysis for V | |
| *************************************** | |
| OPTIMIZER STATISTICS AND COMPUTATIONS | |
| *************************************** | |
| GENERAL PLANS | |
| *************************************** | |
| Considering cardinality-based initial join order. | |
| Permutations for Starting Table :0 | |
| Join order[1]: V[V]#0 | |
| *********************** | |
| Best so far: Table#: 0 cost: 2.0758 card: 100000.0000 bytes: 0 | |
| *********************** | |
| (newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000 | |
| ********************************* | |
| Number of join permutations tried: 1 | |
| ********************************* | |
| Enumerating distribution method (advanced) | |
| Trying or-Expansion on query block SEL$2 (#0) | |
| SORT ressource Sort statistics | |
| Sort width: 598 Area size: 603136 Max Area size: 104857600 | |
| Degree: 1 | |
| Blocks to Sort: 123 Row size: 10 Total Rows: 100000 | |
| Initial runs: 2 Merge passes: 1 IO Cost / pass: 68 | |
| Total IO sort cost: 191 Total CPU sort cost: 112693988 | |
| Total Temp space used: 410000 | |
| SORT response Sort statistics | |
| Sort width: 214 Area size: 7549747 Max Area size: 37748736 | |
| Degree: 8 | |
| Blocks to Sort: 16 Row size: 10 Total Rows: 12500 | |
| Initial runs: 1 Merge passes: 0 IO Cost / pass: 0 | |
| Total IO sort cost: 0 Total CPU sort cost: 47217422 | |
| Total Temp space used: 0 | |
| Transfer Optimizer annotations for query block SEL$2 (#0) | |
| Final cost for query block SEL$2 (#0) - All Rows Plan: | |
| Best join order: 1 | |
| Cost: 5.4314 Degree: 8 Card: 100000.0000 Bytes: 0 | |
| Resc: 198.7809 Resc_io: 195.0000 Resc_cpu: 131694138 | |
| Resp: 5.4314 Resp_io: 4.0000 Resc_cpu: 49856332 | |
| kkoqbc-subheap (delete addr=0x000000001646DF30, in-use=23784, alloc=32840) | |
| kkoqbc-end: | |
| : | |
| call(in-use=26824, alloc=65656), compile(in-use=98056, alloc=98776), execution(in-use=5736, alloc=8088) | |
| kkoqbc: finish optimizing query block SEL$2 (#0) | |
| apadrv-end | |
| : | |
| call(in-use=26824, alloc=65656), compile(in-use=99848, alloc=102920), execution(in-use=5736, alloc=8088) | |
| Starting SQL statement dump | |
| user_id=90 user_name=XTENDER module=SQL*Plus action= | |
| sql_id=dcg7nggm1n96h plan_hash_value=-615445763 problem_type=3 | |
| ----- Current SQL Statement for this session (sql_id=dcg7nggm1n96h) ----- | |
| with v as (select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5) | |
| select/*+ parallel(v 8) dynalic_sampling(v 10) */ distinct userenv('sid') | |
| from v | |
| sql_text_length=229 | |
| sql=with v as (select/*+ materialize cardinality(100000) */ '1' x,rownum rn, rpad('x',1000,'x') padding from dual where rownum>0 connect by level<=3e5) | |
| select/*+ parallel(v 8) dynalic_sampling(v 10) */ distinct userenv('sid') | |
| from v | |
| ----- Explain Plan Dump ----- | |
| ----- Plan Table ----- | |
| ============ | |
| Plan Table | |
| ============ | |
| ----------------------------------------------------------------------+-----------------------------------+-------------------------+ | |
| | Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib | | |
| ----------------------------------------------------------------------+-----------------------------------+-------------------------+ | |
| | 0 | SELECT STATEMENT | | | | 5 | | | | | | |
| | 1 | TEMP TABLE TRANSFORMATION | | | | | | | | | | |
| | 2 | LOAD AS SELECT | | | | | | | | | | |
| | 3 | COUNT | | | | | | | | | | |
| | 4 | FILTER | | | | | | | | | | |
| | 5 | CONNECT BY WITHOUT FILTERING | | | | | | | | | | |
| | 6 | FAST DUAL | | 1 | | 2 | 00:00:01 | | | | | |
| | 7 | PX COORDINATOR | | | | | | | | | | |
| | 8 | PX SEND QC (RANDOM) | :TQ10001 | 98K | | 3 | 00:00:01 |:Q1001| P->S |QC (RANDOM)| | |
| | 9 | HASH UNIQUE | | 98K | | 3 | 00:00:01 |:Q1001| PCWP | | | |
| | 10 | PX RECEIVE | | 98K | | 3 | 00:00:01 |:Q1001| PCWP | | | |
| | 11 | PX SEND HASH | :TQ10000 | 98K | | 3 | 00:00:01 |:Q1000| P->P |HASH | | |
| | 12 | HASH UNIQUE | | 98K | | 3 | 00:00:01 |:Q1000| PCWP | | | |
| | 13 | VIEW | | 98K | | 2 | 00:00:01 |:Q1000| PCWP | | | |
| | 14 | PX BLOCK ITERATOR | | 98K | 49M | 2 | 00:00:01 |:Q1000| PCWC | | | |
| | 15 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6AD4_AB10D34| 98K | 49M | 2 | 00:00:01 |:Q1000| PCWP | | | |
| ----------------------------------------------------------------------+-----------------------------------+-------------------------+ | |
| Predicate Information: | |
| ---------------------- | |
| 4 - filter(ROWNUM>0) | |
| 15 - access(:Z>=:Z AND :Z<=:Z) | |
| Content of other_xml column | |
| =========================== | |
| db_version : 11.2.0.4 | |
| parse_schema : XTENDER | |
| plan_hash : 3679521533 | |
| plan_hash_2 : 925173277 | |
| External Opns | |
| ============== | |
| ID: 0, #Ext Opns: 11 | |
| [ 1] USERENV('SID') | |
| Outline Data: | |
| /*+ | |
| BEGIN_OUTLINE_DATA | |
| IGNORE_OPTIM_EMBEDDED_HINTS | |
| OPTIMIZER_FEATURES_ENABLE('11.2.0.4') | |
| DB_VERSION('11.2.0.4') | |
| ALL_ROWS | |
| OUTLINE_LEAF(@"SEL$1") | |
| OUTLINE_LEAF(@"SEL$D67CB2D2") | |
| OUTLINE_LEAF(@"SEL$2") | |
| OUTLINE(@"SEL$1") | |
| NO_ACCESS(@"SEL$2" "V"@"SEL$2") | |
| GBY_PUSHDOWN(@"SEL$2") | |
| USE_HASH_AGGREGATION(@"SEL$2") | |
| FULL(@"SEL$D67CB2D2" "T1"@"SEL$D67CB2D2") | |
| NO_CONNECT_BY_FILTERING(@"SEL$1") | |
| CONNECT_BY_COMBINE_SW(@"SEL$1") | |
| 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 = 8 | |
| parallel_dml_forced_dop = 0 | |
| parallel_ddl_forced_degree = 0 | |
| parallel_ddl_forced_instances = 0 | |
| _query_rewrite_fudge = 90 | |
| optimizer_features_enable = 11.2.0.4 | |
| _optimizer_search_limit = 5 | |
| cpu_count = 4 | |
| active_instance_count = 1 | |
| parallel_threads_per_cpu = 2 | |
| 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 = 589824 KB | |
| _pga_max_size = 204800 KB | |
| _query_rewrite_maxdisjunct = 257 | |
| _smm_auto_min_io_size = 56 KB | |
| _smm_auto_max_io_size = 248 KB | |
| _smm_min_size = 589 KB | |
| _smm_max_size_static = 102400 KB | |
| _smm_px_max_size_static = 294912 KB | |
| _cpu_to_io = 0 | |
| _optimizer_undo_cost_change = 11.2.0.4 | |
| parallel_query_mode = forced | |
| parallel_dml_mode = disabled | |
| parallel_ddl_mode = enabled | |
| optimizer_mode = all_rows | |
| sqlstat_enabled = false | |
| _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 = true | |
| _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 = typical | |
| _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 = 80 | |
| _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 = 8 | |
| 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 = 8 | |
| 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_pushdown_to_storage = true | |
| _bloom_vector_elements = 0 | |
| _bloom_pushing_max = 512 | |
| parallel_degree_limit = 32 | |
| parallel_force_local = false | |
| parallel_max_degree = 8 | |
| total_cpu_count = 4 | |
| _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 | |
| deferred_segment_creation = true | |
| _optimizer_filter_pushdown = true | |
| _allow_level_without_connect_by = false | |
| _max_rwgs_groupings = 8192 | |
| _optimizer_outer_join_to_inner = true | |
| _optimizer_full_outer_join_to_outer = true | |
| _px_numa_support_enabled = true | |
| total_processor_group_count = 1 | |
| _bloom_sm_enabled = false | |
| _bloom_serial_filter = on | |
| _parallel_degree_level = 100 | |
| _optimizer_ads_max_table_count = 0 | |
| _optimizer_ads_time_limit = 0 | |
| _optimizer_ads_use_result_cache = true | |
| parallel_dblink = 0 | |
| _optimizer_cluster_by_rowid = false | |
| _optimizer_cluster_by_rowid_control = 3 | |
| 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 8508056 = enabled | |
| fix 8335178 = enabled | |
| fix 8515269 = 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 8571403 = 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 9301862 = disabled | |
| 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 9912503 = enabled | |
| fix 9153459 = enabled | |
| fix 9762592 = 3 | |
| fix 9785632 = enabled | |
| fix 9659125 = 0 | |
| fix 9702850 = enabled | |
| fix 9958518 = enabled | |
| fix 8349119 = enabled | |
| fix 10041074 = enabled | |
| fix 10134677 = enabled | |
| fix 9716877 = enabled | |
| fix 8961143 = enabled | |
| fix 10080014 = enabled | |
| fix 10026972 = enabled | |
| fix 9476520 = enabled | |
| fix 9841679 = enabled | |
| fix 10004943 = enabled | |
| fix 9791810 = enabled | |
| fix 9668086 = enabled | |
| fix 9850461 = enabled | |
| fix 9940732 = enabled | |
| fix 9578670 = enabled | |
| fix 10197666 = enabled | |
| fix 9630092 = disabled | |
| fix 10271790 = enabled | |
| fix 10015652 = enabled | |
| fix 8274946 = enabled | |
| fix 10192889 = enabled | |
| fix 10336499 = disabled | |
| fix 9814067 = enabled | |
| fix 10158107 = enabled | |
| fix 10182051 = 3 | |
| fix 10376744 = enabled | |
| fix 10043801 = enabled | |
| fix 9832338 = disabled | |
| fix 9002661 = enabled | |
| fix 9898066 = enabled | |
| fix 9569678 = enabled | |
| fix 11741436 = enabled | |
| fix 10232623 = enabled | |
| fix 10232225 = enabled | |
| fix 9829887 = enabled | |
| fix 10359631 = enabled | |
| fix 8275054 = enabled | |
| fix 10640430 = enabled | |
| fix 10227392 = enabled | |
| fix 10117760 = enabled | |
| fix 9554026 = disabled | |
| fix 9593547 = disabled | |
| fix 9833381 = disabled | |
| fix 9881812 = enabled | |
| fix 10333395 = enabled | |
| fix 9776736 = enabled | |
| fix 9748015 = enabled | |
| fix 11744086 = enabled | |
| fix 11834739 = enabled | |
| fix 11830663 = enabled | |
| fix 11877160 = enabled | |
| fix 9227576 = enabled | |
| fix 11814428 = enabled | |
| fix 11843512 = enabled | |
| fix 11853331 = enabled | |
| fix 6055658 = enabled | |
| fix 11657468 = enabled | |
| fix 11720178 = enabled | |
| fix 10428278 = enabled | |
| fix 8275023 = enabled | |
| fix 11740670 = enabled | |
| fix 9477688 = enabled | |
| fix 9980661 = enabled | |
| fix 11676888 = disabled | |
| fix 10623119 = enabled | |
| fix 10162430 = enabled | |
| fix 10330090 = enabled | |
| fix 9680430 = enabled | |
| fix 10101489 = enabled | |
| fix 12315002 = enabled | |
| fix 12352373 = enabled | |
| fix 10428450 = enabled | |
| fix 11892888 = enabled | |
| fix 10226906 = enabled | |
| fix 10230017 = enabled | |
| fix 11668189 = enabled | |
| fix 11814265 = enabled | |
| fix 11935589 = enabled | |
| fix 10148457 = enabled | |
| fix 10038373 = enabled | |
| fix 11699884 = enabled | |
| fix 10348427 = enabled | |
| fix 11738631 = enabled | |
| fix 12410972 = enabled | |
| fix 11881047 = enabled | |
| fix 10298302 = enabled | |
| fix 12399886 = enabled | |
| fix 7147087 = enabled | |
| fix 11846314 = enabled | |
| fix 12432426 = enabled | |
| fix 12584007 = enabled | |
| fix 8683604 = enabled | |
| fix 12432089 = enabled | |
| fix 12591120 = enabled | |
| fix 11876260 = enabled | |
| fix 9913117 = enabled | |
| fix 12348584 = enabled | |
| fix 10420220 = enabled | |
| fix 3639130 = enabled | |
| fix 12827166 = enabled | |
| fix 12559453 = enabled | |
| fix 12723414 = enabled | |
| fix 12739252 = enabled | |
| fix 12975771 = enabled | |
| fix 12864791 = enabled | |
| fix 13398214 = enabled | |
| fix 12882092 = enabled | |
| fix 11072246 = enabled | |
| fix 13075297 = enabled | |
| fix 11657903 = disabled | |
| fix 12605402 = enabled | |
| fix 13040171 = enabled | |
| fix 12915337 = enabled | |
| fix 11813257 = enabled | |
| fix 12999577 = enabled | |
| fix 13594712 = enabled | |
| fix 13406619 = enabled | |
| fix 10013899 = enabled | |
| fix 6923730 = 0 | |
| fix 13634700 = enabled | |
| fix 12828479 = enabled | |
| fix 11689541 = enabled | |
| fix 9547706 = enabled | |
| fix 13396096 = enabled | |
| fix 13146487 = enabled | |
| fix 13543207 = enabled | |
| fix 13972896 = enabled | |
| fix 13430622 = enabled | |
| fix 12673320 = enabled | |
| fix 13070532 = enabled | |
| fix 13704562 = enabled | |
| fix 12313574 = enabled | |
| fix 12727549 = enabled | |
| fix 12569713 = enabled | |
| fix 13592248 = enabled | |
| fix 12433153 = enabled | |
| fix 2273284 = enabled | |
| fix 13454409 = enabled | |
| fix 12728203 = enabled | |
| fix 13065064 = enabled | |
| fix 13616573 = enabled | |
| fix 11858963 = enabled | |
| fix 13929275 = enabled | |
| fix 8792821 = enabled | |
| fix 13831671 = enabled | |
| fix 13850256 = enabled | |
| fix 13906168 = enabled | |
| fix 13583722 = enabled | |
| fix 13076238 = enabled | |
| fix 14013502 = enabled | |
| fix 13912192 = enabled | |
| fix 14029891 = enabled | |
| fix 10181153 = enabled | |
| fix 13973691 = enabled | |
| fix 12622441 = enabled | |
| fix 9891396 = enabled | |
| fix 13321547 = enabled | |
| fix 13486825 = enabled | |
| fix 7271518 = enabled | |
| fix 12944193 = enabled | |
| fix 13020272 = enabled | |
| fix 12341619 = enabled | |
| fix 14254795 = enabled | |
| fix 13350470 = enabled | |
| fix 12379334 = enabled | |
| fix 12591379 = enabled | |
| fix 12839247 = enabled | |
| fix 4215125 = enabled | |
| fix 13936229 = enabled | |
| fix 13777823 = enabled | |
| fix 13886606 = disabled | |
| fix 13786127 = enabled | |
| fix 13549808 = enabled | |
| fix 13961105 = enabled | |
| fix 14255600 = disabled | |
| fix 13527374 = enabled | |
| fix 13814866 = enabled | |
| fix 14254052 = enabled | |
| fix 13329748 = enabled | |
| fix 14127824 = enabled | |
| fix 14012261 = enabled | |
| fix 3566843 = enabled | |
| fix 9550277 = disabled | |
| fix 6873091 = enabled | |
| fix 14467202 = enabled | |
| fix 14541122 = enabled | |
| fix 14098180 = enabled | |
| fix 14243782 = enabled | |
| fix 13255388 = 10 | |
| fix 11727871 = enabled | |
| fix 9633142 = disabled | |
| fix 12869367 = enabled | |
| fix 14055128 = enabled | |
| fix 13652216 = enabled | |
| fix 13849486 = enabled | |
| fix 14008590 = enabled | |
| fix 13594757 = enabled | |
| fix 9114915 = enabled | |
| fix 14668404 = disabled | |
| fix 14295250 = 45000 | |
| fix 14221012 = enabled | |
| fix 12812697 = enabled | |
| fix 14456124 = enabled | |
| fix 14595273 = disabled | |
| fix 14545269 = enabled | |
| fix 14703133 = enabled | |
| fix 11894476 = enabled | |
| fix 13393357 = enabled | |
| fix 12534597 = enabled | |
| fix 13489017 = enabled | |
| fix 12335617 = enabled | |
| fix 9094254 = enabled | |
| fix 13104618 = enabled | |
| fix 12942119 = enabled | |
| fix 14256885 = enabled | |
| fix 13943459 = enabled | |
| fix 13263174 = enabled | |
| fix 14311185 = enabled | |
| fix 14795969 = enabled | |
| fix 9971371 = disabled | |
| fix 13843964 = enabled | |
| fix 13853916 = enabled | |
| fix 14755138 = enabled | |
| fix 15996520 = enabled | |
| fix 14147762 = enabled | |
| fix 13263455 = enabled | |
| fix 14750501 = enabled | |
| fix 13497184 = enabled | |
| fix 14707009 = enabled | |
| fix 14684079 = enabled | |
| fix 14669785 = enabled | |
| fix 11905801 = enabled | |
| fix 14142884 = disabled | |
| fix 13711083 = enabled | |
| fix 16053273 = disabled | |
| fix 14346182 = enabled | |
| fix 13627489 = disabled | |
| fix 13891981 = enabled | |
| fix 14320077 = enabled | |
| fix 13083139 = enabled | |
| fix 6520878 = enabled | |
| fix 13362020 = enabled | |
| fix 13799389 = enabled | |
| fix 14170552 = enabled | |
| fix 14144611 = enabled | |
| fix 13499154 = enabled | |
| fix 13382280 = enabled | |
| fix 12557401 = enabled | |
| fix 12861609 = enabled | |
| fix 12555499 = enabled | |
| fix 14723910 = enabled | |
| fix 12693573 = enabled | |
| fix 13524237 = enabled | |
| fix 9858777 = enabled | |
| fix 13568366 = enabled | |
| fix 14242833 = enabled | |
| fix 14133928 = enabled | |
| fix 16220895 = enabled | |
| fix 13826669 = enabled | |
| fix 14176247 = enabled | |
| fix 13361493 = enabled | |
| fix 16264537 = enabled | |
| fix 11865196 = enabled | |
| fix 13905599 = disabled | |
| fix 14712222 = enabled | |
| fix 15998585 = enabled | |
| fix 13526551 = enabled | |
| fix 14107333 = enabled | |
| fix 15882436 = enabled | |
| fix 16273483 = enabled | |
| fix 13682550 = enabled | |
| fix 15889476 = disabled | |
| fix 16202455 = disabled | |
| fix 16226660 = enabled | |
| fix 16093509 = 0 | |
| fix 16092378 = enabled | |
| fix 16487030 = enabled | |
| fix 16419357 = enabled | |
| fix 16690013 = enabled | |
| fix 15996156 = enabled | |
| fix 12914055 = disabled | |
| fix 16792882 = 0 | |
| fix 16726844 = enabled | |
| fix 14682092 = enabled | |
| fix 16799181 = enabled | |
| fix 16582322 = enabled | |
| fix 16712213 = enabled | |
| fix 16516883 = enabled | |
| fix 16725982 = enabled | |
| fix 13253977 = enabled | |
| fix 16554552 = enabled | |
| Query Block Registry: | |
| SEL$2 0x176d5f78 (PARSER) [FINAL] | |
| SEL$1 0x176d7d78 (PARSER) [FINAL] | |
| SEL$D67CB2D2 0x176fd980 (MAP QUERY BLOCK SEL$1) [FINAL] | |
| : | |
| call(in-use=49520, alloc=82024), compile(in-use=159824, alloc=223912), execution(in-use=21656, alloc=24312) | |
| End of Optimizer State Dump | |
| Dumping Hints | |
| ============= | |
| atom_hint=(@=00000000176FFF50 err=0 resol=1 used=1 token=177 org=1 lvl=3 txt=PARALLEL ("V",8) ) | |
| atom_hint=(@=00000000176FD668 err=0 resol=1 used=0 token=819 org=1 lvl=3 txt=CACHE_TEMP_TABLE ("T1") ) | |
| atom_hint=(@=00000000176FE8C0 err=0 resol=1 used=1 token=1018 org=1 lvl=2 txt=OPT_ESTIMATE (QUERY_BLOCK ROWS=100000.000000 ) ) | |
| atom_hint=(@=00000000176FE960 err=0 resol=1 used=1 token=855 org=1 lvl=2 txt=MATERIALIZE ()) | |
| atom_hint=(@=00000000176FE6F8 err=0 resol=1 used=0 token=177 org=1 lvl=3 txt=PARALLEL ("DUAL",8) ) | |
| ====================== END SQL Statement Dump ====================== |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment