Oracle CBO Transformation-FPD(filter push-down)
对于用户写的SQL,Oracle会进行等价改写。这种改写转换都是基于一种固定的算法,也叫启发式转换,大多存在问题,比如我们写in,oracle在有可能的情况下,会将in转换成exist,然后用semi join的方式给你做join,在一般情况下exist比in...
一.Oracle不做transformation,这时你就要去分析原因
二.Orale做错了transformation,导致了错误的结果集.(复杂的视图)
join:
inner-join:等值连接
outer-join:外连接
semi-join:exist,oracle用一个列匹配另外的列,当只要有一个值匹配成功即结束。不会遍历所有的值。
anti-join:not exist(或者 not in)这种情况。
view:
Simple:能拿到rowid,那么就是一个简单的view,结果集拿不到rowid就是复杂的view。
Complex(复杂view):包含聚合函数 如distinct,group by ,connect by,只要有递归查询这用view,我们就称之为复杂的view。
in-line view:相当于子查询
sub-query:
=in,exists,not in,not exists
transformation的过程:
一个查询发起时,首先要做启发式的transformation,转化好之后再做优化,最后生成执行计划。
查询->启发式Transformation->优化->执行计划
1.启发式Transformation:
(1)其规则是硬代码写死
(2)先于cost评估
(3)剔除多余的操作
(4)最小化query block
2.基于成本的Transformation
在多个可能Transformation的路径中选择
从多个Transformation结果中找到好的plan
查询->启发式Transformation->基于成本的Transformation->优化->执行计划
例子:
set line 200
set pages 200
@10053.sql
select /*sample 1*/e.ename
from emp e, emp m
where e.mgr=m.empno
and m.deptno = 10
and e.deptno = m.deptno
and e.sal>1500
and m.sal>e.sal;
@10053d.sql
/oracle/app/diag/rdbms/prod/prod/trace/prod_ora_3937.trc
经过transformations后的最终语句:
Final query after transformations:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL" AND "M"."SAL">1500 AND "E"."DEPTNO"=10
10053trace文件全部内容:
Trace file /oracle/app/diag/rdbms/prod/prod/trace/prod_ora_3937.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
ORACLE_HOME = /oracle/app/product/11.2.0/db_1
System name:Linux
Node name:
Release:2.6.32-642.el6.x86_64
Version:#1 SMP Tue May 10 17:27:01 UTC
Machine:x86_64
VM name:VMWare Version: 6
Instance name: prod
Redo thread mounted by this instance: 1
Oracle process number: 30
Unix process pid: 3937, image: oracle@ (TNS V1-V3)
*** -07-30 21:51:47.085
*** SESSION ID:(135.85) -07-30 21:51:47.085
*** CLIENT ID:() -07-30 21:51:47.085
*** SERVICE NAME:(SYS$USERS) -07-30 21:51:47.085
*** MODULE NAME:(SQL*Plus) -07-30 21:51:47.085
*** ACTION NAME:() -07-30 21:51:47.085
Registered qb: SEL$1 0xcceb2550 (PARSER)
---------------------
QUERY BLOCK SIGNATURE--10053第一步查询块签名认证
---------------------
signature (): qb_name=SEL$1 nbfros=2 flg=0--查询块签名
fro(0): flg=4 objn=87108 hint_alias="E"@"SEL$1"
fro(1): flg=4 objn=87108 hint_alias="M"@"SEL$1"
查询块定义:
Query Block是指一个语义上完整的查询语句,它可以是一个子查询所对应的SQL语句,也可以是一个视图所对应的视图定义语句。目标SQL可以包含一个或者多个Query Block,当目标SQL只包含一个Query block时,这个query block就是目标SQL本身。
查询块签名列出了该查询块中的表,(fro(0)),有助于我们了解查询是如何被分解为各个部分的.
SPM: statement not found in SMB--当前不存在sql plan baselines
**************************
Automatic degree of parallelism (ADOP)
**************************
Automatic degree of parallelism is disabled: Parameter.
PM: Considering predicate move-around in query block SEL$1 (#0)--考虑是否可以去除谓词,也叫过滤谓词移动
**************************
Predicate Move-Around (PM)
**************************
OPTIMIZER INFORMATION
******************************************
----- Current SQL Statement for this session (sql_id=4usswnngj0jdx)
-----当前SQL展示,未进行transformation
select /*sample 1*/e.ename
from emp e, emp m
where e.mgr=m.empno
and m.deptno = 10
and e.deptno = m.deptno
and e.sal>1500
and m.sal>e.sal
*******************************************
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
当前环境被修改的优化器相关参数,
如果存在相关优化器参数被修改,会被此处列出,sqlt时重点看
******************************
Compilation Environment Dump
Bug Fix Control Environment
*************************************
PARAMETERS WITH DEFAULT VALUES--所有与CBO相关参数列示.
******************************
Compilation Environment Dump
optimizer_mode_hinted= false
optimizer_features_hinted= 0.0.0
parallel_execution_enabled= true
parallel_query_forced_dop= 0
parallel_dml_forced_dop= 0
parallel_ddl_forced_degree= 0
parallel_ddl_forced_instances= 0
_query_rewrite_fudge= 90
optimizer_features_enable= 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= 204800 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= 204 KB
_smm_max_size_static= 40960 KB
_smm_px_max_size_static= 102400 KB
_cpu_to_io= 0
_optimizer_undo_cost_change= 11.2.0.4
parallel_query_mode= enabled
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
parallel_query_default_dop= 0
is_recur_flags= 0
optimizer_use_invisible_indexes= false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force= true
cell_offload_processing= true
_rdbms_internal_fplib_enabled= false
db_file_multiblock_read_count= 128
_bloom_folding_enabled= true
_mv_generalized_oj_refresh_opt= true
cell_offload_compaction= ADAPTIVE
cell_offload_plan_display= AUTO
_bloom_predicate_pushdown_to_storage = true
_bloom_vector_elements= 0
_bloom_pushing_max= 512
parallel_degree_limit= 65535
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--当前环境Bug Fix,可根据Bug号去Mos匹配,可手动关掉
fix3834770 = 1
fix3746511 = enabled
fix4519016 = enabled
fix3118776 = enabled
fix4488689 = enabled
fix2194204 = disabled
fix2660592 = enabled
fix2320291 = enabled
fix2324795 = enabled
fix4308414 = enabled
fix3499674 = disabled
fix4569940 = enabled
fix4631959 = enabled
fix4519340 = enabled
fix4550003 = enabled
fix1403283 = enabled
fix4554846 = enabled
fix4602374 = enabled
fix4584065 = enabled
fix4545833 = enabled
fix4611850 = enabled
fix4663698 = enabled
fix4663804 = enabled
fix4666174 = enabled
fix4567767 = enabled
fix4556762 = 15
fix4728348 = enabled
fix4708389 = enabled
fix4175830 = enabled
fix4752814 = enabled
fix4583239 = enabled
fix4386734 = enabled
fix4887636 = enabled
fix4483240 = enabled
fix4872602 = disabled
fix4711525 = enabled
fix4545802 = enabled
fix4605810 = enabled
fix4704779 = enabled
fix4900129 = enabled
fix4924149 = enabled
fix4663702 = enabled
fix4878299 = enabled
fix4658342 = enabled
fix4881533 = enabled
fix4676955 = enabled
fix4273361 = enabled
fix4967068 = enabled
fix4969880 = disabled
fix5005866 = enabled
fix5015557 = enabled
fix4705343 = enabled
fix4904838 = enabled
fix4716096 = enabled
fix4483286 = disabled
fix4722900 = enabled
fix4615392 = enabled
fix5096560 = enabled
fix5029464 = enabled
fix4134994 = enabled
fix4904890 = enabled
fix5104624 = enabled
fix5014836 = enabled
fix4768040 = enabled
fix4600710 = enabled
fix5129233 = enabled
fix4595987 = enabled
fix4908162 = enabled
fix5139520 = enabled
fix5084239 = enabled
fix5143477 = disabled
fix2663857 = enabled
fix4717546 = enabled
fix5240264 = disabled
fix5099909 = enabled
fix5240607 = enabled
fix5195882 = enabled
fix5220356 = enabled
fix5263572 = enabled
fix5385629 = enabled
fix5302124 = enabled
fix5391942 = enabled
fix5384335 = enabled
fix5482831 = enabled
fix4158812 = enabled
fix5387148 = enabled
fix5383891 = enabled
fix5466973 = enabled
fix5396162 = enabled
fix5394888 = enabled
fix5395291 = enabled
fix5236908 = enabled
fix5509293 = enabled
fix5449488 = enabled
fix5567933 = enabled
fix5570494 = enabled
fix5288623 = enabled
fix5505995 = enabled
fix5505157 = enabled
fix5112460 = enabled
fix5554865 = enabled
fix5112260 = enabled
fix5112352 = enabled
fix5547058 = enabled
fix5618040 = enabled
fix5585313 = enabled
fix5547895 = enabled
fix5634346 = enabled
fix5620485 = enabled
fix5483301 = enabled
fix5657044 = enabled
fix5694984 = enabled
fix5868490 = enabled
fix5650477 = enabled
fix5611962 = enabled
fix4279274 = enabled
fix5741121 = enabled
fix5714944 = enabled
fix5391505 = enabled
fix5762598 = enabled
fix5578791 = enabled
fix5259048 = enabled
fix5882954 = enabled
fix2492766 = enabled
fix5707608 = enabled
fix5891471 = enabled
fix5884780 = enabled
fix5680702 = enabled
fix5371452 = enabled
fix5838613 = enabled
fix5949981 = enabled
fix5624216 = enabled
fix5741044 = enabled
fix5976822 = enabled
fix6006457 = enabled
fix5872956 = enabled
fix5923644 = enabled
fix5943234 = enabled
fix5844495 = enabled
fix4168080 = enabled
fix6020579 = enabled
fix5842686 = disabled
fix5996801 = enabled
fix5593639 = enabled
fix6133948 = enabled
fix3151991 = enabled
fix6146906 = enabled
fix6239909 = enabled
fix6267621 = enabled
fix5909305 = enabled
fix6279918 = enabled
fix6141818 = enabled
fix6151963 = enabled
fix6251917 = enabled
fix6282093 = enabled
fix6119510 = enabled
fix6119382 = enabled
fix3801750 = enabled
fix5705630 = disabled
fix5944076 = enabled
fix5406763 = enabled
fix6070954 = enabled
fix6282944 = enabled
fix6138746 = enabled
fix6082745 = enabled
fix3426050 = enabled
fix599680 = enabled
fix6062266 = enabled
fix6087237 = enabled
fix6122894 = enabled
fix6377505 = enabled
fix5893768 = enabled
fix6163564 = enabled
fix6073325 = enabled
fix6188881 = enabled
fix6007259 = enabled
fix6239971 = enabled
fix5284200 = disabled
fix6042205 = enabled
fix6051211 = enabled
fix6434668 = enabled
fix6438752 = enabled
fix5936366 = enabled
fix6439032 = enabled
fix6438892 = enabled
fix6006300 = enabled
fix5947231 = enabled
fix5416118 = 1
fix6365442 = 1
fix6239039 = enabled
fix6502845 = enabled
fix6913094 = enabled
fix6029469 = enabled
fix5919513 = enabled
fix6057611 = enabled
fix6469667 = enabled
fix6608941 = disabled
fix6368066 = enabled
fix6329318 = enabled
fix6656356 = enabled
fix4507997 = enabled
fix6671155 = enabled
fix6694548 = enabled
fix6688200 = enabled
fix6612471 = enabled
fix6708183 = disabled
fix6326934 = enabled
fix6520717 = disabled
fix6714199 = enabled
fix6681545 = enabled
fix6748058 = enabled
fix6167716 = enabled
fix6674254 = enabled
fix6468287 = enabled
fix6503543 = enabled
fix6808773 = disabled
fix6766962 = enabled
fix6120483 = enabled
fix6670551 = enabled
fix6771838 = enabled
fix6626018 = disabled
fix6530596 = enabled
fix6778642 = enabled
fix6699059 = enabled
fix6376551 = enabled
fix6429113 = enabled
fix6782437 = enabled
fix6776808 = enabled
fix6765823 = enabled
fix6768660 = enabled
fix6782665 = enabled
fix6610822 = enabled
fix6514189 = enabled
fix6818410 = enabled
fix6827696 = enabled
fix6773613 = enabled
fix5902962 = enabled
fix6956212 = enabled
fix3056297 = enabled
fix6440977 = disabled
fix6972291 = disabled
fix6904146 = enabled
fix6221403 = enabled
fix5475051 = enabled
fix6845871 = enabled
fix5468809 = enabled
fix6917633 = enabled
fix4444536 = disabled
fix6955210 = enabled
fix6994194 = enabled
fix6399597 = disabled
fix6951776 = enabled
fix5648287 = 3
fix6987082 = disabled
fix7132036 = enabled
fix6980350 = enabled
fix5199213 = enabled
fix7138405 = enabled
fix7148689 = enabled
fix6820988 = enabled
fix7032684 = enabled
fix6617866 = enabled
fix7155968 = enabled
fix7127980 = enabled
fix6982954 = enabled
fix7241819 = enabled
fix6897034 = enabled
fix7236148 = enabled
fix7298570 = enabled
fix7249095 = enabled
fix7314499 = enabled
fix7324224 = enabled
fix7289023 = enabled
fix7237571 = enabled
fix7116357 = enabled
fix7345484 = enabled
fix7375179 = enabled
fix6430500 = disabled
fix5897486 = enabled
fix6774209 = enabled
fix7306637 = enabled
fix6451322 = enabled
fix7208131 = enabled
fix7388652 = enabled
fix7127530 = enabled
fix6751206 = enabled
fix6669103 = enabled
fix7430474 = enabled
fix6990305 = enabled
fix7043307 = enabled
fix3120429 = enabled
fix7452823 = disabled
fix6838105 = enabled
fix6769711 = enabled
fix7170213 = enabled
fix6528872 = enabled
fix7295298 = enabled
fix5922070 = enabled
fix7259468 = enabled
fix6418552 = enabled
fix4619997 = enabled
fix7524366 = enabled
fix6942476 = enabled
fix6418771 = enabled
fix7375077 = enabled
fix5400639 = enabled
fix4570921 = enabled
fix7426911 = enabled
fix5099019 = disabled
fix7528216 = enabled
fix7521266 = enabled
fix7385140 = enabled
fix7576516 = enabled
fix7573526 = enabled
fix7576476 = enabled
fix7165898 = enabled
fix7263214 = enabled
fix330 = enabled
fix7555510 = enabled
fix7613118 = enabled
fix7597059 = enabled
fix7558911 = enabled
fix5520732 = enabled
fix7679490 = disabled
fix7449971 = enabled
fix3628118 = enabled
fix4370840 = enabled
fix7281191 = enabled
fix7519687 = enabled
fix5029592 = 3
fix6012093 = 1
fix6053861 = disabled
fix6941515 = disabled
fix7696414 = enabled
fix7272039 = enabled
fix7834811 = enabled
fix7640597 = enabled
fix7341616 = enabled
fix7168184 = enabled
fix399198 = enabled
fix7831070 = enabled
fix7676897 = disabled
fix7414637 = enabled
fix7585456 = enabled
fix8202421 = enabled
fix7658097 = disabled
fix8251486 = enabled
fix7132684 = enabled
fix7512227 = enabled
fix6972987 = enabled
fix7199035 = enabled
fix8243446 = enabled
fix7650462 = enabled
fix6720701 = enabled
fix7592673 = enabled
fix7718694 = enabled
fix7534027 = enabled
fix7708267 = enabled
fix5716785 = enabled
fix7356191 = enabled
fix7679161 = enabled
fix7597159 = enabled
fix7499258 = enabled
fix8328363 = enabled
fix7452863 = enabled
fix8284930 = enabled
fix7298626 = enabled
fix7657126 = enabled
fix8371884 = enabled
fix8318020 = enabled
fix8255423 = enabled
fix7135745 = enabled
fix8356253 = enabled
fix7534257 = enabled
fix8323407 = enabled
fix7539815 = enabled
fix8289316 = enabled
fix8447850 = enabled
fix7675944 = enabled
fix8355120 = enabled
fix7176746 = enabled
fix8442891 = enabled
fix8373261 = enabled
fix7679164 = enabled
fix7670533 = enabled
fix8408665 = enabled
fix8491399 = enabled
fix8348392 = enabled
fix8348585 = enabled
fix8508056 = enabled
fix8335178 = enabled
fix8515269 = enabled
fix8247017 = enabled
fix7325597 = enabled
fix8531490 = enabled
fix6163600 = enabled
fix8589278 = disabled
fix8557992 = enabled
fix7556098 = enabled
fix8580883 = enabled
fix5892599 = disabled
fix8609714 = enabled
fix8619631 = disabled
fix8672915 = enabled
fix8514561 = enabled
fix8213977 = enabled
fix8560951 = disabled
fix8578587 = enabled
fix8287870 = enabled
fix8467123 = enabled
fix8602185 = enabled
fix8519457 = enabled
fix3335182 = enabled
fix8602840 = enabled
fix8725296 = enabled
fix8628970 = enabled
fix6754080 = enabled
fix8767442 = enabled
fix8760135 = enabled
fix8644935 = enabled
fix8352378 = enabled
fix8685327 = enabled
fix8763472 = enabled
fix8773324 = enabled
fix8813674 = enabled
fix8532236 = enabled
fix8629716 = enabled
fix7277732 = enabled
fix8692170 = enabled
fix8900973 = enabled
fix8919133 = enabled
fix8927050 = enabled
fix8551880 = enabled
fix8901237 = enabled
fix8812372 = enabled
fix6236862 = enabled
fix8528517 = enabled
fix7215982 = enabled
fix8214022 = enabled
fix8595392 = enabled
fix8890233 = enabled
fix8999317 = enabled
fix9004800 = enabled
fix8986163 = enabled
fix8855396 = enabled
fix8800514 = 20
fix9007859 = enabled
fix8198783 = disabled
fix9053879 = enabled
fix6086930 = enabled
fix7641601 = enabled
fix9052506 = enabled
fix9103775 = enabled
fix9047975 = enabled
fix8893626 = enabled
fix9111170 = enabled
fix8971829 = enabled
fix7628358 = enabled
fix9125151 = enabled
fix9039715 = enabled
fix9106224 = enabled
fix9185228 = enabled
fix9206747 = enabled
fix9088510 = enabled
fix9143856 = enabled
fix8833381 = enabled
fix8949971 = enabled
fix8951812 = enabled
fix9148171 = enabled
fix8706652 = enabled
fix9245114 = enabled
fix8802198 = enabled
fix9011016 = enabled
fix9265681 = enabled
fix7284269 = enabled
fix9272549 = enabled
fix8917507 = 7
fix8531463 = enabled
fix9263333 = enabled
fix8675087 = enabled
fix8571403 = enabled
fix8896955 = enabled
fix9041934 = enabled
fix9344709 = enabled
fix9024933 = enabled
fix9033718 = enabled
fix9240455 = enabled
fix9081848 = enabled
fix5982893 = enabled
fix9287401 = enabled
fix8590021 = enabled
fix9340120 = enabled
fix9355794 = enabled
fix9356656 = enabled
fix9385634 = enabled
fix9069046 = enabled
fix9239337 = enabled
fix9300228 = enabled
fix9298010 = enabled
fix9384170 = enabled
fix9301862 = disabled
fix9407929 = enabled
fix8836806 = enabled
fix9344055 = enabled
fix9274675 = enabled
fix9203723 = enabled
fix9443476 = enabled
fix9195582 = enabled
fix8226666 = enabled
fix9433490 = enabled
fix9065494 = enabled
fix9303766 = enabled
fix9437283 = enabled
fix9116214 = enabled
fix9456688 = enabled
fix9456746 = disabled
fix9342979 = enabled
fix9465425 = enabled
fix9092442 = enabled
fix4926618 = enabled
fix8792846 = enabled
fix9474259 = enabled
fix9495669 = disabled
fix6472966 = enabled
fix6408301 = enabled
fix9380298 = disabled
fix8500130 = enabled
fix9584723 = enabled
fix9270951 = enabled
fix9508254 = enabled
fix9593680 = enabled
fix9196440 = disabled
fix9309281 = enabled
fix8693158 = enabled
fix9381638 = enabled
fix9383967 = enabled
fix7711900 = enabled
fix9218587 = enabled
fix9728438 = enabled
fix9038395 = enabled
fix9577300 = enabled
fix9171113 = enabled
fix8973745 = enabled
fix9732434 = enabled
fix8937971 = disabled
fix9102474 = enabled
fix9243499 = enabled
fix9912503 = enabled
fix9153459 = enabled
fix9762592 = 3
fix9785632 = enabled
fix9659125 = 0
fix9702850 = enabled
fix9958518 = enabled
fix8349119 = enabled
fix 10041074 = enabled
fix 10134677 = enabled
fix9716877 = enabled
fix8961143 = enabled
fix 10080014 = enabled
fix 10026972 = enabled
fix9476520 = enabled
fix9841679 = enabled
fix 10004943 = enabled
fix9791810 = enabled
fix9668086 = enabled
fix9850461 = enabled
fix9940732 = enabled
fix9578670 = enabled
fix 10197666 = enabled
fix9630092 = disabled
fix 10271790 = enabled
fix 10015652 = enabled
fix8274946 = enabled
fix 10192889 = enabled
fix 10336499 = disabled
fix9814067 = enabled
fix 10158107 = enabled
fix 10182051 = 3
fix 10376744 = enabled
fix 10043801 = enabled
fix9832338 = disabled
fix9002661 = enabled
fix9898066 = enabled
fix9569678 = enabled
fix 11741436 = enabled
fix 10232623 = enabled
fix 10232225 = enabled
fix9829887 = enabled
fix 10359631 = enabled
fix8275054 = enabled
fix 10640430 = enabled
fix 10227392 = enabled
fix 10117760 = enabled
fix9554026 = disabled
fix9593547 = disabled
fix9833381 = disabled
fix9881812 = enabled
fix 10333395 = enabled
fix9776736 = enabled
fix9748015 = enabled
fix 11744086 = enabled
fix 11834739 = enabled
fix 11830663 = enabled
fix 11877160 = enabled
fix9227576 = enabled
fix 11814428 = enabled
fix 11843512 = enabled
fix 11853331 = enabled
fix6055658 = enabled
fix 11657468 = enabled
fix 1178 = enabled
fix 10428278 = enabled
fix8275023 = enabled
fix 11740670 = enabled
fix9477688 = enabled
fix9980661 = enabled
fix 11676888 = disabled
fix 10623119 = enabled
fix 10162430 = enabled
fix 10330090 = enabled
fix9680430 = 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
fix7147087 = enabled
fix 11846314 = enabled
fix 12432426 = enabled
fix 12584007 = enabled
fix8683604 = enabled
fix 12432089 = enabled
fix 12591120 = enabled
fix 11876260 = enabled
fix9913117 = enabled
fix 12348584 = enabled
fix 1040 = enabled
fix3639130 = 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
fix6923730 = 0
fix 13634700 = enabled
fix 12828479 = enabled
fix 11689541 = enabled
fix9547706 = 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
fix2273284 = enabled
fix 13454409 = enabled
fix 12728203 = enabled
fix 13065064 = enabled
fix 13616573 = enabled
fix 11858963 = enabled
fix 13929275 = enabled
fix8792821 = 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
fix9891396 = enabled
fix 13321547 = enabled
fix 13486825 = enabled
fix7271518 = 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
fix4215125 = 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
fix3566843 = enabled
fix9550277 = disabled
fix6873091 = enabled
fix 14467202 = enabled
fix 14541122 = enabled
fix 14098180 = enabled
fix 14243782 = enabled
fix 13255388 = 10
fix 11727871 = enabled
fix9633142 = disabled
fix 12869367 = enabled
fix 14055128 = enabled
fix 13652216 = enabled
fix 13849486 = enabled
fix 14008590 = enabled
fix 13594757 = enabled
fix9114915 = 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
fix9094254 = enabled
fix 13104618 = enabled
fix 12942119 = enabled
fix 14256885 = enabled
fix 13943459 = enabled
fix 13263174 = enabled
fix 14311185 = enabled
fix 14795969 = enabled
fix9971371 = 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 1437 = enabled
fix 13083139 = enabled
fix6520878 = enabled
fix 1336 = 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
fix9858777 = 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$1 (#0)
**************************
Query trrmations (QT)--Oracle进行查询转换流程判断
JF: Checking validity of join factorization for query block SEL$1 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block. --不存在union,union all 跳过
ST: not valid since star transformation parameter is FALSE --星型转换跳过
TE: Checking validity of table expansion for query block SEL$1 (#0)
TE: Bypassed: No partitioned table in query block. --没有分区表跳过
CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.--不是复杂视图跳过
CBQT: Validity checks failed for 4usswnngj0jdx.
CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
*************************
Common Subexpression elimination (CSE)
*************************
CSE:CSE not performed on query block SEL$1 (#0).
OBYE:Considering Order-by Elimination from view SEL$1 (#0)
***************************
Order-by elimination (OBYE)
***************************
OBYE:OBYE bypassed: no order by to eliminate.
JE:Considering Join Elimination on query block SEL$1 (#0)--考虑消除Join
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL"
JE:cfro: EMP objn:87108 col#:4 dfro:EMP dcol#:1
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
JE:cfro: EMP objn:87108 col#:1 dfro:EMP dcol#:4
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
SQL:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL"
Query block SEL$1 (#0) unchanged
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)
JE:Considering Join Elimination on query block SEL$1 (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL"
JE:cfro: EMP objn:87108 col#:4 dfro:EMP dcol#:1
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
JE:cfro: EMP objn:87108 col#:1 dfro:EMP dcol#:4
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
SQL:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL"
Query block SEL$1 (#0) unchanged
query block SEL$1 (#0) unchanged
Considering Query Transformations on query block SEL$1 (#0)
**************************
Query transformations (QT)
**************************
JF: Checking validity of join factorization for query block SEL$1 (#0)
JF: Bypassed: not a UNION or UNION-ALL query block.
ST: not valid since star transformation parameter is FALSE
TE: Checking validity of table expansion for query block SEL$1 (#0)
TE: Bypassed: No partitioned table in query block.
CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.
CBQT: Validity checks failed for 4usswnngj0jdx.
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).
SU: Considering subquery unnesting in query block SEL$1 (#0)
********************
Subquery Unnest (SU)
********************
SJC: Considering set-join conversion in query block SEL$1 (#0)
*************************
Set-Join Conversion (SJC)
*************************
SJC: not performed
JE:Considering Join Elimination on query block SEL$1 (#0)
*************************
Join Elimination (JE)
*************************
SQL:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL"
JE:cfro: EMP objn:87108 col#:4 dfro:EMP dcol#:1
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
JE:cfro: EMP objn:87108 col#:1 dfro:EMP dcol#:4
JE:cfro: EMP objn:87108 col#:8 dfro:EMP dcol#:8
SQL:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL"
Query block SEL$1 (#0) unchanged
PM: Considering predicate move-around in query block SEL$1 (#0)
**************************
Predicate Move-Around (PM)
**************************
PM:PM bypassed: Outer query contains no views.
PM:PM bypassed: Outer query contains no views.
query block SEL$1 (#0) unchanged
FPD: Considering simple filter push in query block SEL$1 (#0)
"E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL"
try to generate transitive predicate from check constraints for query block SEL$1 (#0)
finally:"E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL" AND "M"."SAL">1500 AND "E"."DEPTNO"=10
FPD:transitive predicates are generated in query block SEL$1 (#0)--产生了可传递谓词
"E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL" AND "M"."SAL">1500 AND "E"."DEPTNO"=10
apadrv-start sqlid=5576332259131147709
:
call(in-use=3888, alloc=16344), compile(in-use=76512, alloc=79360), execution(in-use=3336, alloc=4032)
*******************************************
Peeked values of the binds in SQL statement
*******************************************
Final query after transformations:******* UNPARSED QUERY IS *******
SELECT "E"."ENAME" "ENAME" FROM "SCOTT"."EMP" "E","SCOTT"."EMP" "M" WHERE "E"."MGR"="M"."EMPNO" AND "M"."DEPTNO"=10 AND "E"."DEPTNO"="M"."DEPTNO" AND "E"."SAL">1500 AND "M"."SAL">"E"."SAL" AND "M"."SAL">1500 AND "E"."DEPTNO"=10--经过transformations后的最终语句
kkoqbc: optimizing query block SEL$1 (#0)
:
call(in-use=4232, alloc=16344), compile(in-use=77800, alloc=79360), execution(in-use=3336, alloc=4032)
kkoqbc-subheap (create addr=0x7fadccebfa10)
****************
QUERY BLOCK TEXT
****************
select /*sample 1*/e.ename
from emp e, emp m
where e.mgr=m.empno
and m.deptno = 10
and e.deptno = m.deptno
and e.sal>1500
and m.sal>e.sal
---------------------
QUERY BLOCK SIGNATURE
---------------------
signature (optimizer): qb_name=SEL$1 nbfros=2 flg=0
fro(0): flg=0 objn=87108 hint_alias="E"@"SEL$1"
fro(1): flg=0 objn=87108 hint_alias="M"@"SEL$1"
-----------------------------
SYSTEM STATISTICS INFORMATION--系统统计信息
-----------------------------
Using NOWORKLOAD Stats
CPUSPEEDNW: 3074 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: EMPAlias:M
#Rows: 14#Blks:5AvgRowLen:38.00ChainCnt:0.00
--表统计信息 Rows->num_rows / Blks ->num_block /AvgRowLen平均行长 / ChainCnt行链接
Column (#1): EMPNO(
--Column(#1) 列出涉及查询的列
AvgLen: 4 NDV: 14 Nulls: 0 Density: 0.071429 Min: 7369 Max: 7934
--列统计信息AvgLen:平均长度 / NDV:唯一值 在没有直方图的情况下NDV=1/density / Nulls:空值数量 / Density:密度 / Min:最大值 high value/ Max:最小值 low value
--Column (#1): EMPNO该列没有直方图信息
Column (#8): DEPTNO(
AvgLen: 3 NDV: 3 Nulls: 0 Density: 0.107143 Min: 10 Max: 30
Histogram: HtBal#Bkts: 14UncompBkts: 14EndPtVals: 3 --直方图为highbalance
Index Stats::
Index: PK_EMPCol#: 1
LVLS: 0#LB: 1#DK: 14LB/K: 1.00DB/K: 1.00CLUF: 1.00
***********************
Table Stats::
Table: EMPAlias:E
#Rows: 14#Blks:5AvgRowLen:38.00ChainCnt:0.00
Column (#4): MGR(
AvgLen: 4 NDV: 6 Nulls: 1 Density: 0.166667 Min: 7566 Max: 7902
Column (#8): DEPTNO(
AvgLen: 3 NDV: 3 Nulls: 0 Density: 0.107143 Min: 10 Max: 30
Histogram: HtBal#Bkts: 14UncompBkts: 14EndPtVals: 3
Index Stats::
Index: PK_EMPCol#: 1
LVLS: 0#LB: 1#DK: 14LB/K: 1.00DB/K: 1.00CLUF: 1.00
Access path analysis for EMP--表的访问路径成本分析
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for EMP[E]--分析如何访问单表E是最快的。
Column (#6):
NewDensity:0.035714, OldDensity:0.035714 BktCnt:14, PopBktCnt:4, PopValCnt:2, NDV:12
Column (#6): SAL(
AvgLen: 4 NDV: 12 Nulls: 0 Density: 0.035714 Min: 800 Max: 5000
Histogram: Freq#Bkts: 12UncompBkts: 14EndPtVals: 12
Table: EMPAlias: E
Card: Original: 14.000000Rounded: 1Computed: 1.39Non Adjusted: 1.39
Access Path:TableScan
Cost:3.00Resp: 3.00Degree: 0
Cost_io: 3.00Cost_cpu: 40547
Resp_io: 3.00Resp_cpu: 40547
Best:: AccessPath: TableScan
Cost: 3.00Degree: 1Resp: 3.00Card: 1.39Bytes: 0
Access path analysis for EMP
***************************************
SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for EMP[M]--分析如何访问单表M是最快的。
Column (#6):
NewDensity:0.035714, OldDensity:0.035714 BktCnt:14, PopBktCnt:4, PopValCnt:2, NDV:12
Column (#6): SAL(
AvgLen: 4 NDV: 12 Nulls: 0 Density: 0.035714 Min: 800 Max: 5000
Histogram: Freq#Bkts: 12UncompBkts: 14EndPtVals: 12
Table: EMPAlias: M
Card: Original: 14.000000Rounded: 2Computed: 1.50Non Adjusted: 1.50
Access Path:TableScan
Cost:3.00Resp: 3.00Degree: 0
Cost_io: 3.00Cost_cpu: 40517
Resp_io: 3.00Resp_cpu: 40517
Best:: AccessPath: TableScan
Cost: 3.00Degree: 1Resp: 3.00Card: 1.50Bytes: 0
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.--考虑表连接方式
Permutations for Starting Table :0
Join order[1]:EMP[E]#0 EMP[M]#1 --E为驱动表M为被驱动表
***************
Now joining: EMP[M]#1--EMP[M]为被驱动表cost计算
***************
NL Join
Outer table: Card: 1.39Cost: 3.00Resp: 3.00Degree: 1Bytes: 17
Access path analysis for EMP
Inner table: EMPAlias: M
Access Path: TableScan
NL Join:Cost: 6.00Resp: 6.00Degree: 1
Cost_io: 6.00Cost_cpu: 81064
Resp_io: 6.00Resp_cpu: 81064
Access Path: index (UniqueScan)
Index: PK_EMP
resc_io: 1.00resc_cpu: 8522
ix_sel: 0.071429ix_sel_with_filters: 0.071429
NL Join : Cost: 4.00Resp: 4.00Degree: 1
Cost_io: 4.00Cost_cpu: 49069
Resp_io: 4.00Resp_cpu: 49069
Access Path: index (AllEqUnique)
Index: PK_EMP
resc_io: 1.00resc_cpu: 8522
ix_sel: 0.071429ix_sel_with_filters: 0.071429
NL Join : Cost: 4.00Resp: 4.00Degree: 1
Cost_io: 4.00Cost_cpu: 49069
Resp_io: 4.00Resp_cpu: 49069
Best NL cost:4.00--NL连接成本
resc: 4.00resc_io: 4.00resc_cpu: 49069
resp: 4.00resp_io: 4.00resc_cpu: 49069
Join Card:0.158279 = outer (1.392857) * inner (1.500000) * sel (0.075758)
Join cardinality for HJ/SMJ (no post filters):0.348214, outer: 1.392857, inner: 1.500000, sel: 0.075758
Join Card - Rounded: 1 Computed: 0.16
Outer table:EMPAlias: E
resc: 3.00card 1.39bytes: 17deg: 1resp: 3.00
Inner table:EMPAlias: M
resc: 3.00card: 1.50bytes: 11deg: 1resp: 3.00
using dmeth: 2#groups: 1
SORT ressourceSort statistics
Sort width:238 Area size:208896 Max Area size:41943040
Degree:1
Blocks to Sort: 1 Row size:29 Total Rows:1
Initial runs:1 Merge passes:0 IO Cost / pass:0
Total IO sort cost: 0Total CPU sort cost: 36888889
Total Temp space used: 0
SORT ressourceSort statistics
Sort width:238 Area size:208896 Max Area size:41943040
Degree:1
Blocks to Sort: 1 Row size:23 Total Rows:2
Initial runs:1 Merge passes:0 IO Cost / pass:0
Total IO sort cost: 0Total CPU sort cost: 36888979
Total Temp space used: 0
SM join: Resc: 8.00Resp: 8.00[multiMatchCost=0.00]
SM Join
SM cost: 8.00--SM Join连接成本
resc: 8.00 resc_io: 6.00 resc_cpu: 73858932
resp: 8.00 resp_io: 6.00 resp_cpu: 73858932
Outer table:EMPAlias: E
resc: 3.00card 1.39bytes: 17deg: 1resp: 3.00
Inner table:EMPAlias: M
resc: 3.00card: 1.50bytes: 11deg: 1resp: 3.00
using dmeth: 2#groups: 1
Cost per ptn: 0.02#ptns: 1
hash_area: 124 (max=10240) buildfrag: 1probefrag: 1ppasses: 1
Hash join: Resc: 6.02Resp: 6.02[multiMatchCost=0.00]
HA Join
HA cost: 6.02--hash join连接成本
resc: 6.02 resc_io: 6.00 resc_cpu: 681414
resp: 6.02 resp_io: 6.00 resp_cpu: 681414
Best:: JoinMethod: NestedLoop
Cost: 4.00Degree: 1Resp: 4.00Card: 0.16 Bytes: 28
***********************
Best so far:Table#: 0cost: 3.0011card: 1.3929bytes: 17
Table#: 1cost: 4.0013card: 0.1583bytes: 28
***********************
Join order[2]:EMP[M]#1EMP[E]#0 --反向Join
***************
Now joining: EMP[E]#0
***************
NL Join
Outer table: Card: 1.50Cost: 3.00Resp: 3.00Degree: 1Bytes: 11
Access path analysis for EMP
Inner table: EMPAlias: E
Access Path: TableScan
NL Join:Cost: 7.00Resp: 7.00Degree: 1
Cost_io: 7.00Cost_cpu: 121612
Resp_io: 7.00Resp_cpu: 121612
Best NL cost: 7.00--NL连接成本
resc: 7.00resc_io: 7.00resc_cpu: 121612
resp: 7.00resp_io: 7.00resc_cpu: 121612
Join Card:0.158279 = outer (1.500000) * inner (1.392857) * sel (0.075758)
Join cardinality for HJ/SMJ (no post filters):0.348214, outer: 1.500000, inner: 1.392857, sel: 0.075758
Join Card - Rounded: 1 Computed: 0.16
Outer table:EMPAlias: M
resc: 3.00card 1.50bytes: 11deg: 1resp: 3.00
Inner table:EMPAlias: E
resc: 3.00card: 1.39bytes: 17deg: 1resp: 3.00
using dmeth: 2#groups: 1
SORT ressourceSort statistics
Sort width:238 Area size:208896 Max Area size:41943040
Degree:1
Blocks to Sort: 1 Row size:23 Total Rows:2
Initial runs:1 Merge passes:0 IO Cost / pass:0
Total IO sort cost: 0Total CPU sort cost: 36888979
Total Temp space used: 0
SORT ressourceSort statistics
Sort width:238 Area size:208896 Max Area size:41943040
Degree:1
Blocks to Sort: 1 Row size:29 Total Rows:1
Initial runs:1 Merge passes:0 IO Cost / pass:0
Total IO sort cost: 0Total CPU sort cost: 36888889
Total Temp space used: 0
SM join: Resc: 8.00Resp: 8.00[multiMatchCost=0.00]
SM Join
SM cost: 8.00--SM Join连接成本
resc: 8.00 resc_io: 6.00 resc_cpu: 73858932
resp: 8.00 resp_io: 6.00 resp_cpu: 73858932
Outer table:EMPAlias: M
resc: 3.00card 1.50bytes: 11deg: 1resp: 3.00
Inner table:EMPAlias: E
resc: 3.00card: 1.39bytes: 17deg: 1resp: 3.00
using dmeth: 2#groups: 1
Cost per ptn: 0.02#ptns: 1
hash_area: 124 (max=10240) buildfrag: 1probefrag: 1ppasses: 1
Hash join: Resc: 6.02Resp: 6.02[multiMatchCost=0.00]
HA Join
HA cost: 6.02--Hash Join连接成本
resc: 6.02 resc_io: 6.00 resc_cpu: 681464
resp: 6.02 resp_io: 6.00 resp_cpu: 681464
Join order aborted: cost > best plan cost
***********************
(newjo-stop-1) k:0, spcnt:0, perm:2, maxperm:2000
*********************************
Number of join permutations tried: 2
*********************************
Consider using bloom filter between E[EMP] and M[EMP] 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 E[EMP](serial) and M[EMP](serial); jm = 12; right side access path = IndexUnique
---- NLJ default -> BROADCAST-LEFT
(newjo-save)[1 0 ]
Trying or-Expansion on query block SEL$1 (#0)
Transfer Optimizer annotations for query block SEL$1 (#0)
id=0 frofand predicate="E"."DEPTNO"=10 AND "E"."SAL">1500 AND "E"."MGR" IS NOT NULL
id=0 frofkks[i] (index start key) predicate="E"."MGR"="M"."EMPNO"
id=0 frofkke[i] (index stop key) predicate="E"."MGR"="M"."EMPNO"
id=0 frofand predicate="M"."DEPTNO"=10 AND "M"."SAL">1500 AND "M"."SAL">"E"."SAL"
Final cost for query block SEL$1 (#0) - All Rows Plan:
Best join order: 1
Cost: 4.0013Degree: 1Card: 1.0000Bytes: 28
Resc: 4.0013Resc_io: 4.0000Resc_cpu: 49069
Resp: 4.0013Resp_io: 4.0000Resc_cpu: 49069
kkoqbc-subheap (delete addr=0x7fadccebfa10, in-use=45504, alloc=49272)
kkoqbc-end:
:
call(in-use=14008, alloc=82128), compile(in-use=92984, alloc=94248), execution(in-use=3336, alloc=4032)
kkoqbc: finish optimizing query block SEL$1 (#0)
apadrv-end
:
call(in-use=14008, alloc=82128), compile(in-use=93968, alloc=94248), execution(in-use=3336, alloc=4032)
CBRID: M @ SEL$1 NLJBatching allocation - Failure - : disabled by parameter
CBRID: M @ SEL$1 TableLookup allocation - Failure - : disabled by parameter
Starting SQL statement dump
user_id=83 user_name=SCOTT module=SQL*Plus action=
sql_id=4usswnngj0jdx plan_hash_value=-939914904 problem_type=3
----- Current SQL Statement for this session (sql_id=4usswnngj0jdx) -----
select /*sample 1*/e.ename
from emp e, emp m
where e.mgr=m.empno
and m.deptno = 10
and e.deptno = m.deptno
and e.sal>1500
and m.sal>e.sal
sql_text_length=138
sql=select /*sample 1*/e.ename
from emp e, emp m
where e.mgr=m.empno
and m.deptno = 10
and e.deptno = m.deptno
and e.sal>1500
and m.sal>e.sal
----- Explain Plan Dump -----
----- Plan Table -----
============
Plan Table
============
------------------------------------------------+-----------------------------------+
| Id| Operation| Name| Rows| Bytes | Cost| Time|
------------------------------------------------+-----------------------------------+
| 0| SELECT STATEMENT||||4 ||
| 1|NESTED LOOPS||1 |28 |4 |00:00:01 |
| 2|NESTED LOOPS||1 |28 |4 |00:00:01 |
| 3|TABLE ACCESS FULL| EMP|1 |17 |3 |00:00:01 |
| 4|INDEX UNIQUE SCAN| PK_EMP|1 ||0 ||
| 5|TABLE ACCESS BY INDEX ROWID | EMP|1 |11 |1 |00:00:01 |
------------------------------------------------+-----------------------------------+
Predicate Information:
----------------------
3 - filter(("E"."DEPTNO"=10 AND "E"."SAL">1500 AND "E"."MGR" IS NOT NULL))
4 - access("E"."MGR"="M"."EMPNO")
5 - filter(("M"."DEPTNO"=10 AND "M"."SAL">1500 AND "M"."SAL">"E"."SAL"))
Content of other_xml column
===========================
db_version: 11.2.0.4
parse_schema: SCOTT
plan_hash: 3355052392
plan_hash_2: 3958047811
Outline Data: --一般可以用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")
FULL(@"SEL$1" "E"@"SEL$1")--E表全表扫描full
INDEX(@"SEL$1" "M"@"SEL$1" ("EMP"."EMPNO"))--M表索引扫描index
LEADING(@"SEL$1" "E"@"SEL$1" "M"@"SEL$1")--E表驱动M表
USE_NL(@"SEL$1" "M"@"SEL$1")--连接方式nl
NLJ_BATCHING(@"SEL$1" "M"@"SEL$1")
END_OUTLINE_DATA
*/
Optimizer state dump:
Compilation Environment Dump
optimizer_mode_hinted= false
optimizer_features_hinted= 0.0.0
parallel_execution_enabled= true
parallel_query_forced_dop= 0
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= 204800 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= 204 KB
_smm_max_size_static= 40960 KB
_smm_px_max_size_static= 102400 KB
_cpu_to_io= 0
_optimizer_undo_cost_change= 11.2.0.4
parallel_query_mode= enabled
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
parallel_query_default_dop= 0
is_recur_flags= 0
optimizer_use_invisible_indexes= false
flashback_data_archive_internal_cursor = 0
_optimizer_extended_stats_usage_control = 192
_parallel_syspls_obey_force= true
cell_offload_processing= true
_rdbms_internal_fplib_enabled= false
db_file_multiblock_read_count= 128
_bloom_folding_enabled= true
_mv_generalized_oj_refresh_opt= true
cell_offload_compaction= ADAPTIVE
cell_offload_plan_display= AUTO
_bloom_predicate_pushdown_to_storage = true
_bloom_vector_elements= 0
_bloom_pushing_max= 512
parallel_degree_limit= 65535
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
fix3834770 = 1
fix3746511 = enabled
fix4519016 = enabled
fix3118776 = enabled
fix4488689 = enabled
fix2194204 = disabled
fix2660592 = enabled
fix2320291 = enabled
fix2324795 = enabled
fix4308414 = enabled
fix3499674 = disabled
fix4569940 = enabled
fix4631959 = enabled
fix4519340 = enabled
fix4550003 = enabled
fix1403283 = enabled
fix4554846 = enabled
fix4602374 = enabled
fix4584065 = enabled
fix4545833 = enabled
fix4611850 = enabled
fix4663698 = enabled
fix4663804 = enabled
fix4666174 = enabled
fix4567767 = enabled
fix4556762 = 15
fix4728348 = enabled
fix4708389 = enabled
fix4175830 = enabled
fix4752814 = enabled
fix4583239 = enabled
fix4386734 = enabled
fix4887636 = enabled
fix4483240 = enabled
fix4872602 = disabled
fix4711525 = enabled
fix4545802 = enabled
fix4605810 = enabled
fix4704779 = enabled
fix4900129 = enabled
fix4924149 = enabled
fix4663702 = enabled
fix4878299 = enabled
fix4658342 = enabled
fix4881533 = enabled
fix4676955 = enabled
fix4273361 = enabled
fix4967068 = enabled
fix4969880 = disabled
fix5005866 = enabled
fix5015557 = enabled
fix4705343 = enabled
fix4904838 = enabled
fix4716096 = enabled
fix4483286 = disabled
fix4722900 = enabled
fix4615392 = enabled
fix5096560 = enabled
fix5029464 = enabled
fix4134994 = enabled
fix4904890 = enabled
fix5104624 = enabled
fix5014836 = enabled
fix4768040 = enabled
fix4600710 = enabled
fix5129233 = enabled
fix4595987 = enabled
fix4908162 = enabled
fix5139520 = enabled
fix5084239 = enabled
fix5143477 = disabled
fix2663857 = enabled
fix4717546 = enabled
fix5240264 = disabled
fix5099909 = enabled
fix5240607 = enabled
fix5195882 = enabled
fix5220356 = enabled
fix5263572 = enabled
fix5385629 = enabled
fix5302124 = enabled
fix5391942 = enabled
fix5384335 = enabled
fix5482831 = enabled
fix4158812 = enabled
fix5387148 = enabled
fix5383891 = enabled
fix5466973 = enabled
fix5396162 = enabled
fix5394888 = enabled
fix5395291 = enabled
fix5236908 = enabled
fix5509293 = enabled
fix5449488 = enabled
fix5567933 = enabled
fix5570494 = enabled
fix5288623 = enabled
fix5505995 = enabled
fix5505157 = enabled
fix5112460 = enabled
fix5554865 = enabled
fix5112260 = enabled
fix5112352 = enabled
fix5547058 = enabled
fix5618040 = enabled
fix5585313 = enabled
fix5547895 = enabled
fix5634346 = enabled
fix5620485 = enabled
fix5483301 = enabled
fix5657044 = enabled
fix5694984 = enabled
fix5868490 = enabled
fix5650477 = enabled
fix5611962 = enabled
fix4279274 = enabled
fix5741121 = enabled
fix5714944 = enabled
fix5391505 = enabled
fix5762598 = enabled
fix5578791 = enabled
fix5259048 = enabled
fix5882954 = enabled
fix2492766 = enabled
fix5707608 = enabled
fix5891471 = enabled
fix5884780 = enabled
fix5680702 = enabled
fix5371452 = enabled
fix5838613 = enabled
fix5949981 = enabled
fix5624216 = enabled
fix5741044 = enabled
fix5976822 = enabled
fix6006457 = enabled
fix5872956 = enabled
fix5923644 = enabled
fix5943234 = enabled
fix5844495 = enabled
fix4168080 = enabled
fix6020579 = enabled
fix5842686 = disabled
fix5996801 = enabled
fix5593639 = enabled
fix6133948 = enabled
fix3151991 = enabled
fix6146906 = enabled
fix6239909 = enabled
fix6267621 = enabled
fix5909305 = enabled
fix6279918 = enabled
fix6141818 = enabled
fix6151963 = enabled
fix6251917 = enabled
fix6282093 = enabled
fix6119510 = enabled
fix6119382 = enabled
fix3801750 = enabled
fix5705630 = disabled
fix5944076 = enabled
fix5406763 = enabled
fix6070954 = enabled
fix6282944 = enabled
fix6138746 = enabled
fix6082745 = enabled
fix3426050 = enabled
fix599680 = enabled
fix6062266 = enabled
fix6087237 = enabled
fix6122894 = enabled
fix6377505 = enabled
fix5893768 = enabled
fix6163564 = enabled
fix6073325 = enabled
fix6188881 = enabled
fix6007259 = enabled
fix6239971 = enabled
fix5284200 = disabled
fix6042205 = enabled
fix6051211 = enabled
fix6434668 = enabled
fix6438752 = enabled
fix5936366 = enabled
fix6439032 = enabled
fix6438892 = enabled
fix6006300 = enabled
fix5947231 = enabled
fix5416118 = 1
fix6365442 = 1
fix6239039 = enabled
fix6502845 = enabled
fix6913094 = enabled
fix6029469 = enabled
fix5919513 = enabled
fix6057611 = enabled
fix6469667 = enabled
fix6608941 = disabled
fix6368066 = enabled
fix6329318 = enabled
fix6656356 = enabled
fix4507997 = enabled
fix6671155 = enabled
fix6694548 = enabled
fix6688200 = enabled
fix6612471 = enabled
fix6708183 = disabled
fix6326934 = enabled
fix6520717 = disabled
fix6714199 = enabled
fix6681545 = enabled
fix6748058 = enabled
fix6167716 = enabled
fix6674254 = enabled
fix6468287 = enabled
fix6503543 = enabled
fix6808773 = disabled
fix6766962 = enabled
fix6120483 = enabled
fix6670551 = enabled
fix6771838 = enabled
fix6626018 = disabled
fix6530596 = enabled
fix6778642 = enabled
fix6699059 = enabled
fix6376551 = enabled
fix6429113 = enabled
fix6782437 = enabled
fix6776808 = enabled
fix6765823 = enabled
fix6768660 = enabled
fix6782665 = enabled
fix6610822 = enabled
fix6514189 = enabled
fix6818410 = enabled
fix6827696 = enabled
fix6773613 = enabled
fix5902962 = enabled
fix6956212 = enabled
fix3056297 = enabled
fix6440977 = disabled
fix6972291 = disabled
fix6904146 = enabled
fix6221403 = enabled
fix5475051 = enabled
fix6845871 = enabled
fix5468809 = enabled
fix6917633 = enabled
fix4444536 = disabled
fix6955210 = enabled
fix6994194 = enabled
fix6399597 = disabled
fix6951776 = enabled
fix5648287 = 3
fix6987082 = disabled
fix7132036 = enabled
fix6980350 = enabled
fix5199213 = enabled
fix7138405 = enabled
fix7148689 = enabled
fix6820988 = enabled
fix7032684 = enabled
fix6617866 = enabled
fix7155968 = enabled
fix7127980 = enabled
fix6982954 = enabled
fix7241819 = enabled
fix6897034 = enabled
fix7236148 = enabled
fix7298570 = enabled
fix7249095 = enabled
fix7314499 = enabled
fix7324224 = enabled
fix7289023 = enabled
fix7237571 = enabled
fix7116357 = enabled
fix7345484 = enabled
fix7375179 = enabled
fix6430500 = disabled
fix5897486 = enabled
fix6774209 = enabled
fix7306637 = enabled
fix6451322 = enabled
fix7208131 = enabled
fix7388652 = enabled
fix7127530 = enabled
fix6751206 = enabled
fix6669103 = enabled
fix7430474 = enabled
fix6990305 = enabled
fix7043307 = enabled
fix3120429 = enabled
fix7452823 = disabled
fix6838105 = enabled
fix6769711 = enabled
fix7170213 = enabled
fix6528872 = enabled
fix7295298 = enabled
fix5922070 = enabled
fix7259468 = enabled
fix6418552 = enabled
fix4619997 = enabled
fix7524366 = enabled
fix6942476 = enabled
fix6418771 = enabled
fix7375077 = enabled
fix5400639 = enabled
fix4570921 = enabled
fix7426911 = enabled
fix5099019 = disabled
fix7528216 = enabled
fix7521266 = enabled
fix7385140 = enabled
fix7576516 = enabled
fix7573526 = enabled
fix7576476 = enabled
fix7165898 = enabled
fix7263214 = enabled
fix330 = enabled
fix7555510 = enabled
fix7613118 = enabled
fix7597059 = enabled
fix7558911 = enabled
fix5520732 = enabled
fix7679490 = disabled
fix7449971 = enabled
fix3628118 = enabled
fix4370840 = enabled
fix7281191 = enabled
fix7519687 = enabled
fix5029592 = 3
fix6012093 = 1
fix6053861 = disabled
fix6941515 = disabled
fix7696414 = enabled
fix7272039 = enabled
fix7834811 = enabled
fix7640597 = enabled
fix7341616 = enabled
fix7168184 = enabled
fix399198 = enabled
fix7831070 = enabled
fix7676897 = disabled
fix7414637 = enabled
fix7585456 = enabled
fix8202421 = enabled
fix7658097 = disabled
fix8251486 = enabled
fix7132684 = enabled
fix7512227 = enabled
fix6972987 = enabled
fix7199035 = enabled
fix8243446 = enabled
fix7650462 = enabled
fix6720701 = enabled
fix7592673 = enabled
fix7718694 = enabled
fix7534027 = enabled
fix7708267 = enabled
fix5716785 = enabled
fix7356191 = enabled
fix7679161 = enabled
fix7597159 = enabled
fix7499258 = enabled
fix8328363 = enabled
fix7452863 = enabled
fix8284930 = enabled
fix7298626 = enabled
fix7657126 = enabled
fix8371884 = enabled
fix8318020 = enabled
fix8255423 = enabled
fix7135745 = enabled
fix8356253 = enabled
fix7534257 = enabled
fix8323407 = enabled
fix7539815 = enabled
fix8289316 = enabled
fix8447850 = enabled
fix7675944 = enabled
fix8355120 = enabled
fix7176746 = enabled
fix8442891 = enabled
fix8373261 = enabled
fix7679164 = enabled
fix7670533 = enabled
fix8408665 = enabled
fix8491399 = enabled
fix8348392 = enabled
fix8348585 = enabled
fix8508056 = enabled
fix8335178 = enabled
fix8515269 = enabled
fix8247017 = enabled
fix7325597 = enabled
fix8531490 = enabled
fix6163600 = enabled
fix8589278 = disabled
fix8557992 = enabled
fix7556098 = enabled
fix8580883 = enabled
fix5892599 = disabled
fix8609714 = enabled
fix8619631 = disabled
fix8672915 = enabled
fix8514561 = enabled
fix8213977 = enabled
fix8560951 = disabled
fix8578587 = enabled
fix8287870 = enabled
fix8467123 = enabled
fix8602185 = enabled
fix8519457 = enabled
fix3335182 = enabled
fix8602840 = enabled
fix8725296 = enabled
fix8628970 = enabled
fix6754080 = enabled
fix8767442 = enabled
fix8760135 = enabled
fix8644935 = enabled
fix8352378 = enabled
fix8685327 = enabled
fix8763472 = enabled
fix8773324 = enabled
fix8813674 = enabled
fix8532236 = enabled
fix8629716 = enabled
fix7277732 = enabled
fix8692170 = enabled
fix8900973 = enabled
fix8919133 = enabled
fix8927050 = enabled
fix8551880 = enabled
fix8901237 = enabled
fix8812372 = enabled
fix6236862 = enabled
fix8528517 = enabled
fix7215982 = enabled
fix8214022 = enabled
fix8595392 = enabled
fix8890233 = enabled
fix8999317 = enabled
fix9004800 = enabled
fix8986163 = enabled
fix8855396 = enabled
fix8800514 = 20
fix9007859 = enabled
fix8198783 = disabled
fix9053879 = enabled
fix6086930 = enabled
fix7641601 = enabled
fix9052506 = enabled
fix9103775 = enabled
fix9047975 = enabled
fix8893626 = enabled
fix9111170 = enabled
fix8971829 = enabled
fix7628358 = enabled
fix9125151 = enabled
fix9039715 = enabled
fix9106224 = enabled
fix9185228 = enabled
fix9206747 = enabled
fix9088510 = enabled
fix9143856 = enabled
fix8833381 = enabled
fix8949971 = enabled
fix8951812 = enabled
fix9148171 = enabled
fix8706652 = enabled
fix9245114 = enabled
fix8802198 = enabled
fix9011016 = enabled
fix9265681 = enabled
fix7284269 = enabled
fix9272549 = enabled
fix8917507 = 7
fix8531463 = enabled
fix9263333 = enabled
fix8675087 = enabled
fix8571403 = enabled
fix8896955 = enabled
fix9041934 = enabled
fix9344709 = enabled
fix9024933 = enabled
fix9033718 = enabled
fix9240455 = enabled
fix9081848 = enabled
fix5982893 = enabled
fix9287401 = enabled
fix8590021 = enabled
fix9340120 = enabled
fix9355794 = enabled
fix9356656 = enabled
fix9385634 = enabled
fix9069046 = enabled
fix9239337 = enabled
fix9300228 = enabled
fix9298010 = enabled
fix9384170 = enabled
fix9301862 = disabled
fix9407929 = enabled
fix8836806 = enabled
fix9344055 = enabled
fix9274675 = enabled
fix9203723 = enabled
fix9443476 = enabled
fix9195582 = enabled
fix8226666 = enabled
fix9433490 = enabled
fix9065494 = enabled
fix9303766 = enabled
fix9437283 = enabled
fix9116214 = enabled
fix9456688 = enabled
fix9456746 = disabled
fix9342979 = enabled
fix9465425 = enabled
fix9092442 = enabled
fix4926618 = enabled
fix8792846 = enabled
fix9474259 = enabled
fix9495669 = disabled
fix6472966 = enabled
fix6408301 = enabled
fix9380298 = disabled
fix8500130 = enabled
fix9584723 = enabled
fix9270951 = enabled
fix9508254 = enabled
fix9593680 = enabled
fix9196440 = disabled
fix9309281 = enabled
fix8693158 = enabled
fix9381638 = enabled
fix9383967 = enabled
fix7711900 = enabled
fix9218587 = enabled
fix9728438 = enabled
fix9038395 = enabled
fix9577300 = enabled
fix9171113 = enabled
fix8973745 = enabled
fix9732434 = enabled
fix8937971 = disabled
fix9102474 = enabled
fix9243499 = enabled
fix9912503 = enabled
fix9153459 = enabled
fix9762592 = 3
fix9785632 = enabled
fix9659125 = 0
fix9702850 = enabled
fix9958518 = enabled
fix8349119 = enabled
fix 10041074 = enabled
fix 10134677 = enabled
fix9716877 = enabled
fix8961143 = enabled
fix 10080014 = enabled
fix 10026972 = enabled
fix9476520 = enabled
fix9841679 = enabled
fix 10004943 = enabled
fix9791810 = enabled
fix9668086 = enabled
fix9850461 = enabled
fix9940732 = enabled
fix9578670 = enabled
fix 10197666 = enabled
fix9630092 = disabled
fix 10271790 = enabled
fix 10015652 = enabled
fix8274946 = enabled
fix 10192889 = enabled
fix 10336499 = disabled
fix9814067 = enabled
fix 10158107 = enabled
fix 10182051 = 3
fix 10376744 = enabled
fix 10043801 = enabled
fix9832338 = disabled
fix9002661 = enabled
fix9898066 = enabled
fix9569678 = enabled
fix 11741436 = enabled
fix 10232623 = enabled
fix 10232225 = enabled
fix9829887 = enabled
fix 10359631 = enabled
fix8275054 = enabled
fix 10640430 = enabled
fix 10227392 = enabled
fix 10117760 = enabled
fix9554026 = disabled
fix9593547 = disabled
fix9833381 = disabled
fix9881812 = enabled
fix 10333395 = enabled
fix9776736 = enabled
fix9748015 = enabled
fix 11744086 = enabled
fix 11834739 = enabled
fix 11830663 = enabled
fix 11877160 = enabled
fix9227576 = enabled
fix 11814428 = enabled
fix 11843512 = enabled
fix 11853331 = enabled
fix6055658 = enabled
fix 11657468 = enabled
fix 1178 = enabled
fix 10428278 = enabled
fix8275023 = enabled
fix 11740670 = enabled
fix9477688 = enabled
fix9980661 = enabled
fix 11676888 = disabled
fix 10623119 = enabled
fix 10162430 = enabled
fix 10330090 = enabled
fix9680430 = 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
fix7147087 = enabled
fix 11846314 = enabled
fix 12432426 = enabled
fix 12584007 = enabled
fix8683604 = enabled
fix 12432089 = enabled
fix 12591120 = enabled
fix 11876260 = enabled
fix9913117 = enabled
fix 12348584 = enabled
fix 1040 = enabled
fix3639130 = 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
fix6923730 = 0
fix 13634700 = enabled
fix 12828479 = enabled
fix 11689541 = enabled
fix9547706 = 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
fix2273284 = enabled
fix 13454409 = enabled
fix 12728203 = enabled
fix 13065064 = enabled
fix 13616573 = enabled
fix 11858963 = enabled
fix 13929275 = enabled
fix8792821 = 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
fix9891396 = enabled
fix 13321547 = enabled
fix 13486825 = enabled
fix7271518 = 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
fix4215125 = 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
fix3566843 = enabled
fix9550277 = disabled
fix6873091 = enabled
fix 14467202 = enabled
fix 14541122 = enabled
fix 14098180 = enabled
fix 14243782 = enabled
fix 13255388 = 10
fix 11727871 = enabled
fix9633142 = disabled
fix 12869367 = enabled
fix 14055128 = enabled
fix 13652216 = enabled
fix 13849486 = enabled
fix 14008590 = enabled
fix 13594757 = enabled
fix9114915 = 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
fix9094254 = enabled
fix 13104618 = enabled
fix 12942119 = enabled
fix 14256885 = enabled
fix 13943459 = enabled
fix 13263174 = enabled
fix 14311185 = enabled
fix 14795969 = enabled
fix9971371 = 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 1437 = enabled
fix 13083139 = enabled
fix6520878 = enabled
fix 1336 = 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
fix9858777 = 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$1 0xcceb2550 (PARSER) [FINAL]
:
call(in-use=23136, alloc=82128), compile(in-use=133400, alloc=195152), execution(in-use=13256, alloc=16200)
End of Optimizer State Dump
Dumping Hints
=============
====================== END SQL Statement Dump ======================
如果觉得《Oracle CBO Transformation-FPD(filter push-down)》对你有帮助,请点赞、收藏,并留下你的观点哦!