Skip to content

Instantly share code, notes, and snippets.

@xtender

xtender/additional rows and histograms

Created June 6, 2015 20:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save xtender/a6b82498b1f3e95effc6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save xtender/a6b82498b1f3e95effc6 to your computer and use it in GitHub Desktop.
Download ZIP
serial_to_parallel_2_1
Raw
additional rows and histograms
insert into z_line_items select * from z_line_items;
insert into z_line_items select * from z_line_items;
begin
dbms_stats.gather_table_stats(
user
, 'Z_LINE_ITEMS'
, estimate_percent => 100
, method_opt => 'for all columns size 1 for columns size 254 item_id'
, no_invalidate => false
);
end;
/
Raw
rtsm report
SQL> @rtsm/sqlid bpzdbc8pdm2yj
SQLMON
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Monitoring Report
SQL Text
------------------------------
with v as( select--+ materialize index(li (item_id)) rowid rid from z_line_items li where li.item_id = 42 ) select--+ leading(v li o) use_nl(li) use_nl(o) parallel(v 4) gather_plan_statistics sum(li.price) from v , z_line_items li , z_orders o where li.rowid = v.rid and o.id = li.order_id and o.orde
r_type != 0
Global Information
------------------------------
Status : DONE (ALL ROWS)
Instance ID : 1
Session : XTENDER (69:1941)
SQL ID : bpzdbc8pdm2yj
SQL Execution ID : 16777216
Execution Started : 06/06/2015 23:21:20
First Refresh Time : 06/06/2015 23:21:21
Last Refresh Time : 06/06/2015 23:21:27
Duration : 7s
Module/Action : SQL*Plus/-
Service : baikal
Program : sqlplus.exe
Fetch Calls : 1
Global Stats
==========================================================================================================
| Elapsed | Cpu | IO | Application | Other | Fetch | Buffer | Read | Read | Write | Write |
| Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Reqs | Bytes |
==========================================================================================================
| 13 | 5.05 | 7.95 | 0.00 | 0.04 | 1 | 805K | 10620 | 90MB | 28 | 7MB |
==========================================================================================================
Parallel Execution Details (DOP=2 , Servers Allocated=2)
==================================================================================================================================================================
| Name | Type | Server# | Elapsed | Cpu | IO | Application | Other | Buffer | Read | Read | Write | Write | Wait Events |
| | | | Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes | (sample #) |
==================================================================================================================================================================
| PX Coordinator | QC | | 0.26 | 0.22 | 0.00 | 0.00 | 0.04 | 1920 | | . | 28 | 7MB | |
| p000 | Set 1 | 1 | 6.34 | 2.37 | 3.97 | | | 399K | 5291 | 45MB | | . | db file sequential read (4) |
| p001 | Set 1 | 2 | 6.44 | 2.46 | 3.98 | | | 405K | 5329 | 45MB | | . | db file sequential read (4) |
==================================================================================================================================================================
SQL Plan Monitoring Details (Plan Hash Value=3548249137)
=====================================================================================================================================================================================================
| Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Mem | Activity | Activity Detail |
| | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (Max) | (%) | (# samples) |
=====================================================================================================================================================================================================
| 0 | SELECT STATEMENT | | | | 1 | +7 | 1 | 1 | | | | | |
| 1 | TEMP TABLE TRANSFORMATION | | | | 1 | +7 | 1 | 1 | | | | | |
| 2 | LOAD AS SELECT | | | | 2 | +0 | 1 | 1 | | | 536K | 7.69 | Cpu (1) |
| 3 | INDEX RANGE SCAN | ITEM_ID__Z_LINE_ITEMS | 394K | 889 | 1 | +1 | 1 | 396K | | | | | |
| 4 | SORT AGGREGATE | | 1 | | 1 | +7 | 1 | 1 | | | | | |
| 5 | PX COORDINATOR | | | | 1 | +7 | 3 | 2 | | | | | |
| 6 | PX SEND QC (RANDOM) | :TQ10000 | 1 | | 1 | +7 | 2 | 2 | | | | | |
| 7 | SORT AGGREGATE | | 1 | | 5 | +3 | 2 | 2 | | | | | |
| 8 | NESTED LOOPS | | 358K | 109K | 5 | +3 | 2 | 361K | | | | | |
| 9 | NESTED LOOPS | | 394K | 109K | 5 | +3 | 2 | 396K | | | | 7.69 | Cpu (1) |
| 10 | NESTED LOOPS | | 394K | 54721 | 5 | +3 | 2 | 396K | | | | | |
| 11 | VIEW | | 394K | 29 | 5 | +3 | 2 | 396K | | | | | |
| 12 | PX BLOCK ITERATOR | | 394K | 29 | 5 | +3 | 2 | 396K | | | | | |
| 13 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6ACA_AB10D34 | 394K | 29 | 5 | +3 | 26 | 396K | 32 | 7MB | | 7.69 | Cpu (1) |
| 14 | TABLE ACCESS BY USER ROWID | Z_LINE_ITEMS | 1 | 1 | 7 | +1 | 396K | 396K | 10201 | 80MB | | 61.54 | db file sequential read (8) |
| 15 | INDEX UNIQUE SCAN | ID__Z_ORDERS | 1 | | 5 | +3 | 396K | 396K | 209 | 2MB | | | |
| 16 | TABLE ACCESS BY INDEX ROWID | Z_ORDERS | 1 | | 5 | +3 | 396K | 361K | 178 | 1MB | | 15.38 | Cpu (2) |
=====================================================================================================================================================================================================
Raw
test query
alter session force parallel query parallel 8;
with v as(
select--+ materialize index(li (item_id))
rowid rid
from z_line_items li
where li.item_id = 42
)
select--+ leading(v li o) use_nl(li) use_nl(o) parallel(v 4) gather_plan_statistics
sum(li.price)
from v
, z_line_items li
, z_orders o
where li.rowid = v.rid
and o.id = li.order_id
and o.order_type != 0;
Raw
trace_10053
Trace file N:\ORACLE\diag\rdbms\baikal\baikal\trace\baikal_ora_14232_parallel8.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:556M/4094M, Ph+PgF:3531M/11427M
Instance name: baikal
Redo thread mounted by this instance: 1
Oracle process number: 29
Windows thread id: 14232, image: ORACLE.EXE (SHAD)
*** 2015-06-06 23:21:20.700
*** SESSION ID:(69.1941) 2015-06-06 23:21:20.700
*** CLIENT ID:() 2015-06-06 23:21:20.700
*** SERVICE NAME:(baikal) 2015-06-06 23:21:20.700
*** MODULE NAME:(SQL*Plus) 2015-06-06 23:21:20.700
*** ACTION NAME:() 2015-06-06 23:21:20.700
Registered qb: SEL$1 0x16362528 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$1 nbfros=1 flg=0
fro(0): flg=4 objn=97733 hint_alias="LI"@"SEL$1"
Registered qb: SEL$2 0x16360eb8 (PARSER)
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (): qb_name=SEL$2 nbfros=3 flg=0
fro(0): flg=4 objn=97733 hint_alias="LI"@"SEL$2"
fro(1): flg=4 objn=97731 hint_alias="O"@"SEL$2"
fro(2): 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=bpzdbc8pdm2yj) -----
with v as(
select--+ materialize index(li (item_id))
rowid rid
from z_line_items li
where li.item_id = 42
)
select--+ leading(v li o) use_nl(li) use_nl(o) parallel(v 4) gather_plan_statistics
sum(li.price)
from v
, z_line_items li
, z_orders o
where li.rowid = v.rid
and o.id = li.order_id
and o.order_type != 0
*******************************************
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 bpzdbc8pdm2yj.
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.
JE: Considering Join Elimination on query block SEL$2 (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT /*+ LEADING ("V" "LI" "O") USE_NL ("O") USE_NL ("LI") PARALLEL ("V",4) */ SUM("LI"."PRICE") "SUM(LI.PRICE)" FROM (SELECT /*+ INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") */ "LI".ROWID "RID" FROM "XTENDER"."Z_LINE_ITEMS" "LI" WHERE "LI"."ITEM_ID"=42) "V","XTENDER"."Z_LINE_ITEMS" "LI","XTENDER"."Z_ORDERS" "O" WHERE "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
SQL:******* UNPARSED QUERY IS *******
SELECT /*+ LEADING ("V" "LI" "O") USE_NL ("O") USE_NL ("LI") PARALLEL ("V",4) */ SUM("LI"."PRICE") "SUM(LI.PRICE)" FROM (SELECT /*+ INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") */ "LI".ROWID "RID" FROM "XTENDER"."Z_LINE_ITEMS" "LI" WHERE "LI"."ITEM_ID"=42) "V","XTENDER"."Z_LINE_ITEMS" "LI","XTENDER"."Z_ORDERS" "O" WHERE "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
Query block SEL$2 (#0) unchanged
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)
CNT: Considering count(col) to count(*) on query block SEL$2 (#0)
*************************
Count(col) to Count(*) (CNT)
*************************
CNT: COUNT() to COUNT(*) not done.
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.
JE: Considering Join Elimination on query block SEL$2 (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT /*+ LEADING ("V" "LI" "O") USE_NL ("O") USE_NL ("LI") PARALLEL ("V",4) */ SUM("LI"."PRICE") "SUM(LI.PRICE)" FROM (SELECT /*+ PARALLEL ("LI",4) INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") */ "LI".ROWID "RID" FROM "XTENDER"."Z_LINE_ITEMS" "LI" WHERE "LI"."ITEM_ID"=42) "V","XTENDER"."Z_LINE_ITEMS" "LI","XTENDER"."Z_ORDERS" "O" WHERE "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
SQL:******* UNPARSED QUERY IS *******
SELECT /*+ LEADING ("V" "LI" "O") USE_NL ("O") USE_NL ("LI") PARALLEL ("V",4) */ SUM("LI"."PRICE") "SUM(LI.PRICE)" FROM (SELECT /*+ PARALLEL ("LI",4) INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") */ "LI".ROWID "RID" FROM "XTENDER"."Z_LINE_ITEMS" "LI" WHERE "LI"."ITEM_ID"=42) "V","XTENDER"."Z_LINE_ITEMS" "LI","XTENDER"."Z_ORDERS" "O" WHERE "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
Query block SEL$2 (#0) unchanged
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 bpzdbc8pdm2yj.
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
JE: Considering Join Elimination on query block SEL$2 (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT /*+ LEADING ("V" "LI" "O") USE_NL ("O") USE_NL ("LI") PARALLEL ("V",4) */ SUM("LI"."PRICE") "SUM(LI.PRICE)" FROM (SELECT /*+ PARALLEL ("LI",4) INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") */ "LI".ROWID "RID" FROM "XTENDER"."Z_LINE_ITEMS" "LI" WHERE "LI"."ITEM_ID"=42) "V","XTENDER"."Z_LINE_ITEMS" "LI","XTENDER"."Z_ORDERS" "O" WHERE "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
EQUIV: equivalence check not possible on QB SEL$1 (#0) because materialized query block
EQUIV: equivalence check not possible SEL$2 (#2) because view not okay
SQL:******* UNPARSED QUERY IS *******
SELECT /*+ LEADING ("V" "LI" "O") USE_NL ("O") USE_NL ("LI") PARALLEL ("V",4) */ SUM("LI"."PRICE") "SUM(LI.PRICE)" FROM (SELECT /*+ PARALLEL ("LI",4) INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") */ "LI".ROWID "RID" FROM "XTENDER"."Z_LINE_ITEMS" "LI" WHERE "LI"."ITEM_ID"=42) "V","XTENDER"."Z_LINE_ITEMS" "LI","XTENDER"."Z_ORDERS" "O" WHERE "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
Query block SEL$2 (#0) unchanged
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)
"LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
FPD: Considering simple filter push in query block SEL$1 (#0)
"LI"."ITEM_ID"=42
try to generate transitive predicate from check constraints for query block SEL$1 (#0)
finally: "LI"."ITEM_ID"=42
try to generate transitive predicate from check constraints for query block SEL$2 (#0)
finally: "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
apadrv-start sqlid=13474114098276436945
:
call(in-use=3936, alloc=16344), compile(in-use=75720, alloc=79360), execution(in-use=5744, alloc=8088)
*******************************************
Peeked values of the binds in SQL statement
*******************************************
Final query after transformations:******* UNPARSED QUERY IS *******
SELECT /*+ LEADING ("V" "LI" "O") USE_NL ("O") USE_NL ("LI") PARALLEL ("V",4) */ SUM("LI"."PRICE") "SUM(LI.PRICE)" FROM (SELECT /*+ PARALLEL ("LI",4) INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") */ "LI".ROWID "RID" FROM "XTENDER"."Z_LINE_ITEMS" "LI" WHERE "LI"."ITEM_ID"=42) "V","XTENDER"."Z_LINE_ITEMS" "LI","XTENDER"."Z_ORDERS" "O" WHERE "LI".ROWID="V"."RID" AND "O"."ID"="LI"."ORDER_ID" AND "O"."ORDER_TYPE"<>0
kkoqbc: optimizing query block SEL$1 (#0)
:
call(in-use=4152, alloc=16344), compile(in-use=82784, alloc=83504), execution(in-use=5824, alloc=8088)
kkoqbc-subheap (create addr=0x000000001636FA10)
****************
QUERY BLOCK TEXT
****************
select--+ materialize index(li (item_id))
rowid rid
from z_line_items li
where li.item_id = 42
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0
fro(0): flg=0 objn=97733 hint_alias="LI"@"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: Z_LINE_ITEMS Alias: LI
#Rows: 4000000 #Blks: 11167 AvgRowLen: 14.00 ChainCnt: 0.00
Index Stats::
Index: ITEM_ID__Z_LINE_ITEMS Col#: 2
LVLS: 2 #LB: 8988 #DK: 99989 LB/K: 1.00 DB/K: 36.00 CLUF: 3607827.00
User hint to use this index
Access path analysis for Z_LINE_ITEMS
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for Z_LINE_ITEMS[LI]
Column (#2):
NewDensity:0.000009, OldDensity:0.000010 BktCnt:254, PopBktCnt:25, PopValCnt:1, NDV:99989
Column (#2): ITEM_ID(
AvgLen: 5 NDV: 99989 Nulls: 0 Density: 0.000009 Min: 0 Max: 100000
Histogram: HtBal #Bkts: 254 UncompBkts: 254 EndPtVals: 231
Table: Z_LINE_ITEMS Alias: LI
Card: Original: 4000000.000000 Rounded: 393701 Computed: 393700.79 Non Adjusted: 393700.79
Access Path: index (AllEqRange)
Index: ITEM_ID__Z_LINE_ITEMS
resc_io: 887.00 resc_cpu: 85056917
ix_sel: 0.098425 ix_sel_with_filters: 0.098425
Cost: 889.44 Resp: 889.44 Degree: 1
Best:: AccessPath: IndexRange
Index: ITEM_ID__Z_LINE_ITEMS
Cost: 889.44 Degree: 1 Resp: 889.44 Card: 393700.79 Bytes: 0
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
Join order[1]: Z_LINE_ITEMS[LI]#0
***********************
Best so far: Table#: 0 cost: 889.4420 card: 393700.7874 bytes: 5511814
***********************
*********************************
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: 889.4420 Degree: 1 Card: 393701.0000 Bytes: 5511814
Resc: 889.4420 Resc_io: 887.0000 Resc_cpu: 85056917
Resp: 889.4420 Resp_io: 887.0000 Resc_cpu: 85056917
kkoqbc-subheap (delete addr=0x000000001636FA10, in-use=26384, alloc=32840)
kkoqbc-end:
:
call(in-use=11200, alloc=49288), compile(in-use=94192, alloc=95064), execution(in-use=5824, alloc=8088)
kkoqbc: finish optimizing query block SEL$1 (#0)
Copy query block qb# -1 (<unnamed>) : SELECT /*+ CACHE_TEMP_TABLE(T1) */ "C0" FROM "SYS"."SYS_TEMP_0FD9D6ACA_AB10D34" T1
Registered qb: SEL$D67CB2D2 0x164512c0 (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=10536, alloc=49288), compile(in-use=101960, alloc=103352), execution(in-use=7528, alloc=8088)
kkoqbc-subheap (create addr=0x000000001636E2A8)
****************
QUERY BLOCK TEXT
****************
select--+ materialize index(li (item_id))
rowid rid
from z_line_items li
where li.item_id = 42
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0
fro(0): flg=0 objn=97733 hint_alias="LI"@"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: Z_LINE_ITEMS Alias: LI
#Rows: 4000000 #Blks: 11167 AvgRowLen: 14.00 ChainCnt: 0.00
Column (#1001): ROWID( NO STATISTICS (using defaults)
AvgLen: 12 NDV: 4000000 Nulls: 0 Density: 0.000000
Column (#2): ITEM_ID(
AvgLen: 5 NDV: 99989 Nulls: 0 Density: 0.000009 Min: 0 Max: 100000
Histogram: HtBal #Bkts: 254 UncompBkts: 254 EndPtVals: 231
Index Stats::
Index: ITEM_ID__Z_LINE_ITEMS Col#: 2
LVLS: 2 #LB: 8988 #DK: 99989 LB/K: 1.00 DB/K: 36.00 CLUF: 3607827.00
User hint to use this index
Access path analysis for Z_LINE_ITEMS
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for Z_LINE_ITEMS[LI]
Table: Z_LINE_ITEMS Alias: LI
Card: Original: 4000000.000000 Rounded: 393701 Computed: 393700.79 Non Adjusted: 393700.79
Access Path: index (AllEqRange)
Index: ITEM_ID__Z_LINE_ITEMS
resc_io: 887.00 resc_cpu: 85056917
ix_sel: 0.098425 ix_sel_with_filters: 0.098425
Cost: 889.44 Resp: 889.44 Degree: 1
Best:: AccessPath: IndexRange
Index: ITEM_ID__Z_LINE_ITEMS
Cost: 889.44 Degree: 1 Resp: 889.44 Card: 393700.79 Bytes: 0
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
Join order[1]: Z_LINE_ITEMS[LI]#0
***********************
Best so far: Table#: 0 cost: 889.4420 card: 393700.7874 bytes: 5511814
***********************
(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)
id=0 frofkks[i] (index start key) predicate="LI"."ITEM_ID"=42
id=0 frofkke[i] (index stop key) predicate="LI"."ITEM_ID"=42
Final cost for query block SEL$1 (#0) - All Rows Plan:
Best join order: 1
Cost: 889.4420 Degree: 1 Card: 393701.0000 Bytes: 11023628
Resc: 889.4420 Resc_io: 887.0000 Resc_cpu: 85056917
Resp: 889.4420 Resp_io: 887.0000 Resc_cpu: 85056917
kkoqbc-subheap (delete addr=0x000000001636E2A8, in-use=26384, alloc=32840)
kkoqbc-end:
:
call(in-use=16080, alloc=65656), compile(in-use=103216, alloc=107536), execution(in-use=7528, alloc=8088)
kkoqbc: finish optimizing query block SEL$1 (#0)
kkoqbc: optimizing query block SEL$D67CB2D2 (#0)
:
call(in-use=16080, alloc=65656), compile(in-use=103712, alloc=107536), execution(in-use=7528, alloc=8088)
kkoqbc-subheap (create addr=0x000000001636E2A8)
****************
QUERY BLOCK TEXT
****************
with v as(
select--+ materialize index(li (item_id))
rowid rid
fr
---------------------
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_0FD9D6ACA_AB10D34 Alias: T1
#Rows: 393701 #Blks: 748 AvgRowLen: 14.00 ChainCnt: 0.00
Access path analysis for SYS_TEMP_0FD9D6ACA_AB10D34
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for SYS_TEMP_0FD9D6ACA_AB10D34[T1]
Table: SYS_TEMP_0FD9D6ACA_AB10D34 Alias: T1
Card: Original: 393701.000000 Rounded: 393701 Computed: 393701.00 Non Adjusted: 393701.00
Access Path: TableScan
Cost: 205.70 Resp: 28.57 Degree: 0
Cost_io: 204.00 Cost_cpu: 59055150
Resp_io: 28.33 Resp_cpu: 8202104
Best:: AccessPath: TableScan
Cost: 28.57 Degree: 8 Resp: 28.57 Card: 393701.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_0FD9D6ACA_AB10D34[T1]#0
***********************
Best so far: Table#: 0 cost: 28.5688 card: 393701.0000 bytes: 4724412
***********************
(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: 28.5688 Degree: 8 Card: 393701.0000 Bytes: 4724412
Resc: 205.6955 Resc_io: 204.0000 Resc_cpu: 59055150
Resp: 28.5688 Resp_io: 28.3333 Resc_cpu: 8202104
kkoqbc-subheap (delete addr=0x000000001636E2A8, in-use=23784, alloc=32840)
kkoqbc-end:
:
call(in-use=21320, alloc=65656), compile(in-use=105040, alloc=107536), execution(in-use=7528, alloc=8088)
kkoqbc: finish optimizing query block SEL$D67CB2D2 (#0)
kkoqbc: optimizing query block SEL$2 (#0)
:
call(in-use=21320, alloc=65656), compile(in-use=105136, alloc=107536), execution(in-use=7528, alloc=8088)
kkoqbc-subheap (create addr=0x000000001636E2A8)
****************
QUERY BLOCK TEXT
****************
with v as(
select--+ materialize index(li (item_id))
rowid rid
from z_line_items li
where li.item_id = 42
)
select--+ leading(v li o) use_nl(li) use_nl(o) parallel(v 4) gather_plan_statistics
sum(li.price)
from v
, z_line
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$2 nbfros=3 flg=0
fro(0): flg=0 objn=97733 hint_alias="LI"@"SEL$2"
fro(1): flg=0 objn=97731 hint_alias="O"@"SEL$2"
fro(2): 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
***********************
Table Stats::
Table: Z_LINE_ITEMS Alias: LI
#Rows: 4000000 #Blks: 11167 AvgRowLen: 14.00 ChainCnt: 0.00
Column (#1): ORDER_ID(
AvgLen: 5 NDV: 99995 Nulls: 0 Density: 0.000010 Min: 0 Max: 100000
Index Stats::
Index: ITEM_ID__Z_LINE_ITEMS Col#: 2
LVLS: 2 #LB: 8988 #DK: 99989 LB/K: 1.00 DB/K: 36.00 CLUF: 3607827.00
***********************
Table Stats::
Table: Z_ORDERS Alias: O
#Rows: 100000 #Blks: 190 AvgRowLen: 8.00 ChainCnt: 0.00
Column (#1): ID(
AvgLen: 5 NDV: 100000 Nulls: 0 Density: 0.000010 Min: 1 Max: 100000
Index Stats::
Index: ID__Z_ORDERS Col#: 1
LVLS: 1 #LB: 208 #DK: 100000 LB/K: 1.00 DB/K: 1.00 CLUF: 178.00
Access path analysis for V
Access path analysis for Z_LINE_ITEMS
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for Z_LINE_ITEMS[LI]
Table: Z_LINE_ITEMS Alias: LI
Card: Original: 4000000.000000 Rounded: 4000000 Computed: 4000000.00 Non Adjusted: 4000000.00
Access Path: TableScan
Cost: 3047.82 Resp: 423.31 Degree: 0
Cost_io: 3026.00 Cost_cpu: 760000000
Resp_io: 420.28 Resp_cpu: 105555556
Best:: AccessPath: TableScan
Cost: 423.31 Degree: 8 Resp: 423.31 Card: 4000000.00 Bytes: 0
Access path analysis for Z_ORDERS
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for Z_ORDERS[O]
Column (#2): ORDER_TYPE(
AvgLen: 3 NDV: 11 Nulls: 0 Density: 0.090909 Min: 0 Max: 10
Table: Z_ORDERS Alias: O
Card: Original: 100000.000000 Rounded: 90909 Computed: 90909.09 Non Adjusted: 90909.09
Access Path: TableScan
Cost: 53.63 Resp: 7.45 Degree: 0
Cost_io: 53.00 Cost_cpu: 22000000
Resp_io: 7.36 Resp_cpu: 3055556
Best:: AccessPath: TableScan
Cost: 7.45 Degree: 8 Resp: 7.45 Card: 90909.09 Bytes: 0
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
Join order[1]: V[V]#0 Z_LINE_ITEMS[LI]#1 Z_ORDERS[O]#2
***************
Now joining: Z_LINE_ITEMS[LI]#1
***************
NL Join
Outer table: Card: 393701.00 Cost: 28.57 Resp: 28.57 Degree: 8 Bytes: 12
Access path analysis for Z_LINE_ITEMS
Inner table: Z_LINE_ITEMS Alias: LI
Access Path: TableScan
NL Join: Cost: 1200197180.77 Resp: 166694052.88 Degree: 8
Cost_io: 1190707870.00 Cost_cpu: 330521938513247
Resp_io: 165376093.06 Resp_cpu: 45905824793506
Inner table: Z_LINE_ITEMS Alias: LI
Access Path: Rowid
NL Join: Cost: 393989.34 Resp: 54720.74 Degree: 8
Cost_io: 393905.00 Cost_cpu: 2937576389
Resp_io: 54709.03 Resp_cpu: 407996721
Best NL cost: 54720.74
resc: 393989.34 resc_io: 393905.00 resc_cpu: 2937576389
resp: 54720.74 resp_io: 54709.03 resc_cpu: 407996721
Column (#1): RID(
AvgLen: 12 NDV: 4000000 Nulls: 0 Density: 0.000000
Join Card: 393701.000000 = outer (393701.000000) * inner (4000000.000000) * sel (0.000000)
Join Card - Rounded: 393701 Computed: 393701.00
Best:: JoinMethod: NestedLoop
Cost: 54720.74 Degree: 8 Resp: 54720.74 Card: 393701.00 Bytes: 26
***************
Now joining: Z_ORDERS[O]#2
***************
NL Join
Outer table: Card: 393701.00 Cost: 54720.74 Resp: 54720.74 Degree: 8 Bytes: 26
Access path analysis for Z_ORDERS
Inner table: Z_ORDERS Alias: O
Access Path: TableScan
NL Join: Cost: 20917152.49 Resp: 2905160.07 Degree: 8
Cost_io: 20653104.00 Cost_cpu: 9197066005783
Resp_io: 2868486.67 Resp_cpu: 1277370278581
Access Path: index (UniqueScan)
Index: ID__Z_ORDERS
resc_io: 1.00 resc_cpu: 9241
ix_sel: 0.000010 ix_sel_with_filters: 0.000010
NL Join : Cost: 787794.80 Resp: 109415.94 Degree: 8
Cost_io: 787606.00 Cost_cpu: 6575940559
Resp_io: 109389.72 Resp_cpu: 913325078
Access Path: index (AllEqUnique)
Index: ID__Z_ORDERS
resc_io: 1.00 resc_cpu: 9241
ix_sel: 0.000010 ix_sel_with_filters: 0.000010
NL Join : Cost: 787794.80 Resp: 109415.94 Degree: 8
Cost_io: 787606.00 Cost_cpu: 6575940559
Resp_io: 109389.72 Resp_cpu: 913325078
Best NL cost: 109415.94
resc: 787794.80 resc_io: 787606.00 resc_cpu: 6575940559
resp: 109415.94 resp_io: 109389.72 resc_cpu: 913325078
Join Card: 357927.896395 = outer (393701.000000) * inner (90909.090909) * sel (0.000010)
Join Card - Rounded: 357928 Computed: 357927.90
Best:: JoinMethod: NestedLoop
Cost: 109415.94 Degree: 8 Resp: 109415.94 Card: 357927.90 Bytes: 34
***********************
Best so far: Table#: 0 cost: 28.5688 card: 393701.0000 bytes: 4724412
Table#: 1 cost: 54720.7414 card: 393701.0000 bytes: 10236226
Table#: 2 cost: 109415.9439 card: 357927.8964 bytes: 12169552
***********************
(newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000
*********************************
Number of join permutations tried: 1
*********************************
Consider using bloom filter between V[V] and LI[Z_LINE_ITEMS] with ??
kkoBloomFilter: join ndv:0 reduction:1.000000 (limit:0.500000) rejected because not a hash join
Consider using bloom filter between LI[Z_LINE_ITEMS] and O[Z_ORDERS] with ??
kkoBloomFilter: join ndv:0 reduction:1.000000 (limit:0.500000) rejected because not a hash join
Enumerating distribution method (advanced)
--- Distribution method for
join between V[V](parallel) and LI[Z_LINE_ITEMS](parallel); jm = 12; right side access path = RowId
---- NLJ left parallel and probe -> BROADCAST-RIGHT
--- Distribution method for
join between LI[Z_LINE_ITEMS](parallel) and O[Z_ORDERS](parallel); jm = 12; right side access path = IndexUnique
---- NLJ left parallel and probe -> BROADCAST-RIGHT
(newjo-save) [2 1 0 ]
Trying or-Expansion on query block SEL$2 (#0)
Transfer Optimizer annotations for query block SEL$2 (#0)
id=0 frofkks (rowid lookup) predicate="LI".ROWID="V"."RID"
id=0 frofkks[i] (index start key) predicate="O"."ID"="LI"."ORDER_ID"
id=0 frofkke[i] (index stop key) predicate="O"."ID"="LI"."ORDER_ID"
id=0 frofand predicate="O"."ORDER_TYPE"<>0
Final cost for query block SEL$2 (#0) - All Rows Plan:
Best join order: 1
Cost: 110305.3858 Degree: 8 Card: 357928.0000 Bytes: 12169552
Resc: 788684.2378 Resc_io: 788493.0000 Resc_cpu: 6660997476
Resp: 110305.3858 Resp_io: 110276.7222 Resc_cpu: 998381995
kkoqbc-subheap (delete addr=0x000000001636E2A8, in-use=52208, alloc=65704)
kkoqbc-end:
:
call(in-use=33488, alloc=114968), compile(in-use=111936, alloc=115824), execution(in-use=7664, alloc=8088)
kkoqbc: finish optimizing query block SEL$2 (#0)
apadrv-end
:
call(in-use=33488, alloc=114968), compile(in-use=115752, alloc=119512), execution(in-use=7664, alloc=8088)
CBRID: LI @ SEL$2 TableLookup allocation - Failure - : disabled by parameter
CBRID: O @ SEL$2 NLJBatching allocation - Failure - : disabled by parameter
CBRID: O @ SEL$2 TableLookup allocation - Failure - : disabled by parameter
Starting SQL statement dump
user_id=90 user_name=XTENDER module=SQL*Plus action=
sql_id=bpzdbc8pdm2yj plan_hash_value=-746718159 problem_type=3
----- Current SQL Statement for this session (sql_id=bpzdbc8pdm2yj) -----
with v as(
select--+ materialize index(li (item_id))
rowid rid
from z_line_items li
where li.item_id = 42
)
select--+ leading(v li o) use_nl(li) use_nl(o) parallel(v 4) gather_plan_statistics
sum(li.price)
from v
, z_line_items li
, z_orders o
where li.rowid = v.rid
and o.id = li.order_id
and o.order_type != 0
sql_text_length=359
sql=with v as(
select--+ materialize index(li (item_id))
rowid rid
from z_line_items li
where li.item_id = 42
)
select--+ leading(v li o) use_nl(li) use_nl(o) parallel(v 4) gather_plan_statistics
sum(li.price)
from v
, z_line
sql=_items li
, z_orders o
where li.rowid = v.rid
and o.id = li.order_id
and o.order_type != 0
----- Explain Plan Dump -----
----- Plan Table -----
============
Plan Table
============
------------------------------------------------------------------------+-----------------------------------+-------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib |
------------------------------------------------------------------------+-----------------------------------+-------------------------+
| 0 | SELECT STATEMENT | | | | 108K | | | | |
| 1 | TEMP TABLE TRANSFORMATION | | | | | | | | |
| 2 | LOAD AS SELECT | | | | | | | | |
| 3 | INDEX RANGE SCAN | ITEM_ID__Z_LINE_ITEMS | 384K | 5383K | 889 | 00:00:11 | | | |
| 4 | SORT AGGREGATE | | 1 | 34 | | | | | |
| 5 | PX COORDINATOR | | | | | | | | |
| 6 | PX SEND QC (RANDOM) | :TQ10000 | 1 | 34 | | |:Q1000| P->S |QC (RANDOM)|
| 7 | SORT AGGREGATE | | 1 | 34 | | |:Q1000| PCWP | |
| 8 | NESTED LOOPS | | 350K | 12M | 107K | 00:22:53 |:Q1000| PCWP | |
| 9 | NESTED LOOPS | | 384K | 12M | 107K | 00:22:53 |:Q1000| PCWP | |
| 10 | NESTED LOOPS | | 384K | 9996K | 53K | 00:11:57 |:Q1000| PCWP | |
| 11 | VIEW | | 384K | 4614K | 29 | 00:00:01 |:Q1000| PCWP | |
| 12 | PX BLOCK ITERATOR | | 384K | 4614K | 29 | 00:00:01 |:Q1000| PCWC | |
| 13 | TABLE ACCESS FULL | SYS_TEMP_0FD9D6ACA_AB10D34| 384K | 4614K | 29 | 00:00:01 |:Q1000| PCWP | |
| 14 | TABLE ACCESS BY USER ROWID | Z_LINE_ITEMS | 1 | 14 | 1 | 00:00:01 |:Q1000| PCWP | |
| 15 | INDEX UNIQUE SCAN | ID__Z_ORDERS | 1 | | 0 | |:Q1000| PCWP | |
| 16 | TABLE ACCESS BY INDEX ROWID | Z_ORDERS | 1 | 8 | 0 | |:Q1000| PCWP | |
------------------------------------------------------------------------+-----------------------------------+-------------------------+
Predicate Information:
----------------------
3 - access("LI"."ITEM_ID"=42)
13 - access(:Z>=:Z AND :Z<=:Z)
15 - access("O"."ID"="LI"."ORDER_ID")
16 - filter("O"."ORDER_TYPE"<>0)
Content of other_xml column
===========================
db_version : 11.2.0.4
parse_schema : XTENDER
plan_hash : 3548249137
plan_hash_2 : 606991664
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")
ROWID(@"SEL$2" "LI"@"SEL$2")
INDEX(@"SEL$2" "O"@"SEL$2" ("Z_ORDERS"."ID"))
LEADING(@"SEL$2" "V"@"SEL$2" "LI"@"SEL$2" "O"@"SEL$2")
USE_NL(@"SEL$2" "LI"@"SEL$2")
USE_NL(@"SEL$2" "O"@"SEL$2")
NLJ_BATCHING(@"SEL$2" "O"@"SEL$2")
PQ_DISTRIBUTE(@"SEL$2" "LI"@"SEL$2" NONE BROADCAST)
PQ_DISTRIBUTE(@"SEL$2" "O"@"SEL$2" NONE BROADCAST)
FULL(@"SEL$D67CB2D2" "T1"@"SEL$D67CB2D2")
INDEX(@"SEL$1" "LI"@"SEL$1" ("Z_LINE_ITEMS"."ITEM_ID"))
END_OUTLINE_DATA
*/
Optimizer state dump:
Compilation Environment Dump
optimizer_mode_hinted = false
optimizer_features_hinted = 0.0.0
parallel_execution_enabled = true
parallel_query_forced_dop = 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 0x16360eb8 (PARSER) [FINAL]
SEL$1 0x16362528 (PARSER) [FINAL]
SEL$D67CB2D2 0x164512c0 (MAP QUERY BLOCK SEL$1) [FINAL]
:
call(in-use=53680, alloc=114968), compile(in-use=197512, alloc=259944), execution(in-use=31600, alloc=32424)
End of Optimizer State Dump
Dumping Hints
=============
atom_hint=(@=000007FF5A97C2F8 err=0 resol=0 used=1 token=821 org=1 lvl=1 txt=GATHER_PLAN_STATISTICS ())
atom_hint=(@=0000000016360350 err=0 resol=1 used=1 token=177 org=1 lvl=3 txt=PARALLEL ("V",4) )
atom_hint=(@=0000000016360688 err=0 resol=1 used=1 token=924 org=1 lvl=3 txt=USE_NL ("O") )
atom_hint=(@=00000000163609C0 err=0 resol=1 used=1 token=924 org=1 lvl=3 txt=USE_NL ("LI") )
atom_hint=(@=0000000016360C88 err=0 resol=1 used=1 token=501 org=1 lvl=4 txt=LEADING ("V" "LI" "O") )
atom_hint=(@=0000000016450FB0 err=0 resol=1 used=0 token=819 org=1 lvl=3 txt=CACHE_TEMP_TABLE ("T1") )
atom_hint=(@=0000000016451CE8 err=0 resol=1 used=1 token=855 org=1 lvl=2 txt=MATERIALIZE ())
atom_hint=(@=0000000016451A20 err=0 resol=1 used=0 token=177 org=1 lvl=3 txt=PARALLEL ("LI",4) )
atom_hint=(@=0000000016451B20 err=0 resol=1 used=1 token=83 org=1 lvl=3 txt=INDEX ("LI" "ITEM_ID__Z_LINE_ITEMS") )
====================== END SQL Statement Dump ======================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment