1. Trace file /app/ora/local/admin/TEST1102/diag/rdbms/TEST1102_doug/TEST1102/trace/TEST1102_ora_1450_DOUG_TEST2.trc
  2. Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
  3. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  4. and Real Application Testing options
  5. ORACLE_HOME = /app/ora/local/product/11.2.0.2/db_4
  6. System name:    Linux
  7. Node name:      doug
  8. Release:        2.6.18-194.11.4.el5
  9. Version:        #1 SMP Fri Sep 17 04:57:05 EDT 2010
  10. Machine:        x86_64
  11. Instance name: TEST1102
  12. Redo thread mounted by this instance: 1
  13. Oracle process number: 52
  14. Unix process pid: 1450, image: oracle@doug
  15. *** 2013-03-18 10:59:58.774
  16. *** SESSION ID:(139.79) 2013-03-18 10:59:58.774
  17. *** CLIENT ID:() 2013-03-18 10:59:58.774
  18. *** SERVICE NAME:(SYS$USERS) 2013-03-18 10:59:58.774
  19. *** MODULE NAME:(TOAD 10.6.1.3) 2013-03-18 10:59:58.774
  20. *** ACTION NAME:() 2013-03-18 10:59:58.774
  21. Registered qb: SEL$1 0xad486a80 (PARSER)
  22. ---------------------
  23. QUERY BLOCK SIGNATURE
  24. ---------------------
  25.   signature (): qb_name=SEL$1 nbfros=1 flg=0
  26.     fro(0): flg=4 objn=116 hint_alias="DUAL"@"SEL$1"
  27. SPM: statement not found in SMB
  28. **************************
  29. Automatic degree of parallelism (ADOP)
  30. **************************
  31. Automatic degree of parallelism is disabled: Parameter.
  32. PM: Considering predicate move-around in query block SEL$1 (#0)
  33. **************************
  34. Predicate Move-Around (PM)
  35. **************************
  36. OPTIMIZER INFORMATION
  37. ******************************************
  38. ----- Current SQL Statement for this session (sql_id=a5ks9fhw2v9s1) -----
  39. select * from dual
  40. *******************************************
  41. Legend
  42. The following abbreviations are used by optimizer trace.
  43. CBQT - cost-based query transformation
  44. JPPD - join predicate push-down
  45. OJPPD - old-style (non-cost-based) JPPD
  46. FPD - filter push-down
  47. PM - predicate move-around
  48. CVM - complex view merging
  49. SPJ - select-project-join
  50. SJC - set join conversion
  51. SU - subquery unnesting
  52. OBYE - order by elimination
  53. OST - old style star transformation
  54. ST - new (cbqt) star transformation
  55. CNT - count(col) to count(*) transformation
  56. JE - Join Elimination
  57. JF - join factorization
  58. SLP - select list pruning
  59. DP - distinct placement
  60. qb - query block
  61. LB - leaf blocks
  62. DK - distinct keys
  63. LB/K - average number of leaf blocks per key
  64. DB/K - average number of data blocks per key
  65. CLUF - clustering factor
  66. NDV - number of distinct values
  67. Resp - response cost
  68. Card - cardinality
  69. Resc - resource cost
  70. NL - nested loops (join)
  71. SM - sort merge (join)
  72. HA - hash (join)
  73. CPUSPEED - CPU Speed
  74. IOTFRSPEED - I/O transfer speed
  75. IOSEEKTIM - I/O seek time
  76. SREADTIM - average single block read time
  77. MREADTIM - average multiblock read time
  78. MBRC - average multiblock read count
  79. MAXTHR - maximum I/O system throughput
  80. SLAVETHR - average slave I/O throughput
  81. dmeth - distribution method
  82.   1: no partitioning required
  83.   2: value partitioned
  84.   4: right is random (round-robin)
  85.   128: left is random (round-robin)
  86.   8: broadcast right and partition left
  87.   16: broadcast left and partition right
  88.   32: partition left using partitioning of right
  89.   64: partition right using partitioning of left
  90.   256: run the join in serial
  91.   0: invalid distribution method
  92. sel - selectivity
  93. ptn - partition
  94. ***************************************
  95. PARAMETERS USED BY THE OPTIMIZER
  96. ********************************
  97.   *************************************
  98.   PARAMETERS WITH ALTERED VALUES
  99.   ******************************
  100. Compilation Environment Dump
  101. _pga_max_size                       = 2097152 KB
  102. db_file_multiblock_read_count       = 32
  103. Bug Fix Control Environment
  104.   *************************************
  105.   PARAMETERS WITH DEFAULT VALUES
  106.   ******************************
  107. Compilation Environment Dump
  108. optimizer_mode_hinted               = false
  109. optimizer_features_hinted           = 0.0.0
  110. parallel_execution_enabled          = true
  111. parallel_query_forced_dop           = 0
  112. parallel_dml_forced_dop             = 0
  113. parallel_ddl_forced_degree          = 0
  114. parallel_ddl_forced_instances       = 0
  115. _query_rewrite_fudge                = 90
  116. optimizer_features_enable           = 11.2.0.2
  117. _optimizer_search_limit             = 5
  118. cpu_count                           = 24
  119. active_instance_count               = 1
  120. parallel_threads_per_cpu            = 2
  121. hash_area_size                      = 131072
  122. bitmap_merge_area_size              = 1048576
  123. sort_area_size                      = 65536
  124. sort_area_retained_size             = 0
  125. _sort_elimination_cost_ratio        = 0
  126. _optimizer_block_size               = 16384
  127. _sort_multiblock_read_count         = 2
  128. _hash_multiblock_io_count           = 0
  129. _db_file_optimizer_read_count       = 32
  130. _optimizer_max_permutations         = 2000
  131. pga_aggregate_target                = 41943040 KB
  132. _query_rewrite_maxdisjunct          = 257
  133. _smm_auto_min_io_size               = 48 KB
  134. _smm_auto_max_io_size               = 240 KB
  135. _smm_min_size                       = 1024 KB
  136. _smm_max_size                       = 1048576 KB
  137. _smm_px_max_size                    = 20971520 KB
  138. _cpu_to_io                          = 0
  139. _optimizer_undo_cost_change         = 11.2.0.2
  140. parallel_query_mode                 = enabled
  141. parallel_dml_mode                   = disabled
  142. parallel_ddl_mode                   = enabled
  143. optimizer_mode                      = all_rows
  144. sqlstat_enabled                     = false
  145. _optimizer_percent_parallel         = 101
  146. _always_anti_join                   = choose
  147. _always_semi_join                   = choose
  148. _optimizer_mode_force               = true
  149. _partition_view_enabled             = true
  150. _always_star_transformation         = false
  151. _query_rewrite_or_error             = false
  152. _hash_join_enabled                  = true
  153. cursor_sharing                      = exact
  154. _b_tree_bitmap_plans                = true
  155. star_transformation_enabled         = false
  156. _optimizer_cost_model               = choose
  157. _new_sort_cost_estimate             = true
  158. _complex_view_merging               = true
  159. _unnest_subquery                    = true
  160. _eliminate_common_subexpr           = true
  161. _pred_move_around                   = true
  162. _convert_set_to_join                = false
  163. _push_join_predicate                = true
  164. _push_join_union_view               = true
  165. _fast_full_scan_enabled             = true
  166. _optim_enhance_nnull_detection      = true
  167. _parallel_broadcast_enabled         = true
  168. _px_broadcast_fudge_factor          = 100
  169. _ordered_nested_loop                = true
  170. _no_or_expansion                    = false
  171. optimizer_index_cost_adj            = 100
  172. optimizer_index_caching             = 0
  173. _system_index_caching               = 0
  174. _disable_datalayer_sampling         = false
  175. query_rewrite_enabled               = true
  176. query_rewrite_integrity             = enforced
  177. _query_cost_rewrite                 = true
  178. _query_rewrite_2                    = true
  179. _query_rewrite_1                    = true
  180. _query_rewrite_expression           = true
  181. _query_rewrite_jgmigrate            = true
  182. _query_rewrite_fpc                  = true
  183. _query_rewrite_drj                  = true
  184. _full_pwise_join_enabled            = true
  185. _partial_pwise_join_enabled         = true
  186. _left_nested_loops_random           = true
  187. _improved_row_length_enabled        = true
  188. _index_join_enabled                 = true
  189. _enable_type_dep_selectivity        = true
  190. _improved_outerjoin_card            = true
  191. _optimizer_adjust_for_nulls         = true
  192. _optimizer_degree                   = 0
  193. _use_column_stats_for_function      = true
  194. _subquery_pruning_enabled           = true
  195. _subquery_pruning_mv_enabled        = false
  196. _or_expand_nvl_predicate            = true
  197. _like_with_bind_as_equality         = false
  198. _table_scan_cost_plus_one           = true
  199. _cost_equality_semi_join            = true
  200. _default_non_equality_sel_check     = true
  201. _new_initial_join_orders            = true
  202. _oneside_colstat_for_equijoins      = true
  203. _optim_peek_user_binds              = true
  204. _minimal_stats_aggregation          = true
  205. _force_temptables_for_gsets         = false
  206. workarea_size_policy                = auto
  207. _smm_auto_cost_enabled              = true
  208. _gs_anti_semi_join_allowed          = true
  209. _optim_new_default_join_sel         = true
  210. optimizer_dynamic_sampling          = 2
  211. _pre_rewrite_push_pred              = true
  212. _optimizer_new_join_card_computation = true
  213. _union_rewrite_for_gs               = yes_gset_mvs
  214. _generalized_pruning_enabled        = true
  215. _optim_adjust_for_part_skews        = true
  216. _force_datefold_trunc               = false
  217. statistics_level                    = typical
  218. _optimizer_system_stats_usage       = true
  219. skip_unusable_indexes               = true
  220. _remove_aggr_subquery               = true
  221. _optimizer_push_down_distinct       = 0
  222. _dml_monitoring_enabled             = true
  223. _optimizer_undo_changes             = false
  224. _predicate_elimination_enabled      = true
  225. _nested_loop_fudge                  = 100
  226. _project_view_columns               = true
  227. _local_communication_costing_enabled = true
  228. _local_communication_ratio          = 50
  229. _query_rewrite_vop_cleanup          = true
  230. _slave_mapping_enabled              = true
  231. _optimizer_cost_based_transformation = linear
  232. _optimizer_mjc_enabled              = true
  233. _right_outer_hash_enable            = true
  234. _spr_push_pred_refspr               = true
  235. _optimizer_cache_stats              = false
  236. _optimizer_cbqt_factor              = 50
  237. _optimizer_squ_bottomup             = true
  238. _fic_area_size                      = 131072
  239. _optimizer_skip_scan_enabled        = true
  240. _optimizer_cost_filter_pred         = false
  241. _optimizer_sortmerge_join_enabled   = true
  242. _optimizer_join_sel_sanity_check    = true
  243. _mmv_query_rewrite_enabled          = true
  244. _bt_mmv_query_rewrite_enabled       = true
  245. _add_stale_mv_to_dependency_list    = true
  246. _distinct_view_unnesting            = false
  247. _optimizer_dim_subq_join_sel        = true
  248. _optimizer_disable_strans_sanity_checks = 0
  249. _optimizer_compute_index_stats      = true
  250. _push_join_union_view2              = true
  251. _optimizer_ignore_hints             = false
  252. _optimizer_random_plan              = 0
  253. _query_rewrite_setopgrw_enable      = true
  254. _optimizer_correct_sq_selectivity   = true
  255. _disable_function_based_index       = false
  256. _optimizer_join_order_control       = 3
  257. _optimizer_cartesian_enabled        = true
  258. _optimizer_starplan_enabled         = true
  259. _extended_pruning_enabled           = true
  260. _optimizer_push_pred_cost_based     = true
  261. _optimizer_null_aware_antijoin      = true
  262. _optimizer_extend_jppd_view_types   = true
  263. _sql_model_unfold_forloops          = run_time
  264. _enable_dml_lock_escalation         = false
  265. _bloom_filter_enabled               = true
  266. _update_bji_ipdml_enabled           = 0
  267. _optimizer_extended_cursor_sharing  = udo
  268. _dm_max_shared_pool_pct             = 1
  269. _optimizer_cost_hjsmj_multimatch    = true
  270. _optimizer_transitivity_retain      = true
  271. _px_pwg_enabled                     = true
  272. optimizer_secure_view_merging       = true
  273. _optimizer_join_elimination_enabled = true
  274. flashback_table_rpi                 = non_fbt
  275. _optimizer_cbqt_no_size_restriction = true
  276. _optimizer_enhanced_filter_push     = true
  277. _optimizer_filter_pred_pullup       = true
  278. _rowsrc_trace_level                 = 0
  279. _simple_view_merging                = true
  280. _optimizer_rownum_pred_based_fkr    = true
  281. _optimizer_better_inlist_costing    = all
  282. _optimizer_self_induced_cache_cost  = false
  283. _optimizer_min_cache_blocks         = 10
  284. _optimizer_or_expansion             = depth
  285. _optimizer_order_by_elimination_enabled = true
  286. _optimizer_outer_to_anti_enabled    = true
  287. _selfjoin_mv_duplicates             = true
  288. _dimension_skip_null                = true
  289. _force_rewrite_enable               = false
  290. _optimizer_star_tran_in_with_clause = true
  291. _optimizer_complex_pred_selectivity = true
  292. _optimizer_connect_by_cost_based    = true
  293. _gby_hash_aggregation_enabled       = true
  294. _globalindex_pnum_filter_enabled    = true
  295. _px_minus_intersect                 = true
  296. _fix_control_key                    = 0
  297. _force_slave_mapping_intra_part_loads = false
  298. _force_tmp_segment_loads            = false
  299. _query_mmvrewrite_maxpreds          = 10
  300. _query_mmvrewrite_maxintervals      = 5
  301. _query_mmvrewrite_maxinlists        = 5
  302. _query_mmvrewrite_maxdmaps          = 10
  303. _query_mmvrewrite_maxcmaps          = 20
  304. _query_mmvrewrite_maxregperm        = 512
  305. _query_mmvrewrite_maxqryinlistvals  = 500
  306. _disable_parallel_conventional_load = false
  307. _trace_virtual_columns              = false
  308. _replace_virtual_columns            = true
  309. _virtual_column_overload_allowed    = true
  310. _kdt_buffering                      = true
  311. _first_k_rows_dynamic_proration     = true
  312. _optimizer_sortmerge_join_inequality = true
  313. _optimizer_aw_stats_enabled         = true
  314. _bloom_pruning_enabled              = true
  315. result_cache_mode                   = MANUAL
  316. _px_ual_serial_input                = true
  317. _optimizer_skip_scan_guess          = false
  318. _enable_row_shipping                = true
  319. _row_shipping_threshold             = 80
  320. _row_shipping_explain               = false
  321. transaction_isolation_level         = read_commited
  322. _optimizer_distinct_elimination     = true
  323. _optimizer_multi_level_push_pred    = true
  324. _optimizer_group_by_placement       = true
  325. _optimizer_rownum_bind_default      = 10
  326. _enable_query_rewrite_on_remote_objs = true
  327. _optimizer_extended_cursor_sharing_rel = simple
  328. _optimizer_adaptive_cursor_sharing  = true
  329. _direct_path_insert_features        = 0
  330. _optimizer_improve_selectivity      = true
  331. optimizer_use_pending_statistics    = false
  332. _optimizer_enable_density_improvements = true
  333. _optimizer_aw_join_push_enabled     = true
  334. _optimizer_connect_by_combine_sw    = true
  335. _enable_pmo_ctas                    = 0
  336. _optimizer_native_full_outer_join   = force
  337. _bloom_predicate_enabled            = true
  338. _optimizer_enable_extended_stats    = true
  339. _is_lock_table_for_ddl_wait_lock    = 0
  340. _pivot_implementation_method        = choose
  341. optimizer_capture_sql_plan_baselines = false
  342. optimizer_use_sql_plan_baselines    = true
  343. _optimizer_star_trans_min_cost      = 0
  344. _optimizer_star_trans_min_ratio     = 0
  345. _with_subquery                      = OPTIMIZER
  346. _optimizer_fkr_index_cost_bias      = 10
  347. _optimizer_use_subheap              = true
  348. parallel_degree_policy              = manual
  349. parallel_degree                     = 0
  350. parallel_min_time_threshold         = 10
  351. _parallel_time_unit                 = 10
  352. _optimizer_or_expansion_subheap     = true
  353. _optimizer_free_transformation_heap = true
  354. _optimizer_reuse_cost_annotations   = true
  355. _result_cache_auto_size_threshold   = 100
  356. _result_cache_auto_time_threshold   = 1000
  357. _optimizer_nested_rollup_for_gset   = 100
  358. _nlj_batching_enabled               = 1
  359. parallel_query_default_dop          = 0
  360. is_recur_flags                      = 0
  361. optimizer_use_invisible_indexes     = false
  362. flashback_data_archive_internal_cursor = 0
  363. _optimizer_extended_stats_usage_control = 192
  364. _parallel_syspls_obey_force         = true
  365. cell_offload_processing             = true
  366. _rdbms_internal_fplib_enabled       = false
  367. _bloom_folding_enabled              = true
  368. _mv_generalized_oj_refresh_opt      = true
  369. cell_offload_compaction             = ADAPTIVE
  370. cell_offload_plan_display           = AUTO
  371. _bloom_predicate_pushdown_to_storage = true
  372. _bloom_vector_elements              = 0
  373. _bloom_pushing_max                  = 512
  374. parallel_degree_limit               = 65535
  375. parallel_force_local                = false
  376. parallel_max_degree                 = 48
  377. total_cpu_count                     = 24
  378. _optimizer_coalesce_subqueries      = true
  379. _optimizer_fast_pred_transitivity   = true
  380. _optimizer_fast_access_pred_analysis = true
  381. _optimizer_unnest_disjunctive_subq  = true
  382. _optimizer_unnest_corr_set_subq     = true
  383. _optimizer_distinct_agg_transform   = true
  384. _aggregation_optimization_settings  = 0
  385. _optimizer_connect_by_elim_dups     = true
  386. _optimizer_eliminate_filtering_join = true
  387. _connect_by_use_union_all           = true
  388. dst_upgrade_insert_conv             = true
  389. advanced_queuing_internal_cursor    = 0
  390. _optimizer_unnest_all_subqueries    = true
  391. parallel_autodop                    = 0
  392. parallel_ddldml                     = 0
  393. _parallel_cluster_cache_policy      = adaptive
  394. _parallel_scalability               = 50
  395. iot_internal_cursor                 = 0
  396. _optimizer_instance_count           = 0
  397. _optimizer_connect_by_cb_whr_only   = false
  398. _suppress_scn_chk_for_cqn           = nosuppress_1466
  399. _optimizer_join_factorization       = true
  400. _optimizer_use_cbqt_star_transformation = true
  401. _optimizer_table_expansion          = true
  402. _and_pruning_enabled                = true
  403. _deferred_constant_folding_mode     = DEFAULT
  404. _optimizer_distinct_placement       = true
  405. partition_pruning_internal_cursor   = 0
  406. parallel_hinted                     = none
  407. _sql_compatibility                  = 0
  408. _optimizer_use_feedback             = true
  409. _optimizer_try_st_before_jppd       = true
  410. _dml_frequency_tracking             = false
  411. _optimizer_interleave_jppd          = true
  412. kkb_drop_empty_segments             = 0
  413. _px_partition_scan_enabled          = true
  414. _px_partition_scan_threshold        = 64
  415. _optimizer_false_filter_pred_pullup = true
  416. _bloom_minmax_enabled               = true
  417. only_move_row                       = 0
  418. _optimizer_enable_table_lookup_by_nl = true
  419. Bug Fix Control Environment
  420.     fix  3834770 = 1      
  421.     fix  3746511 = enabled
  422.     fix  4519016 = enabled
  423.     fix  3118776 = enabled
  424.     fix  4488689 = enabled
  425.     fix  2194204 = disabled
  426.     fix  2660592 = enabled
  427.     fix  2320291 = enabled
  428.     fix  2324795 = enabled
  429.     fix  4308414 = enabled
  430.     fix  3499674 = disabled
  431.     fix  4569940 = enabled
  432.     fix  4631959 = enabled
  433.     fix  4519340 = enabled
  434.     fix  4550003 = enabled
  435.     fix  1403283 = enabled
  436.     fix  4554846 = enabled
  437.     fix  4602374 = enabled
  438.     fix  4584065 = enabled
  439.     fix  4545833 = enabled
  440.     fix  4611850 = enabled
  441.     fix  4663698 = enabled
  442.     fix  4663804 = enabled
  443.     fix  4666174 = enabled
  444.     fix  4567767 = enabled
  445.     fix  4556762 = 15     
  446.     fix  4728348 = enabled
  447.     fix  4708389 = enabled
  448.     fix  4175830 = enabled
  449.     fix  4752814 = enabled
  450.     fix  4583239 = enabled
  451.     fix  4386734 = enabled
  452.     fix  4887636 = enabled
  453.     fix  4483240 = enabled
  454.     fix  4872602 = disabled
  455.     fix  4711525 = enabled
  456.     fix  4545802 = enabled
  457.     fix  4605810 = enabled
  458.     fix  4704779 = enabled
  459.     fix  4900129 = enabled
  460.     fix  4924149 = enabled
  461.     fix  4663702 = enabled
  462.     fix  4878299 = enabled
  463.     fix  4658342 = enabled
  464.     fix  4881533 = enabled
  465.     fix  4676955 = enabled
  466.     fix  4273361 = enabled
  467.     fix  4967068 = enabled
  468.     fix  4969880 = disabled
  469.     fix  5005866 = enabled
  470.     fix  5015557 = enabled
  471.     fix  4705343 = enabled
  472.     fix  4904838 = enabled
  473.     fix  4716096 = enabled
  474.     fix  4483286 = disabled
  475.     fix  4722900 = enabled
  476.     fix  4615392 = enabled
  477.     fix  5096560 = enabled
  478.     fix  5029464 = enabled
  479.     fix  4134994 = enabled
  480.     fix  4904890 = enabled
  481.     fix  5104624 = enabled
  482.     fix  5014836 = enabled
  483.     fix  4768040 = enabled
  484.     fix  4600710 = enabled
  485.     fix  5129233 = enabled
  486.     fix  4595987 = enabled
  487.     fix  4908162 = enabled
  488.     fix  5139520 = enabled
  489.     fix  5084239 = enabled
  490.     fix  5143477 = disabled
  491.     fix  2663857 = enabled
  492.     fix  4717546 = enabled
  493.     fix  5240264 = disabled
  494.     fix  5099909 = enabled
  495.     fix  5240607 = enabled
  496.     fix  5195882 = enabled
  497.     fix  5220356 = enabled
  498.     fix  5263572 = enabled
  499.     fix  5385629 = enabled
  500.     fix  5302124 = enabled
  501.     fix  5391942 = enabled
  502.     fix  5384335 = enabled
  503.     fix  5482831 = enabled
  504.     fix  4158812 = enabled
  505.     fix  5387148 = enabled
  506.     fix  5383891 = enabled
  507.     fix  5466973 = enabled
  508.     fix  5396162 = enabled
  509.     fix  5394888 = enabled
  510.     fix  5395291 = enabled
  511.     fix  5236908 = enabled
  512.     fix  5509293 = enabled
  513.     fix  5449488 = enabled
  514.     fix  5567933 = enabled
  515.     fix  5570494 = enabled
  516.     fix  5288623 = enabled
  517.     fix  5505995 = enabled
  518.     fix  5505157 = enabled
  519.     fix  5112460 = enabled
  520.     fix  5554865 = enabled
  521.     fix  5112260 = enabled
  522.     fix  5112352 = enabled
  523.     fix  5547058 = enabled
  524.     fix  5618040 = enabled
  525.     fix  5585313 = enabled
  526.     fix  5547895 = enabled
  527.     fix  5634346 = enabled
  528.     fix  5620485 = enabled
  529.     fix  5483301 = enabled
  530.     fix  5657044 = enabled
  531.     fix  5694984 = enabled
  532.     fix  5868490 = enabled
  533.     fix  5650477 = enabled
  534.     fix  5611962 = enabled
  535.     fix  4279274 = enabled
  536.     fix  5741121 = enabled
  537.     fix  5714944 = enabled
  538.     fix  5391505 = enabled
  539.     fix  5762598 = enabled
  540.     fix  5578791 = enabled
  541.     fix  5259048 = enabled
  542.     fix  5882954 = enabled
  543.     fix  2492766 = enabled
  544.     fix  5707608 = enabled
  545.     fix  5891471 = enabled
  546.     fix  5884780 = enabled
  547.     fix  5680702 = enabled
  548.     fix  5371452 = enabled
  549.     fix  5838613 = enabled
  550.     fix  5949981 = enabled
  551.     fix  5624216 = enabled
  552.     fix  5741044 = enabled
  553.     fix  5976822 = enabled
  554.     fix  6006457 = enabled
  555.     fix  5872956 = enabled
  556.     fix  5923644 = enabled
  557.     fix  5943234 = enabled
  558.     fix  5844495 = enabled
  559.     fix  4168080 = enabled
  560.     fix  6020579 = enabled
  561.     fix  5842686 = disabled
  562.     fix  5996801 = enabled
  563.     fix  5593639 = enabled
  564.     fix  6133948 = enabled
  565.     fix  3151991 = enabled
  566.     fix  6146906 = enabled
  567.     fix  6239909 = enabled
  568.     fix  6267621 = enabled
  569.     fix  5909305 = enabled
  570.     fix  6279918 = enabled
  571.     fix  6141818 = enabled
  572.     fix  6151963 = enabled
  573.     fix  6251917 = enabled
  574.     fix  6282093 = enabled
  575.     fix  6119510 = enabled
  576.     fix  6119382 = enabled
  577.     fix  3801750 = enabled
  578.     fix  5705630 = disabled
  579.     fix  5944076 = enabled
  580.     fix  5406763 = enabled
  581.     fix  6070954 = enabled
  582.     fix  6282944 = enabled
  583.     fix  6138746 = enabled
  584.     fix  6082745 = enabled
  585.     fix  3426050 = enabled
  586.     fix   599680 = enabled
  587.     fix  6062266 = enabled
  588.     fix  6087237 = enabled
  589.     fix  6122894 = enabled
  590.     fix  6377505 = enabled
  591.     fix  5893768 = enabled
  592.     fix  6163564 = enabled
  593.     fix  6073325 = enabled
  594.     fix  6188881 = enabled
  595.     fix  6007259 = enabled
  596.     fix  6239971 = enabled
  597.     fix  5284200 = disabled
  598.     fix  6042205 = enabled
  599.     fix  6051211 = enabled
  600.     fix  6434668 = enabled
  601.     fix  6438752 = enabled
  602.     fix  5936366 = enabled
  603.     fix  6439032 = enabled
  604.     fix  6438892 = enabled
  605.     fix  6006300 = enabled
  606.     fix  5947231 = enabled
  607.     fix  5416118 = 1      
  608.     fix  6365442 = 1      
  609.     fix  6239039 = enabled
  610.     fix  6502845 = enabled
  611.     fix  6913094 = enabled
  612.     fix  6029469 = enabled
  613.     fix  5919513 = enabled
  614.     fix  6057611 = enabled
  615.     fix  6469667 = enabled
  616.     fix  6608941 = disabled
  617.     fix  6368066 = enabled
  618.     fix  6329318 = enabled
  619.     fix  6656356 = enabled
  620.     fix  4507997 = enabled
  621.     fix  6671155 = enabled
  622.     fix  6694548 = enabled
  623.     fix  6688200 = enabled
  624.     fix  6612471 = enabled
  625.     fix  6708183 = disabled
  626.     fix  6326934 = enabled
  627.     fix  6520717 = disabled
  628.     fix  6714199 = enabled
  629.     fix  6681545 = enabled
  630.     fix  6748058 = enabled
  631.     fix  6167716 = enabled
  632.     fix  6674254 = enabled
  633.     fix  6468287 = enabled
  634.     fix  6503543 = enabled
  635.     fix  6808773 = disabled
  636.     fix  6766962 = enabled
  637.     fix  6120483 = enabled
  638.     fix  6670551 = enabled
  639.     fix  6771838 = enabled
  640.     fix  6626018 = disabled
  641.     fix  6530596 = enabled
  642.     fix  6778642 = enabled
  643.     fix  6699059 = enabled
  644.     fix  6376551 = enabled
  645.     fix  6429113 = enabled
  646.     fix  6782437 = enabled
  647.     fix  6776808 = enabled
  648.     fix  6765823 = enabled
  649.     fix  6768660 = enabled
  650.     fix  6782665 = enabled
  651.     fix  6610822 = enabled
  652.     fix  6514189 = enabled
  653.     fix  6818410 = enabled
  654.     fix  6827696 = enabled
  655.     fix  6773613 = enabled
  656.     fix  5902962 = enabled
  657.     fix  6956212 = enabled
  658.     fix  3056297 = enabled
  659.     fix  6440977 = disabled
  660.     fix  6972291 = disabled
  661.     fix  6904146 = enabled
  662.     fix  6221403 = enabled
  663.     fix  5475051 = enabled
  664.     fix  6845871 = enabled
  665.     fix  5468809 = enabled
  666.     fix  6917633 = enabled
  667.     fix  4444536 = disabled
  668.     fix  6955210 = enabled
  669.     fix  6994194 = enabled
  670.     fix  6399597 = disabled
  671.     fix  6951776 = enabled
  672.     fix  5648287 = 3      
  673.     fix  6987082 = disabled
  674.     fix  7132036 = enabled
  675.     fix  6980350 = enabled
  676.     fix  5199213 = enabled
  677.     fix  7138405 = enabled
  678.     fix  7148689 = enabled
  679.     fix  6820988 = enabled
  680.     fix  7032684 = enabled
  681.     fix  6617866 = enabled
  682.     fix  7155968 = enabled
  683.     fix  7127980 = enabled
  684.     fix  6982954 = enabled
  685.     fix  7241819 = enabled
  686.     fix  6897034 = enabled
  687.     fix  7236148 = enabled
  688.     fix  7298570 = enabled
  689.     fix  7249095 = enabled
  690.     fix  7314499 = enabled
  691.     fix  7324224 = enabled
  692.     fix  7289023 = enabled
  693.     fix  7237571 = enabled
  694.     fix  7116357 = enabled
  695.     fix  7345484 = enabled
  696.     fix  7375179 = enabled
  697.     fix  6430500 = disabled
  698.     fix  5897486 = enabled
  699.     fix  6774209 = enabled
  700.     fix  7306637 = enabled
  701.     fix  6451322 = enabled
  702.     fix  7208131 = enabled
  703.     fix  7388652 = enabled
  704.     fix  7127530 = enabled
  705.     fix  6751206 = enabled
  706.     fix  6669103 = enabled
  707.     fix  7430474 = enabled
  708.     fix  6990305 = enabled
  709.     fix  7043307 = enabled
  710.     fix  3120429 = enabled
  711.     fix  7452823 = disabled
  712.     fix  6838105 = enabled
  713.     fix  6769711 = enabled
  714.     fix  7170213 = enabled
  715.     fix  6528872 = enabled
  716.     fix  7295298 = enabled
  717.     fix  5922070 = enabled
  718.     fix  7259468 = enabled
  719.     fix  6418552 = enabled
  720.     fix  4619997 = enabled
  721.     fix  7524366 = enabled
  722.     fix  6942476 = enabled
  723.     fix  6418771 = enabled
  724.     fix  7375077 = enabled
  725.     fix  5400639 = enabled
  726.     fix  4570921 = enabled
  727.     fix  7426911 = enabled
  728.     fix  5099019 = disabled
  729.     fix  7528216 = enabled
  730.     fix  7521266 = enabled
  731.     fix  7385140 = enabled
  732.     fix  7576516 = enabled
  733.     fix  7573526 = enabled
  734.     fix  7576476 = enabled
  735.     fix  7165898 = enabled
  736.     fix  7263214 = enabled
  737.     fix  3320140 = enabled
  738.     fix  7555510 = enabled
  739.     fix  7613118 = enabled
  740.     fix  7597059 = enabled
  741.     fix  7558911 = enabled
  742.     fix  5520732 = enabled
  743.     fix  7679490 = disabled
  744.     fix  7449971 = enabled
  745.     fix  3628118 = enabled
  746.     fix  4370840 = enabled
  747.     fix  7281191 = enabled
  748.     fix  7519687 = enabled
  749.     fix  5029592 = 3      
  750.     fix  6012093 = 1      
  751.     fix  6053861 = disabled
  752.     fix  6941515 = disabled
  753.     fix  7696414 = enabled
  754.     fix  7272039 = enabled
  755.     fix  7834811 = enabled
  756.     fix  7640597 = enabled
  757.     fix  7341616 = enabled
  758.     fix  7168184 = enabled
  759.     fix   399198 = enabled
  760.     fix  7831070 = enabled
  761.     fix  7676897 = disabled
  762.     fix  7414637 = enabled
  763.     fix  7585456 = enabled
  764.     fix  8202421 = enabled
  765.     fix  7658097 = disabled
  766.     fix  8251486 = enabled
  767.     fix  7132684 = enabled
  768.     fix  7512227 = enabled
  769.     fix  6972987 = enabled
  770.     fix  7199035 = enabled
  771.     fix  8243446 = enabled
  772.     fix  7650462 = enabled
  773.     fix  6720701 = enabled
  774.     fix  7592673 = enabled
  775.     fix  7718694 = enabled
  776.     fix  7534027 = enabled
  777.     fix  7708267 = enabled
  778.     fix  5716785 = enabled
  779.     fix  7356191 = enabled
  780.     fix  7679161 = enabled
  781.     fix  7597159 = enabled
  782.     fix  7499258 = enabled
  783.     fix  8328363 = enabled
  784.     fix  7452863 = enabled
  785.     fix  8284930 = enabled
  786.     fix  7298626 = enabled
  787.     fix  7657126 = enabled
  788.     fix  8371884 = enabled
  789.     fix  8318020 = enabled
  790.     fix  8255423 = enabled
  791.     fix  7135745 = enabled
  792.     fix  8356253 = enabled
  793.     fix  7534257 = enabled
  794.     fix  8323407 = enabled
  795.     fix  7539815 = enabled
  796.     fix  8289316 = enabled
  797.     fix  8447850 = enabled
  798.     fix  7675944 = enabled
  799.     fix  8355120 = enabled
  800.     fix  7176746 = enabled
  801.     fix  8442891 = enabled
  802.     fix  8373261 = enabled
  803.     fix  7679164 = enabled
  804.     fix  7670533 = enabled
  805.     fix  8408665 = enabled
  806.     fix  8491399 = enabled
  807.     fix  8348392 = enabled
  808.     fix  8348585 = enabled
  809.     fix  8508056 = enabled
  810.     fix  8335178 = enabled
  811.     fix  8515269 = enabled
  812.     fix  8247017 = enabled
  813.     fix  7325597 = enabled
  814.     fix  8531490 = enabled
  815.     fix  6163600 = enabled
  816.     fix  8589278 = disabled
  817.     fix  8557992 = enabled
  818.     fix  7556098 = enabled
  819.     fix  8580883 = enabled
  820.     fix  5892599 = disabled
  821.     fix  8609714 = enabled
  822.     fix  8619631 = disabled
  823.     fix  8672915 = enabled
  824.     fix  8514561 = enabled
  825.     fix  8213977 = enabled
  826.     fix  8560951 = disabled
  827.     fix  8578587 = enabled
  828.     fix  8287870 = enabled
  829.     fix  8467123 = enabled
  830.     fix  8602185 = enabled
  831.     fix  8519457 = enabled
  832.     fix  3335182 = enabled
  833.     fix  8602840 = enabled
  834.     fix  8725296 = enabled
  835.     fix  8628970 = enabled
  836.     fix  6754080 = enabled
  837.     fix  8767442 = enabled
  838.     fix  8760135 = enabled
  839.     fix  8644935 = enabled
  840.     fix  8352378 = enabled
  841.     fix  8685327 = enabled
  842.     fix  8763472 = enabled
  843.     fix  8773324 = enabled
  844.     fix  8813674 = enabled
  845.     fix  8532236 = enabled
  846.     fix  8629716 = enabled
  847.     fix  7277732 = enabled
  848.     fix  8692170 = enabled
  849.     fix  8900973 = enabled
  850.     fix  8919133 = enabled
  851.     fix  8927050 = enabled
  852.     fix  8551880 = enabled
  853.     fix  8901237 = enabled
  854.     fix  8812372 = enabled
  855.     fix  6236862 = enabled
  856.     fix  8528517 = enabled
  857.     fix  7215982 = enabled
  858.     fix  8214022 = enabled
  859.     fix  8595392 = enabled
  860.     fix  8890233 = enabled
  861.     fix  8999317 = enabled
  862.     fix  9004800 = enabled
  863.     fix  8986163 = enabled
  864.     fix  8855396 = enabled
  865.     fix  8800514 = 20     
  866.     fix  9007859 = enabled
  867.     fix  8198783 = enabled
  868.     fix  9053879 = enabled
  869.     fix  6086930 = enabled
  870.     fix  7641601 = enabled
  871.     fix  9052506 = enabled
  872.     fix  9103775 = enabled
  873.     fix  9047975 = enabled
  874.     fix  8893626 = enabled
  875.     fix  9111170 = enabled
  876.     fix  8971829 = enabled
  877.     fix  7628358 = enabled
  878.     fix  9125151 = enabled
  879.     fix  9039715 = enabled
  880.     fix  9106224 = enabled
  881.     fix  9185228 = enabled
  882.     fix  9206747 = enabled
  883.     fix  9088510 = enabled
  884.     fix  9143856 = enabled
  885.     fix  8833381 = enabled
  886.     fix  8949971 = enabled
  887.     fix  8951812 = enabled
  888.     fix  9148171 = enabled
  889.     fix  8706652 = enabled
  890.     fix  9245114 = enabled
  891.     fix  8802198 = enabled
  892.     fix  9011016 = enabled
  893.     fix  9265681 = enabled
  894.     fix  7284269 = enabled
  895.     fix  9272549 = enabled
  896.     fix  8917507 = 7      
  897.     fix  8531463 = enabled
  898.     fix  9263333 = enabled
  899.     fix  8675087 = enabled
  900.     fix  8571403 = enabled
  901.     fix  8896955 = enabled
  902.     fix  9041934 = enabled
  903.     fix  9344709 = enabled
  904.     fix  9024933 = enabled
  905.     fix  9033718 = enabled
  906.     fix  9240455 = enabled
  907.     fix  9081848 = enabled
  908.     fix  5982893 = enabled
  909.     fix  9287401 = enabled
  910.     fix  8590021 = enabled
  911.     fix  9340120 = enabled
  912.     fix  9355794 = enabled
  913.     fix  9356656 = enabled
  914.     fix  9385634 = enabled
  915.     fix  9069046 = enabled
  916.     fix  9239337 = enabled
  917.     fix  9300228 = enabled
  918.     fix  9298010 = enabled
  919.     fix  9384170 = enabled
  920.     fix  9301862 = disabled
  921.     fix  9407929 = enabled
  922.     fix  8836806 = enabled
  923.     fix  9344055 = enabled
  924.     fix  9274675 = enabled
  925.     fix  9203723 = enabled
  926.     fix  9443476 = enabled
  927.     fix  9195582 = enabled
  928.     fix  8226666 = enabled
  929.     fix  9433490 = enabled
  930.     fix  9065494 = enabled
  931.     fix  9303766 = enabled
  932.     fix  9437283 = enabled
  933.     fix  9116214 = enabled
  934.     fix  9456688 = enabled
  935.     fix  9456746 = disabled
  936.     fix  9342979 = enabled
  937.     fix  9465425 = enabled
  938.     fix  9092442 = enabled
  939.     fix  4926618 = enabled
  940.     fix  8792846 = enabled
  941.     fix  9474259 = enabled
  942.     fix  9495669 = disabled
  943.     fix  6472966 = enabled
  944.     fix  6408301 = enabled
  945.     fix  9380298 = disabled
  946.     fix  8500130 = enabled
  947.     fix  9584723 = enabled
  948.     fix  9270951 = enabled
  949.     fix  9508254 = enabled
  950.     fix  9593680 = enabled
  951.     fix  9196440 = disabled
  952.     fix  9309281 = enabled
  953.     fix  8693158 = enabled
  954.     fix  9381638 = enabled
  955.     fix  9383967 = enabled
  956.     fix  7711900 = enabled
  957.     fix  9218587 = enabled
  958.     fix  9728438 = enabled
  959.     fix  9038395 = enabled
  960.     fix  9577300 = enabled
  961.     fix  9171113 = enabled
  962.     fix  8973745 = enabled
  963.     fix  9732434 = enabled
  964.     fix  8937971 = disabled
  965.     fix  9102474 = enabled
  966.     fix  9243499 = enabled
  967.     fix  9912503 = enabled
  968.     fix  9153459 = enabled
  969.     fix  9762592 = 3      
  970.     fix  9785632 = enabled
  971.   ***************************************
  972.   PARAMETERS IN OPT_PARAM HINT
  973.   ****************************
  974. ***************************************
  975. Column Usage Monitoring is ON: tracking level = 1
  976. ***************************************
  977. Considering Query Transformations on query block SEL$1 (#0)
  978. **************************
  979. Query transformations (QT)
  980. **************************
  981. JF: Checking validity of join factorization for query block SEL$1 (#0)
  982. JF: Bypassed: not a UNION or UNION-ALL query block.
  983. ST: not valid since star transformation parameter is FALSE
  984. TE: Checking validity of table expansion for query block SEL$1 (#0)
  985. TE: Bypassed: No partitioned table in query block.
  986. CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.
  987. CBQT: Validity checks failed for a5ks9fhw2v9s1.
  988. CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
  989. *************************
  990. Common Subexpression elimination (CSE)
  991. *************************
  992. CSE:     CSE not performed on query block SEL$1 (#0).
  993. OBYE:   Considering Order-by Elimination from view SEL$1 (#0)
  994. ***************************
  995. Order-by elimination (OBYE)
  996. ***************************
  997. OBYE:     OBYE bypassed: no order by to eliminate.
  998. CVM: Considering view merge in query block SEL$1 (#0)
  999. query block SEL$1 (#0) unchanged
  1000. Considering Query Transformations on query block SEL$1 (#0)
  1001. **************************
  1002. Query transformations (QT)
  1003. **************************
  1004. JF: Checking validity of join factorization for query block SEL$1 (#0)
  1005. JF: Bypassed: not a UNION or UNION-ALL query block.
  1006. ST: not valid since star transformation parameter is FALSE
  1007. TE: Checking validity of table expansion for query block SEL$1 (#0)
  1008. TE: Bypassed: No partitioned table in query block.
  1009. CBQT bypassed for query block SEL$1 (#0): no complex view, sub-queries or UNION (ALL) queries.
  1010. CBQT: Validity checks failed for a5ks9fhw2v9s1.
  1011. CSE: Considering common sub-expression elimination in query block SEL$1 (#0)
  1012. *************************
  1013. Common Subexpression elimination (CSE)
  1014. *************************
  1015. CSE:     CSE not performed on query block SEL$1 (#0).
  1016. SU: Considering subquery unnesting in query block SEL$1 (#0)
  1017. ********************
  1018. Subquery Unnest (SU)
  1019. ********************
  1020. SJC: Considering set-join conversion in query block SEL$1 (#0)
  1021. *************************
  1022. Set-Join Conversion (SJC)
  1023. *************************
  1024. SJC: not performed
  1025. PM: Considering predicate move-around in query block SEL$1 (#0)
  1026. **************************
  1027. Predicate Move-Around (PM)
  1028. **************************
  1029. PM:     PM bypassed: Outer query contains no views.
  1030. PM:     PM bypassed: Outer query contains no views.
  1031. query block SEL$1 (#0) unchanged
  1032. FPD: Considering simple filter push in query block SEL$1 (#0)
  1033.  ??
  1034. apadrv-start sqlid=11730480049179961089
  1035.   :
  1036.     call(in-use=992, alloc=16344), compile(in-use=53880, alloc=54488), execution(in-use=2664, alloc=4032)
  1037. *******************************************
  1038. Peeked values of the binds in SQL statement
  1039. *******************************************
  1040. Final query after transformations:******* UNPARSED QUERY IS *******
  1041. SELECT "DUAL"."DUMMY" "DUMMY" FROM "SYS"."DUAL" "DUAL"
  1042. kkoqbc: optimizing query block SEL$1 (#0)
  1043.         :
  1044.     call(in-use=992, alloc=16344), compile(in-use=54832, alloc=55280), execution(in-use=2664, alloc=4032)
  1045. kkoqbc-subheap (create addr=0x2b77ad48fb58)
  1046. ****************
  1047. QUERY BLOCK TEXT
  1048. ****************
  1049. select * from dual
  1050. ---------------------
  1051. QUERY BLOCK SIGNATURE
  1052. ---------------------
  1053. signature (optimizer): qb_name=SEL$1 nbfros=1 flg=0
  1054.   fro(0): flg=0 objn=116 hint_alias="DUAL"@"SEL$1"
  1055. -----------------------------
  1056. SYSTEM STATISTICS INFORMATION
  1057. -----------------------------
  1058.   Using NOWORKLOAD Stats
  1059.   CPUSPEEDNW: 1416 millions instructions/sec (default is 100)
  1060.   IOTFRSPEED: 4096 bytes per millisecond (default is 4096)
  1061.   IOSEEKTIM: 10 milliseconds (default is 10)
  1062.   MBRC: -1 blocks (default is 32)
  1063. ***************************************
  1064. BASE STATISTICAL INFORMATION
  1065. ***********************
  1066. Table Stats::
  1067.   Table: DUAL  Alias: DUAL
  1068.     #Rows: 1  #Blks:  1  AvgRowLen:  2.00  ChainCnt:  0.00
  1069. Access path analysis for DUAL
  1070. ***************************************
  1071. SINGLE TABLE ACCESS PATH
  1072.   Single Table Cardinality Estimation for DUAL[DUAL]
  1073.   Table: DUAL  Alias: DUAL
  1074.     Card: Original: 1.000000  Rounded: 1  Computed: 1.00  Non Adjusted: 1.00
  1075.   Access Path: TableScan
  1076.     Cost:  2.00  Resp: 2.00  Degree: 0
  1077.       Cost_io: 2.00  Cost_cpu: 9893
  1078.       Resp_io: 2.00  Resp_cpu: 9893
  1079.   Best:: AccessPath: TableScan
  1080.          Cost: 2.00  Degree: 1  Resp: 2.00  Card: 1.00  Bytes: 0
  1081. ***************************************
  1082. OPTIMIZER STATISTICS AND COMPUTATIONS
  1083. ***************************************
  1084. GENERAL PLANS
  1085. ***************************************
  1086. Considering cardinality-based initial join order.
  1087. Permutations for Starting Table :0
  1088. Join order[1]:  DUAL[DUAL]#0
  1089. ***********************
  1090. Best so far:  Table#: 0  cost: 2.0005  card: 1.0000  bytes: 2
  1091. ***********************
  1092. (newjo-stop-1) k:0, spcnt:0, perm:1, maxperm:2000
  1093. *********************************
  1094. Number of join permutations tried: 1
  1095. *********************************
  1096. Enumerating distribution method (advanced)
  1097. Trying or-Expansion on query block SEL$1 (#0)
  1098. Transfer Optimizer annotations for query block SEL$1 (#0)
  1099. Final cost for query block SEL$1 (#0) - All Rows Plan:
  1100.   Best join order: 1
  1101.   Cost: 2.0005  Degree: 1  Card: 1.0000  Bytes: 2
  1102.   Resc: 2.0005  Resc_io: 2.0000  Resc_cpu: 9893
  1103.   Resp: 2.0005  Resp_io: 2.0000  Resc_cpu: 9893
  1104. kkoqbc-subheap (delete addr=0x2b77ad48fb58, in-use=11112, alloc=16408)
  1105. kkoqbc-end:
  1106.         :
  1107.     call(in-use=7224, alloc=32816), compile(in-use=55424, alloc=59424), execution(in-use=2664, alloc=4032)
  1108. kkoqbc: finish optimizing query block SEL$1 (#0)
  1109. apadrv-end
  1110.           :
  1111.     call(in-use=7224, alloc=32816), compile(in-use=56336, alloc=59424), execution(in-use=2664, alloc=4032)
  1112. Starting SQL statement dump
  1113. user_id=159 user_name=RRS_CORE_DBO module=TOAD 10.6.1.3 action=
  1114. sql_id=a5ks9fhw2v9s1 plan_hash_value=272002086 problem_type=3
  1115. ----- Current SQL Statement for this session (sql_id=a5ks9fhw2v9s1) -----
  1116. select * from dual
  1117. sql_text_length=19
  1118. sql=select * from dual
  1119. ----- Explain Plan Dump -----
  1120. ----- Plan Table -----
  1121. ============
  1122. Plan Table
  1123. ============
  1124. -------------------------------------+-----------------------------------+
  1125. | Id  | Operation          | Name    | Rows  | Bytes | Cost  | Time      |
  1126. -------------------------------------+-----------------------------------+
  1127. | 0   | SELECT STATEMENT   |         |       |       |     2 |           |
  1128. | 1   |  TABLE ACCESS FULL | DUAL    |     1 |     2 |     2 |  00:00:01 |
  1129. -------------------------------------+-----------------------------------+
  1130. Predicate Information:
  1131. ----------------------
  1132. Content of other_xml column
  1133. ===========================
  1134.   db_version     : 11.2.0.2
  1135.   parse_schema   : RRS_CORE_DBO
  1136.   plan_hash      : 272002086
  1137.   plan_hash_2    : 4017058736
  1138.   Outline Data:
  1139.   /*+
  1140.     BEGIN_OUTLINE_DATA
  1141.       IGNORE_OPTIM_EMBEDDED_HINTS
  1142.       OPTIMIZER_FEATURES_ENABLE('11.2.0.2')
  1143.       DB_VERSION('11.2.0.2')
  1144.       ALL_ROWS
  1145.       OUTLINE_LEAF(@"SEL$1")
  1146.       FULL(@"SEL$1" "DUAL"@"SEL$1")
  1147.     END_OUTLINE_DATA
  1148.   */
  1149. Optimizer state dump:
  1150. Compilation Environment Dump
  1151. optimizer_mode_hinted               = false
  1152. optimizer_features_hinted           = 0.0.0
  1153. parallel_execution_enabled          = true
  1154. parallel_query_forced_dop           = 0
  1155. parallel_dml_forced_dop             = 0
  1156. parallel_ddl_forced_degree          = 0
  1157. parallel_ddl_forced_instances       = 0
  1158. _query_rewrite_fudge                = 90
  1159. optimizer_features_enable           = 11.2.0.2
  1160. _optimizer_search_limit             = 5
  1161. cpu_count                           = 24
  1162. active_instance_count               = 1
  1163. parallel_threads_per_cpu            = 2
  1164. hash_area_size                      = 131072
  1165. bitmap_merge_area_size              = 1048576
  1166. sort_area_size                      = 65536
  1167. sort_area_retained_size             = 0
  1168. _sort_elimination_cost_ratio        = 0
  1169. _optimizer_block_size               = 16384
  1170. _sort_multiblock_read_count         = 2
  1171. _hash_multiblock_io_count           = 0
  1172. _db_file_optimizer_read_count       = 32
  1173. _optimizer_max_permutations         = 2000
  1174. pga_aggregate_target                = 41943040 KB
  1175. _pga_max_size                       = 2097152 KB
  1176. _query_rewrite_maxdisjunct          = 257
  1177. _smm_auto_min_io_size               = 48 KB
  1178. _smm_auto_max_io_size               = 240 KB
  1179. _smm_min_size                       = 1024 KB
  1180. _smm_max_size                       = 1048576 KB
  1181. _smm_px_max_size                    = 20971520 KB
  1182. _cpu_to_io                          = 0
  1183. _optimizer_undo_cost_change         = 11.2.0.2
  1184. parallel_query_mode                 = enabled
  1185. parallel_dml_mode                   = disabled
  1186. parallel_ddl_mode                   = enabled
  1187. optimizer_mode                      = all_rows
  1188. sqlstat_enabled                     = false
  1189. _optimizer_percent_parallel         = 101
  1190. _always_anti_join                   = choose
  1191. _always_semi_join                   = choose
  1192. _optimizer_mode_force               = true
  1193. _partition_view_enabled             = true
  1194. _always_star_transformation         = false
  1195. _query_rewrite_or_error             = false
  1196. _hash_join_enabled                  = true
  1197. cursor_sharing                      = exact
  1198. _b_tree_bitmap_plans                = true
  1199. star_transformation_enabled         = false
  1200. _optimizer_cost_model               = choose
  1201. _new_sort_cost_estimate             = true
  1202. _complex_view_merging               = true
  1203. _unnest_subquery                    = true
  1204. _eliminate_common_subexpr           = true
  1205. _pred_move_around                   = true
  1206. _convert_set_to_join                = false
  1207. _push_join_predicate                = true
  1208. _push_join_union_view               = true
  1209. _fast_full_scan_enabled             = true
  1210. _optim_enhance_nnull_detection      = true
  1211. _parallel_broadcast_enabled         = true
  1212. _px_broadcast_fudge_factor          = 100
  1213. _ordered_nested_loop                = true
  1214. _no_or_expansion                    = false
  1215. optimizer_index_cost_adj            = 100
  1216. optimizer_index_caching             = 0
  1217. _system_index_caching               = 0
  1218. _disable_datalayer_sampling         = false
  1219. query_rewrite_enabled               = true
  1220. query_rewrite_integrity             = enforced
  1221. _query_cost_rewrite                 = true
  1222. _query_rewrite_2                    = true
  1223. _query_rewrite_1                    = true
  1224. _query_rewrite_expression           = true
  1225. _query_rewrite_jgmigrate            = true
  1226. _query_rewrite_fpc                  = true
  1227. _query_rewrite_drj                  = true
  1228. _full_pwise_join_enabled            = true
  1229. _partial_pwise_join_enabled         = true
  1230. _left_nested_loops_random           = true
  1231. _improved_row_length_enabled        = true
  1232. _index_join_enabled                 = true
  1233. _enable_type_dep_selectivity        = true
  1234. _improved_outerjoin_card            = true
  1235. _optimizer_adjust_for_nulls         = true
  1236. _optimizer_degree                   = 0
  1237. _use_column_stats_for_function      = true
  1238. _subquery_pruning_enabled           = true
  1239. _subquery_pruning_mv_enabled        = false
  1240. _or_expand_nvl_predicate            = true
  1241. _like_with_bind_as_equality         = false
  1242. _table_scan_cost_plus_one           = true
  1243. _cost_equality_semi_join            = true
  1244. _default_non_equality_sel_check     = true
  1245. _new_initial_join_orders            = true
  1246. _oneside_colstat_for_equijoins      = true
  1247. _optim_peek_user_binds              = true
  1248. _minimal_stats_aggregation          = true
  1249. _force_temptables_for_gsets         = false
  1250. workarea_size_policy                = auto
  1251. _smm_auto_cost_enabled              = true
  1252. _gs_anti_semi_join_allowed          = true
  1253. _optim_new_default_join_sel         = true
  1254. optimizer_dynamic_sampling          = 2
  1255. _pre_rewrite_push_pred              = true
  1256. _optimizer_new_join_card_computation = true
  1257. _union_rewrite_for_gs               = yes_gset_mvs
  1258. _generalized_pruning_enabled        = true
  1259. _optim_adjust_for_part_skews        = true
  1260. _force_datefold_trunc               = false
  1261. statistics_level                    = typical
  1262. _optimizer_system_stats_usage       = true
  1263. skip_unusable_indexes               = true
  1264. _remove_aggr_subquery               = true
  1265. _optimizer_push_down_distinct       = 0
  1266. _dml_monitoring_enabled             = true
  1267. _optimizer_undo_changes             = false
  1268. _predicate_elimination_enabled      = true
  1269. _nested_loop_fudge                  = 100
  1270. _project_view_columns               = true
  1271. _local_communication_costing_enabled = true
  1272. _local_communication_ratio          = 50
  1273. _query_rewrite_vop_cleanup          = true
  1274. _slave_mapping_enabled              = true
  1275. _optimizer_cost_based_transformation = linear
  1276. _optimizer_mjc_enabled              = true
  1277. _right_outer_hash_enable            = true
  1278. _spr_push_pred_refspr               = true
  1279. _optimizer_cache_stats              = false
  1280. _optimizer_cbqt_factor              = 50
  1281. _optimizer_squ_bottomup             = true
  1282. _fic_area_size                      = 131072
  1283. _optimizer_skip_scan_enabled        = true
  1284. _optimizer_cost_filter_pred         = false
  1285. _optimizer_sortmerge_join_enabled   = true
  1286. _optimizer_join_sel_sanity_check    = true
  1287. _mmv_query_rewrite_enabled          = true
  1288. _bt_mmv_query_rewrite_enabled       = true
  1289. _add_stale_mv_to_dependency_list    = true
  1290. _distinct_view_unnesting            = false
  1291. _optimizer_dim_subq_join_sel        = true
  1292. _optimizer_disable_strans_sanity_checks = 0
  1293. _optimizer_compute_index_stats      = true
  1294. _push_join_union_view2              = true
  1295. _optimizer_ignore_hints             = false
  1296. _optimizer_random_plan              = 0
  1297. _query_rewrite_setopgrw_enable      = true
  1298. _optimizer_correct_sq_selectivity   = true
  1299. _disable_function_based_index       = false
  1300. _optimizer_join_order_control       = 3
  1301. _optimizer_cartesian_enabled        = true
  1302. _optimizer_starplan_enabled         = true
  1303. _extended_pruning_enabled           = true
  1304. _optimizer_push_pred_cost_based     = true
  1305. _optimizer_null_aware_antijoin      = true
  1306. _optimizer_extend_jppd_view_types   = true
  1307. _sql_model_unfold_forloops          = run_time
  1308. _enable_dml_lock_escalation         = false
  1309. _bloom_filter_enabled               = true
  1310. _update_bji_ipdml_enabled           = 0
  1311. _optimizer_extended_cursor_sharing  = udo
  1312. _dm_max_shared_pool_pct             = 1
  1313. _optimizer_cost_hjsmj_multimatch    = true
  1314. _optimizer_transitivity_retain      = true
  1315. _px_pwg_enabled                     = true
  1316. optimizer_secure_view_merging       = true
  1317. _optimizer_join_elimination_enabled = true
  1318. flashback_table_rpi                 = non_fbt
  1319. _optimizer_cbqt_no_size_restriction = true
  1320. _optimizer_enhanced_filter_push     = true
  1321. _optimizer_filter_pred_pullup       = true
  1322. _rowsrc_trace_level                 = 0
  1323. _simple_view_merging                = true
  1324. _optimizer_rownum_pred_based_fkr    = true
  1325. _optimizer_better_inlist_costing    = all
  1326. _optimizer_self_induced_cache_cost  = false
  1327. _optimizer_min_cache_blocks         = 10
  1328. _optimizer_or_expansion             = depth
  1329. _optimizer_order_by_elimination_enabled = true
  1330. _optimizer_outer_to_anti_enabled    = true
  1331. _selfjoin_mv_duplicates             = true
  1332. _dimension_skip_null                = true
  1333. _force_rewrite_enable               = false
  1334. _optimizer_star_tran_in_with_clause = true
  1335. _optimizer_complex_pred_selectivity = true
  1336. _optimizer_connect_by_cost_based    = true
  1337. _gby_hash_aggregation_enabled       = true
  1338. _globalindex_pnum_filter_enabled    = true
  1339. _px_minus_intersect                 = true
  1340. _fix_control_key                    = 0
  1341. _force_slave_mapping_intra_part_loads = false
  1342. _force_tmp_segment_loads            = false
  1343. _query_mmvrewrite_maxpreds          = 10
  1344. _query_mmvrewrite_maxintervals      = 5
  1345. _query_mmvrewrite_maxinlists        = 5
  1346. _query_mmvrewrite_maxdmaps          = 10
  1347. _query_mmvrewrite_maxcmaps          = 20
  1348. _query_mmvrewrite_maxregperm        = 512
  1349. _query_mmvrewrite_maxqryinlistvals  = 500
  1350. _disable_parallel_conventional_load = false
  1351. _trace_virtual_columns              = false
  1352. _replace_virtual_columns            = true
  1353. _virtual_column_overload_allowed    = true
  1354. _kdt_buffering                      = true
  1355. _first_k_rows_dynamic_proration     = true
  1356. _optimizer_sortmerge_join_inequality = true
  1357. _optimizer_aw_stats_enabled         = true
  1358. _bloom_pruning_enabled              = true
  1359. result_cache_mode                   = MANUAL
  1360. _px_ual_serial_input                = true
  1361. _optimizer_skip_scan_guess          = false
  1362. _enable_row_shipping                = true
  1363. _row_shipping_threshold             = 80
  1364. _row_shipping_explain               = false
  1365. transaction_isolation_level         = read_commited
  1366. _optimizer_distinct_elimination     = true
  1367. _optimizer_multi_level_push_pred    = true
  1368. _optimizer_group_by_placement       = true
  1369. _optimizer_rownum_bind_default      = 10
  1370. _enable_query_rewrite_on_remote_objs = true
  1371. _optimizer_extended_cursor_sharing_rel = simple
  1372. _optimizer_adaptive_cursor_sharing  = true
  1373. _direct_path_insert_features        = 0
  1374. _optimizer_improve_selectivity      = true
  1375. optimizer_use_pending_statistics    = false
  1376. _optimizer_enable_density_improvements = true
  1377. _optimizer_aw_join_push_enabled     = true
  1378. _optimizer_connect_by_combine_sw    = true
  1379. _enable_pmo_ctas                    = 0
  1380. _optimizer_native_full_outer_join   = force
  1381. _bloom_predicate_enabled            = true
  1382. _optimizer_enable_extended_stats    = true
  1383. _is_lock_table_for_ddl_wait_lock    = 0
  1384. _pivot_implementation_method        = choose
  1385. optimizer_capture_sql_plan_baselines = false
  1386. optimizer_use_sql_plan_baselines    = true
  1387. _optimizer_star_trans_min_cost      = 0
  1388. _optimizer_star_trans_min_ratio     = 0
  1389. _with_subquery                      = OPTIMIZER
  1390. _optimizer_fkr_index_cost_bias      = 10
  1391. _optimizer_use_subheap              = true
  1392. parallel_degree_policy              = manual
  1393. parallel_degree                     = 0
  1394. parallel_min_time_threshold         = 10
  1395. _parallel_time_unit                 = 10
  1396. _optimizer_or_expansion_subheap     = true
  1397. _optimizer_free_transformation_heap = true
  1398. _optimizer_reuse_cost_annotations   = true
  1399. _result_cache_auto_size_threshold   = 100
  1400. _result_cache_auto_time_threshold   = 1000
  1401. _optimizer_nested_rollup_for_gset   = 100
  1402. _nlj_batching_enabled               = 1
  1403. parallel_query_default_dop          = 0
  1404. is_recur_flags                      = 0
  1405. optimizer_use_invisible_indexes     = false
  1406. flashback_data_archive_internal_cursor = 0
  1407. _optimizer_extended_stats_usage_control = 192
  1408. _parallel_syspls_obey_force         = true
  1409. cell_offload_processing             = true
  1410. _rdbms_internal_fplib_enabled       = false
  1411. db_file_multiblock_read_count       = 32
  1412. _bloom_folding_enabled              = true
  1413. _mv_generalized_oj_refresh_opt      = true
  1414. cell_offload_compaction             = ADAPTIVE
  1415. cell_offload_plan_display           = AUTO
  1416. _bloom_predicate_pushdown_to_storage = true
  1417. _bloom_vector_elements              = 0
  1418. _bloom_pushing_max                  = 512
  1419. parallel_degree_limit               = 65535
  1420. parallel_force_local                = false
  1421. parallel_max_degree                 = 48
  1422. total_cpu_count                     = 24
  1423. _optimizer_coalesce_subqueries      = true
  1424. _optimizer_fast_pred_transitivity   = true
  1425. _optimizer_fast_access_pred_analysis = true
  1426. _optimizer_unnest_disjunctive_subq  = true
  1427. _optimizer_unnest_corr_set_subq     = true
  1428. _optimizer_distinct_agg_transform   = true
  1429. _aggregation_optimization_settings  = 0
  1430. _optimizer_connect_by_elim_dups     = true
  1431. _optimizer_eliminate_filtering_join = true
  1432. _connect_by_use_union_all           = true
  1433. dst_upgrade_insert_conv             = true
  1434. advanced_queuing_internal_cursor    = 0
  1435. _optimizer_unnest_all_subqueries    = true
  1436. parallel_autodop                    = 0
  1437. parallel_ddldml                     = 0
  1438. _parallel_cluster_cache_policy      = adaptive
  1439. _parallel_scalability               = 50
  1440. iot_internal_cursor                 = 0
  1441. _optimizer_instance_count           = 0
  1442. _optimizer_connect_by_cb_whr_only   = false
  1443. _suppress_scn_chk_for_cqn           = nosuppress_1466
  1444. _optimizer_join_factorization       = true
  1445. _optimizer_use_cbqt_star_transformation = true
  1446. _optimizer_table_expansion          = true
  1447. _and_pruning_enabled                = true
  1448. _deferred_constant_folding_mode     = DEFAULT
  1449. _optimizer_distinct_placement       = true
  1450. partition_pruning_internal_cursor   = 0
  1451. parallel_hinted                     = none
  1452. _sql_compatibility                  = 0
  1453. _optimizer_use_feedback             = true
  1454. _optimizer_try_st_before_jppd       = true
  1455. _dml_frequency_tracking             = false
  1456. _optimizer_interleave_jppd          = true
  1457. kkb_drop_empty_segments             = 0
  1458. _px_partition_scan_enabled          = true
  1459. _px_partition_scan_threshold        = 64
  1460. _optimizer_false_filter_pred_pullup = true
  1461. _bloom_minmax_enabled               = true
  1462. only_move_row                       = 0
  1463. _optimizer_enable_table_lookup_by_nl = true
  1464. Bug Fix Control Environment
  1465.     fix  3834770 = 1      
  1466.     fix  3746511 = enabled
  1467.     fix  4519016 = enabled
  1468.     fix  3118776 = enabled
  1469.     fix  4488689 = enabled
  1470.     fix  2194204 = disabled
  1471.     fix  2660592 = enabled
  1472.     fix  2320291 = enabled
  1473.     fix  2324795 = enabled
  1474.     fix  4308414 = enabled
  1475.     fix  3499674 = disabled
  1476.     fix  4569940 = enabled
  1477.     fix  4631959 = enabled
  1478.     fix  4519340 = enabled
  1479.     fix  4550003 = enabled
  1480.     fix  1403283 = enabled
  1481.     fix  4554846 = enabled
  1482.     fix  4602374 = enabled
  1483.     fix  4584065 = enabled
  1484.     fix  4545833 = enabled
  1485.     fix  4611850 = enabled
  1486.     fix  4663698 = enabled
  1487.     fix  4663804 = enabled
  1488.     fix  4666174 = enabled
  1489.     fix  4567767 = enabled
  1490.     fix  4556762 = 15     
  1491.     fix  4728348 = enabled
  1492.     fix  4708389 = enabled
  1493.     fix  4175830 = enabled
  1494.     fix  4752814 = enabled
  1495.     fix  4583239 = enabled
  1496.     fix  4386734 = enabled
  1497.     fix  4887636 = enabled
  1498.     fix  4483240 = enabled
  1499.     fix  4872602 = disabled
  1500.     fix  4711525 = enabled
  1501.     fix  4545802 = enabled
  1502.     fix  4605810 = enabled
  1503.     fix  4704779 = enabled
  1504.     fix  4900129 = enabled
  1505.     fix  4924149 = enabled
  1506.     fix  4663702 = enabled
  1507.     fix  4878299 = enabled
  1508.     fix  4658342 = enabled
  1509.     fix  4881533 = enabled
  1510.     fix  4676955 = enabled
  1511.     fix  4273361 = enabled
  1512.     fix  4967068 = enabled
  1513.     fix  4969880 = disabled
  1514.     fix  5005866 = enabled
  1515.     fix  5015557 = enabled
  1516.     fix  4705343 = enabled
  1517.     fix  4904838 = enabled
  1518.     fix  4716096 = enabled
  1519.     fix  4483286 = disabled
  1520.     fix  4722900 = enabled
  1521.     fix  4615392 = enabled
  1522.     fix  5096560 = enabled
  1523.     fix  5029464 = enabled
  1524.     fix  4134994 = enabled
  1525.     fix  4904890 = enabled
  1526.     fix  5104624 = enabled
  1527.     fix  5014836 = enabled
  1528.     fix  4768040 = enabled
  1529.     fix  4600710 = enabled
  1530.     fix  5129233 = enabled
  1531.     fix  4595987 = enabled
  1532.     fix  4908162 = enabled
  1533.     fix  5139520 = enabled
  1534.     fix  5084239 = enabled
  1535.     fix  5143477 = disabled
  1536.     fix  2663857 = enabled
  1537.     fix  4717546 = enabled
  1538.     fix  5240264 = disabled
  1539.     fix  5099909 = enabled
  1540.     fix  5240607 = enabled
  1541.     fix  5195882 = enabled
  1542.     fix  5220356 = enabled
  1543.     fix  5263572 = enabled
  1544.     fix  5385629 = enabled
  1545.     fix  5302124 = enabled
  1546.     fix  5391942 = enabled
  1547.     fix  5384335 = enabled
  1548.     fix  5482831 = enabled
  1549.     fix  4158812 = enabled
  1550.     fix  5387148 = enabled
  1551.     fix  5383891 = enabled
  1552.     fix  5466973 = enabled
  1553.     fix  5396162 = enabled
  1554.     fix  5394888 = enabled
  1555.     fix  5395291 = enabled
  1556.     fix  5236908 = enabled
  1557.     fix  5509293 = enabled
  1558.     fix  5449488 = enabled
  1559.     fix  5567933 = enabled
  1560.     fix  5570494 = enabled
  1561.     fix  5288623 = enabled
  1562.     fix  5505995 = enabled
  1563.     fix  5505157 = enabled
  1564.     fix  5112460 = enabled
  1565.     fix  5554865 = enabled
  1566.     fix  5112260 = enabled
  1567.     fix  5112352 = enabled
  1568.     fix  5547058 = enabled
  1569.     fix  5618040 = enabled
  1570.     fix  5585313 = enabled
  1571.     fix  5547895 = enabled
  1572.     fix  5634346 = enabled
  1573.     fix  5620485 = enabled
  1574.     fix  5483301 = enabled
  1575.     fix  5657044 = enabled
  1576.     fix  5694984 = enabled
  1577.     fix  5868490 = enabled
  1578.     fix  5650477 = enabled
  1579.     fix  5611962 = enabled
  1580.     fix  4279274 = enabled
  1581.     fix  5741121 = enabled
  1582.     fix  5714944 = enabled
  1583.     fix  5391505 = enabled
  1584.     fix  5762598 = enabled
  1585.     fix  5578791 = enabled
  1586.     fix  5259048 = enabled
  1587.     fix  5882954 = enabled
  1588.     fix  2492766 = enabled
  1589.     fix  5707608 = enabled
  1590.     fix  5891471 = enabled
  1591.     fix  5884780 = enabled
  1592.     fix  5680702 = enabled
  1593.     fix  5371452 = enabled
  1594.     fix  5838613 = enabled
  1595.     fix  5949981 = enabled
  1596.     fix  5624216 = enabled
  1597.     fix  5741044 = enabled
  1598.     fix  5976822 = enabled
  1599.     fix  6006457 = enabled
  1600.     fix  5872956 = enabled
  1601.     fix  5923644 = enabled
  1602.     fix  5943234 = enabled
  1603.     fix  5844495 = enabled
  1604.     fix  4168080 = enabled
  1605.     fix  6020579 = enabled
  1606.     fix  5842686 = disabled
  1607.     fix  5996801 = enabled
  1608.     fix  5593639 = enabled
  1609.     fix  6133948 = enabled
  1610.     fix  3151991 = enabled
  1611.     fix  6146906 = enabled
  1612.     fix  6239909 = enabled
  1613.     fix  6267621 = enabled
  1614.     fix  5909305 = enabled
  1615.     fix  6279918 = enabled
  1616.     fix  6141818 = enabled
  1617.     fix  6151963 = enabled
  1618.     fix  6251917 = enabled
  1619.     fix  6282093 = enabled
  1620.     fix  6119510 = enabled
  1621.     fix  6119382 = enabled
  1622.     fix  3801750 = enabled
  1623.     fix  5705630 = disabled
  1624.     fix  5944076 = enabled
  1625.     fix  5406763 = enabled
  1626.     fix  6070954 = enabled
  1627.     fix  6282944 = enabled
  1628.     fix  6138746 = enabled
  1629.     fix  6082745 = enabled
  1630.     fix  3426050 = enabled
  1631.     fix   599680 = enabled
  1632.     fix  6062266 = enabled
  1633.     fix  6087237 = enabled
  1634.     fix  6122894 = enabled
  1635.     fix  6377505 = enabled
  1636.     fix  5893768 = enabled
  1637.     fix  6163564 = enabled
  1638.     fix  6073325 = enabled
  1639.     fix  6188881 = enabled
  1640.     fix  6007259 = enabled
  1641.     fix  6239971 = enabled
  1642.     fix  5284200 = disabled
  1643.     fix  6042205 = enabled
  1644.     fix  6051211 = enabled
  1645.     fix  6434668 = enabled
  1646.     fix  6438752 = enabled
  1647.     fix  5936366 = enabled
  1648.     fix  6439032 = enabled
  1649.     fix  6438892 = enabled
  1650.     fix  6006300 = enabled
  1651.     fix  5947231 = enabled
  1652.     fix  5416118 = 1      
  1653.     fix  6365442 = 1      
  1654.     fix  6239039 = enabled
  1655.     fix  6502845 = enabled
  1656.     fix  6913094 = enabled
  1657.     fix  6029469 = enabled
  1658.     fix  5919513 = enabled
  1659.     fix  6057611 = enabled
  1660.     fix  6469667 = enabled
  1661.     fix  6608941 = disabled
  1662.     fix  6368066 = enabled
  1663.     fix  6329318 = enabled
  1664.     fix  6656356 = enabled
  1665.     fix  4507997 = enabled
  1666.     fix  6671155 = enabled
  1667.     fix  6694548 = enabled
  1668.     fix  6688200 = enabled
  1669.     fix  6612471 = enabled
  1670.     fix  6708183 = disabled
  1671.     fix  6326934 = enabled
  1672.     fix  6520717 = disabled
  1673.     fix  6714199 = enabled
  1674.     fix  6681545 = enabled
  1675.     fix  6748058 = enabled
  1676.     fix  6167716 = enabled
  1677.     fix  6674254 = enabled
  1678.     fix  6468287 = enabled
  1679.     fix  6503543 = enabled
  1680.     fix  6808773 = disabled
  1681.     fix  6766962 = enabled
  1682.     fix  6120483 = enabled
  1683.     fix  6670551 = enabled
  1684.     fix  6771838 = enabled
  1685.     fix  6626018 = disabled
  1686.     fix  6530596 = enabled
  1687.     fix  6778642 = enabled
  1688.     fix  6699059 = enabled
  1689.     fix  6376551 = enabled
  1690.     fix  6429113 = enabled
  1691.     fix  6782437 = enabled
  1692.     fix  6776808 = enabled
  1693.     fix  6765823 = enabled
  1694.     fix  6768660 = enabled
  1695.     fix  6782665 = enabled
  1696.     fix  6610822 = enabled
  1697.     fix  6514189 = enabled
  1698.     fix  6818410 = enabled
  1699.     fix  6827696 = enabled
  1700.     fix  6773613 = enabled
  1701.     fix  5902962 = enabled
  1702.     fix  6956212 = enabled
  1703.     fix  3056297 = enabled
  1704.     fix  6440977 = disabled
  1705.     fix  6972291 = disabled
  1706.     fix  6904146 = enabled
  1707.     fix  6221403 = enabled
  1708.     fix  5475051 = enabled
  1709.     fix  6845871 = enabled
  1710.     fix  5468809 = enabled
  1711.     fix  6917633 = enabled
  1712.     fix  4444536 = disabled
  1713.     fix  6955210 = enabled
  1714.     fix  6994194 = enabled
  1715.     fix  6399597 = disabled
  1716.     fix  6951776 = enabled
  1717.     fix  5648287 = 3      
  1718.     fix  6987082 = disabled
  1719.     fix  7132036 = enabled
  1720.     fix  6980350 = enabled
  1721.     fix  5199213 = enabled
  1722.     fix  7138405 = enabled
  1723.     fix  7148689 = enabled
  1724.     fix  6820988 = enabled
  1725.     fix  7032684 = enabled
  1726.     fix  6617866 = enabled
  1727.     fix  7155968 = enabled
  1728.     fix  7127980 = enabled
  1729.     fix  6982954 = enabled
  1730.     fix  7241819 = enabled
  1731.     fix  6897034 = enabled
  1732.     fix  7236148 = enabled
  1733.     fix  7298570 = enabled
  1734.     fix  7249095 = enabled
  1735.     fix  7314499 = enabled
  1736.     fix  7324224 = enabled
  1737.     fix  7289023 = enabled
  1738.     fix  7237571 = enabled
  1739.     fix  7116357 = enabled
  1740.     fix  7345484 = enabled
  1741.     fix  7375179 = enabled
  1742.     fix  6430500 = disabled
  1743.     fix  5897486 = enabled
  1744.     fix  6774209 = enabled
  1745.     fix  7306637 = enabled
  1746.     fix  6451322 = enabled
  1747.     fix  7208131 = enabled
  1748.     fix  7388652 = enabled
  1749.     fix  7127530 = enabled
  1750.     fix  6751206 = enabled
  1751.     fix  6669103 = enabled
  1752.     fix  7430474 = enabled
  1753.     fix  6990305 = enabled
  1754.     fix  7043307 = enabled
  1755.     fix  3120429 = enabled
  1756.     fix  7452823 = disabled
  1757.     fix  6838105 = enabled
  1758.     fix  6769711 = enabled
  1759.     fix  7170213 = enabled
  1760.     fix  6528872 = enabled
  1761.     fix  7295298 = enabled
  1762.     fix  5922070 = enabled
  1763.     fix  7259468 = enabled
  1764.     fix  6418552 = enabled
  1765.     fix  4619997 = enabled
  1766.     fix  7524366 = enabled
  1767.     fix  6942476 = enabled
  1768.     fix  6418771 = enabled
  1769.     fix  7375077 = enabled
  1770.     fix  5400639 = enabled
  1771.     fix  4570921 = enabled
  1772.     fix  7426911 = enabled
  1773.     fix  5099019 = disabled
  1774.     fix  7528216 = enabled
  1775.     fix  7521266 = enabled
  1776.     fix  7385140 = enabled
  1777.     fix  7576516 = enabled
  1778.     fix  7573526 = enabled
  1779.     fix  7576476 = enabled
  1780.     fix  7165898 = enabled
  1781.     fix  7263214 = enabled
  1782.     fix  3320140 = enabled
  1783.     fix  7555510 = enabled
  1784.     fix  7613118 = enabled
  1785.     fix  7597059 = enabled
  1786.     fix  7558911 = enabled
  1787.     fix  5520732 = enabled
  1788.     fix  7679490 = disabled
  1789.     fix  7449971 = enabled
  1790.     fix  3628118 = enabled
  1791.     fix  4370840 = enabled
  1792.     fix  7281191 = enabled
  1793.     fix  7519687 = enabled
  1794.     fix  5029592 = 3      
  1795.     fix  6012093 = 1      
  1796.     fix  6053861 = disabled
  1797.     fix  6941515 = disabled
  1798.     fix  7696414 = enabled
  1799.     fix  7272039 = enabled
  1800.     fix  7834811 = enabled
  1801.     fix  7640597 = enabled
  1802.     fix  7341616 = enabled
  1803.     fix  7168184 = enabled
  1804.     fix   399198 = enabled
  1805.     fix  7831070 = enabled
  1806.     fix  7676897 = disabled
  1807.     fix  7414637 = enabled
  1808.     fix  7585456 = enabled
  1809.     fix  8202421 = enabled
  1810.     fix  7658097 = disabled
  1811.     fix  8251486 = enabled
  1812.     fix  7132684 = enabled
  1813.     fix  7512227 = enabled
  1814.     fix  6972987 = enabled
  1815.     fix  7199035 = enabled
  1816.     fix  8243446 = enabled
  1817.     fix  7650462 = enabled
  1818.     fix  6720701 = enabled
  1819.     fix  7592673 = enabled
  1820.     fix  7718694 = enabled
  1821.     fix  7534027 = enabled
  1822.     fix  7708267 = enabled
  1823.     fix  5716785 = enabled
  1824.     fix  7356191 = enabled
  1825.     fix  7679161 = enabled
  1826.     fix  7597159 = enabled
  1827.     fix  7499258 = enabled
  1828.     fix  8328363 = enabled
  1829.     fix  7452863 = enabled
  1830.     fix  8284930 = enabled
  1831.     fix  7298626 = enabled
  1832.     fix  7657126 = enabled
  1833.     fix  8371884 = enabled
  1834.     fix  8318020 = enabled
  1835.     fix  8255423 = enabled
  1836.     fix  7135745 = enabled
  1837.     fix  8356253 = enabled
  1838.     fix  7534257 = enabled
  1839.     fix  8323407 = enabled
  1840.     fix  7539815 = enabled
  1841.     fix  8289316 = enabled
  1842.     fix  8447850 = enabled
  1843.     fix  7675944 = enabled
  1844.     fix  8355120 = enabled
  1845.     fix  7176746 = enabled
  1846.     fix  8442891 = enabled
  1847.     fix  8373261 = enabled
  1848.     fix  7679164 = enabled
  1849.     fix  7670533 = enabled
  1850.     fix  8408665 = enabled
  1851.     fix  8491399 = enabled
  1852.     fix  8348392 = enabled
  1853.     fix  8348585 = enabled
  1854.     fix  8508056 = enabled
  1855.     fix  8335178 = enabled
  1856.     fix  8515269 = enabled
  1857.     fix  8247017 = enabled
  1858.     fix  7325597 = enabled
  1859.     fix  8531490 = enabled
  1860.     fix  6163600 = enabled
  1861.     fix  8589278 = disabled
  1862.     fix  8557992 = enabled
  1863.     fix  7556098 = enabled
  1864.     fix  8580883 = enabled
  1865.     fix  5892599 = disabled
  1866.     fix  8609714 = enabled
  1867.     fix  8619631 = disabled
  1868.     fix  8672915 = enabled
  1869.     fix  8514561 = enabled
  1870.     fix  8213977 = enabled
  1871.     fix  8560951 = disabled
  1872.     fix  8578587 = enabled
  1873.     fix  8287870 = enabled
  1874.     fix  8467123 = enabled
  1875.     fix  8602185 = enabled
  1876.     fix  8519457 = enabled
  1877.     fix  3335182 = enabled
  1878.     fix  8602840 = enabled
  1879.     fix  8725296 = enabled
  1880.     fix  8628970 = enabled
  1881.     fix  6754080 = enabled
  1882.     fix  8767442 = enabled
  1883.     fix  8760135 = enabled
  1884.     fix  8644935 = enabled
  1885.     fix  8352378 = enabled
  1886.     fix  8685327 = enabled
  1887.     fix  8763472 = enabled
  1888.     fix  8773324 = enabled
  1889.     fix  8813674 = enabled
  1890.     fix  8532236 = enabled
  1891.     fix  8629716 = enabled
  1892.     fix  7277732 = enabled
  1893.     fix  8692170 = enabled
  1894.     fix  8900973 = enabled
  1895.     fix  8919133 = enabled
  1896.     fix  8927050 = enabled
  1897.     fix  8551880 = enabled
  1898.     fix  8901237 = enabled
  1899.     fix  8812372 = enabled
  1900.     fix  6236862 = enabled
  1901.     fix  8528517 = enabled
  1902.     fix  7215982 = enabled
  1903.     fix  8214022 = enabled
  1904.     fix  8595392 = enabled
  1905.     fix  8890233 = enabled
  1906.     fix  8999317 = enabled
  1907.     fix  9004800 = enabled
  1908.     fix  8986163 = enabled
  1909.     fix  8855396 = enabled
  1910.     fix  8800514 = 20     
  1911.     fix  9007859 = enabled
  1912.     fix  8198783 = enabled
  1913.     fix  9053879 = enabled
  1914.     fix  6086930 = enabled
  1915.     fix  7641601 = enabled
  1916.     fix  9052506 = enabled
  1917.     fix  9103775 = enabled
  1918.     fix  9047975 = enabled
  1919.     fix  8893626 = enabled
  1920.     fix  9111170 = enabled
  1921.     fix  8971829 = enabled
  1922.     fix  7628358 = enabled
  1923.     fix  9125151 = enabled
  1924.     fix  9039715 = enabled
  1925.     fix  9106224 = enabled
  1926.     fix  9185228 = enabled
  1927.     fix  9206747 = enabled
  1928.     fix  9088510 = enabled
  1929.     fix  9143856 = enabled
  1930.     fix  8833381 = enabled
  1931.     fix  8949971 = enabled
  1932.     fix  8951812 = enabled
  1933.     fix  9148171 = enabled
  1934.     fix  8706652 = enabled
  1935.     fix  9245114 = enabled
  1936.     fix  8802198 = enabled
  1937.     fix  9011016 = enabled
  1938.     fix  9265681 = enabled
  1939.     fix  7284269 = enabled
  1940.     fix  9272549 = enabled
  1941.     fix  8917507 = 7      
  1942.     fix  8531463 = enabled
  1943.     fix  9263333 = enabled
  1944.     fix  8675087 = enabled
  1945.     fix  8571403 = enabled
  1946.     fix  8896955 = enabled
  1947.     fix  9041934 = enabled
  1948.     fix  9344709 = enabled
  1949.     fix  9024933 = enabled
  1950.     fix  9033718 = enabled
  1951.     fix  9240455 = enabled
  1952.     fix  9081848 = enabled
  1953.     fix  5982893 = enabled
  1954.     fix  9287401 = enabled
  1955.     fix  8590021 = enabled
  1956.     fix  9340120 = enabled
  1957.     fix  9355794 = enabled
  1958.     fix  9356656 = enabled
  1959.     fix  9385634 = enabled
  1960.     fix  9069046 = enabled
  1961.     fix  9239337 = enabled
  1962.     fix  9300228 = enabled
  1963.     fix  9298010 = enabled
  1964.     fix  9384170 = enabled
  1965.     fix  9301862 = disabled
  1966.     fix  9407929 = enabled
  1967.     fix  8836806 = enabled
  1968.     fix  9344055 = enabled
  1969.     fix  9274675 = enabled
  1970.     fix  9203723 = enabled
  1971.     fix  9443476 = enabled
  1972.     fix  9195582 = enabled
  1973.     fix  8226666 = enabled
  1974.     fix  9433490 = enabled
  1975.     fix  9065494 = enabled
  1976.     fix  9303766 = enabled
  1977.     fix  9437283 = enabled
  1978.     fix  9116214 = enabled
  1979.     fix  9456688 = enabled
  1980.     fix  9456746 = disabled
  1981.     fix  9342979 = enabled
  1982.     fix  9465425 = enabled
  1983.     fix  9092442 = enabled
  1984.     fix  4926618 = enabled
  1985.     fix  8792846 = enabled
  1986.     fix  9474259 = enabled
  1987.     fix  9495669 = disabled
  1988.     fix  6472966 = enabled
  1989.     fix  6408301 = enabled
  1990.     fix  9380298 = disabled
  1991.     fix  8500130 = enabled
  1992.     fix  9584723 = enabled
  1993.     fix  9270951 = enabled
  1994.     fix  9508254 = enabled
  1995.     fix  9593680 = enabled
  1996.     fix  9196440 = disabled
  1997.     fix  9309281 = enabled
  1998.     fix  8693158 = enabled
  1999.     fix  9381638 = enabled
  2000.     fix  9383967 = enabled
  2001.     fix  7711900 = enabled
  2002.     fix  9218587 = enabled
  2003.     fix  9728438 = enabled
  2004.     fix  9038395 = enabled
  2005.     fix  9577300 = enabled
  2006.     fix  9171113 = enabled
  2007.     fix  8973745 = enabled
  2008.     fix  9732434 = enabled
  2009.     fix  8937971 = disabled
  2010.     fix  9102474 = enabled
  2011.     fix  9243499 = enabled
  2012.     fix  9912503 = enabled
  2013.     fix  9153459 = enabled
  2014.     fix  9762592 = 3      
  2015.     fix  9785632 = enabled
  2016. Query Block Registry:
  2017. SEL$1 0xad486a80 (PARSER) [FINAL]
  2018. :
  2019.     call(in-use=9496, alloc=32816), compile(in-use=82888, alloc=145112), execution(in-use=4864, alloc=8088)
  2020. End of Optimizer State Dump
  2021. Dumping Hints
  2022. =============
  2023. ====================== END SQL Statement Dump ======================
  2024.  doug:/app/ora/local/admin/TEST1102/diag/rdbms/TEST1102_doug/TEST1102/trace/TEST1102_ora_1450_DOUG_TEST2.trc at Mon Mar 18 2013 11:00 GMT