10053 trace 분석해보다. 특정부분은 light blue color 를 넣어보았다.
SQL> exec dbms_stats.GATHER_TABLE_STATS(OWNNAME=>'SCOTT',TABNAME=>'EMP',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE,METHOD_OPT=>'FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS' , DEGREE=>5,CASCADE=>TRUE);
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.GATHER_TABLE_STATS(OWNNAME=>'SCOTT',TABNAME=>'DEPT',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE,METHOD_OPT=>'FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS' , DEGREE=>5,CASCADE=>TRUE);
PL/SQL procedure successfully completed.
SQL> alter session set events '10053 trace name context forever, level 2';
Session altered.
SQL> variable v1 varchar2(30)
SQL> variable v2 varchar2(10)
SQL> variable v2 varchar2(10)
SQL> begin
2 :v1 := '20110401';
3 :v2 := 'CJJ';
3 :v2 := 'CJJ';
4 end ;
5 /
PL/SQL procedure successfully completed.
SQL>
SELECT "B"."RECORDLOCATOR" "RECORDLOCATOR","BP"."FULLNAME" "FULLNAME","PJS"."SEGMENTID" "SEGMENTID","PJS"."DEPARTUREDATE" "DEPARTUREDATE","PJS"."FLIGHTNUMBER" "FLIGHTNUMBER","PJS"."DEPARTURESTATION" "DEPARTURESTATION","PJS"."ARRIVALSTATION" "ARRIVALSTATION"
FROM "EJMIS"."BOOKING" "B","EJMIS"."BOOKINGPASSENGER" "BP","EJMIS"."PASSENGERJOURNEYSEGMENT" "PJS"
WHERE "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2SELECT "B"."RECORDLOCATOR" "RECORDLOCATOR","BP"."FULLNAME" "FULLNAME","PJS"."SEGMENTID" "SEGMENTID","PJS"."DEPARTUREDATE" "DEPARTUREDATE","PJS"."FLIGHTNUMBER" "FLIGHTNUMBER","PJS"."DEPARTURESTATION" "DEPARTURESTATION","PJS"."ARRIVALSTATION" "ARRIVALSTATION" FROM "EJMIS"."BOOKING" "B","EJMIS"."BOOKINGPASSENGER" "BP","EJMIS"."PASSENGERJOURNEYSEGMENT" "PJS" WHERE "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID"
AND "PJS"."DEPARTUREDATE"=:B1
AND "PJS"."DEPARTURESTATION"=:B2
FROM "EJMIS"."BOOKING" "B","EJMIS"."BOOKINGPASSENGER" "BP","EJMIS"."PASSENGERJOURNEYSEGMENT" "PJS"
WHERE "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2SELECT "B"."RECORDLOCATOR" "RECORDLOCATOR","BP"."FULLNAME" "FULLNAME","PJS"."SEGMENTID" "SEGMENTID","PJS"."DEPARTUREDATE" "DEPARTUREDATE","PJS"."FLIGHTNUMBER" "FLIGHTNUMBER","PJS"."DEPARTURESTATION" "DEPARTURESTATION","PJS"."ARRIVALSTATION" "ARRIVALSTATION" FROM "EJMIS"."BOOKING" "B","EJMIS"."BOOKINGPASSENGER" "BP","EJMIS"."PASSENGERJOURNEYSEGMENT" "PJS" WHERE "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID"
AND "PJS"."DEPARTUREDATE"=:B1
AND "PJS"."DEPARTURESTATION"=:B2
====================
Registered qb: MISC$1 0x104458f8 (PARSER)
signature(): NULL
**************************
Predicate Move-Around (PM)
**************************
PM: Considering predicate move-around in MISC$1 (#0).
PM: Checking validity of predicate move-around in MISC$1 (#0).
CBQT: Validity checks failed for 1xk6jwzgrb9um.
CVM: Considering view merge in query block MISC$1 (#0)
CBQT: Validity checks failed for 1xk6jwzgrb9um.
***************
Subquery Unnest
***************
SU: Considering subquery unnesting in query block MISC$1 (#0)
*************************
Set-Join Conversion (SJC)
*************************
SJC: Considering set-join conversion in MISC$1 (#0).
**************************
Predicate Move-Around (PM)
**************************
PM: Considering predicate move-around in MISC$1 (#0).
PM: Checking validity of predicate move-around in MISC$1 (#0).
PM: PM bypassed: Outer query contains no views.
Registered qb: SEL$1 0x10447ae0 (PARSER)
signature (): qb_name=SEL$1 nbfros=3 flg=0
fro(0): flg=4 objn=178683 hint_alias="B"@"SEL$1"
fro(1): flg=4 objn=178692 hint_alias="BP"@"SEL$1"
fro(2): flg=4 objn=182667 hint_alias="PJS"@"SEL$1"
**************************
Predicate Move-Around (PM)
**************************
PM: Considering predicate move-around in SEL$1 (#0).
PM: Checking validity of predicate move-around in SEL$1 (#0).
CBQT: Validity checks failed for 1bnm0qmwr9325.
Query block (110447ae0) before join elimination:
SQL:******* UNPARSED QUERY IS *******
SELECT "B"."RECORDLOCATOR" "RECORDLOCATOR","BP"."FULLNAME" "FULLNAME","PJS"."SEGMENTID" "SEGMENTID","PJS"."DEPARTUREDATE" "DEPARTUREDATE","PJS"."FLIGHTNUMBER" "FLIGHTNUMBER","PJS"."DEPARTURESTATION" "DEPARTURESTATION","PJS"."ARRIVALSTATION" "ARRIVALSTATION" FROM "EJMIS"."BOOKING" "B","EJMIS"."BOOKINGPASSENGER" "BP","EJMIS"."PASSENGERJOURNEYSEGMENT" "PJS" WHERE "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2
Query block (110447ae0) unchanged
CVM: Considering view merge in query block SEL$1 (#0)
Query block (110447ae0) before join elimination:
SQL:******* UNPARSED QUERY IS *******
SELECT "B"."RECORDLOCATOR" "RECORDLOCATOR","BP"."FULLNAME" "FULLNAME","PJS"."SEGMENTID" "SEGMENTID","PJS"."DEPARTUREDATE" "DEPARTUREDATE","PJS"."FLIGHTNUMBER" "FLIGHTNUMBER","PJS"."DEPARTURESTATION" "DEPARTURESTATION","PJS"."ARRIVALSTATION" "ARRIVALSTATION" FROM "EJMIS"."BOOKING" "B","EJMIS"."BOOKINGPASSENGER" "BP","EJMIS"."PASSENGERJOURNEYSEGMENT" "PJS" WHERE "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2
Query block (110447ae0) unchanged
CBQT: Validity checks failed for 1bnm0qmwr9325.
***************
Subquery Unnest
***************
SU: Considering subquery unnesting in query block SEL$1 (#0)
*************************
Set-Join Conversion (SJC)
*************************
SJC: Considering set-join conversion in SEL$1 (#0).
**************************
Predicate Move-Around (PM)
**************************
PM: Considering predicate move-around in SEL$1 (#0).
PM: Checking validity of predicate move-around in SEL$1 (#0).
PM: PM bypassed: Outer query contains no views.
FPD: Considering simple filter push in SEL$1 (#0)
FPD: Current where clause predicates in SEL$1 (#0) :
"B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2
kkogcp: try to generate transitive predicate from check constraints for SEL$1 (#0)
predicates with check contraints: "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2
after transitive predicate generation: "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2
finally: "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2
apadrv-start: call(in-use=2744, alloc=16344), compile(in-use=50520, alloc=54648)
kkoqbc-start
: call(in-use=2752, alloc=16344), compile(in-use=52008, alloc=54648)
kkoqbc-subheap (create addr=11044c690)
******************************************
Current SQL statement for this session:
select /*+ 10053 */ b.recordlocator, bp.fullname,
pjs.segmentid, pjs.departuredate, pjs.flightnumber, pjs.departurestation, pjs.arrivalstation
from ejmis.booking b, ejmis.bookingpassenger bp, ejmis.passengerjourneysegment pjs
where b.bookingid = bp.bookingid
and bp.passengerid = pjs.passengerid
and pjs.departuredate = :v1 and pjs.departurestation = :v2
*******************************************
Legend
The following abbreviations are used by optimizer trace.
CBQT - cost-based query transformation
JPPD - join predicate push-down
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
ST - star transformation
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)
CPUCSPEED - 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)
512: 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
128: use hash partitioning dimension
256: use range partitioning dimension
2048: use list partitioning dimension
1024: run the join in serial
0: invalid distribution method
sel - selectivity
ptn - partition
*******************************************
Peeked values of the binds in SQL statement
*******************************************
kkscoacd
Bind#0
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=846 siz=64 off=0
kxsbbbfp=110577aa8 bln=32 avl=08 flg=05
value="20110430"
Bind#1
oacdty=01 mxl=32(10) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=846 siz=0 off=32
kxsbbbfp=110577ac8 bln=32 avl=03 flg=01
value="CJJ"
***************************************
PARAMETERS USED BY THE OPTIMIZER
********************************
*************************************
PARAMETERS WITH ALTERED VALUES
******************************
optimizer_mode = first_rows
optimizer_index_cost_adj = 50
optimizer_index_caching = 20
query_rewrite_integrity = trusted
*********************************
Bug Fix Control Environment
***************************
fix 4611850 = enabled
fix 4663804 = enabled
fix 4663698 = enabled
fix 4545833 = enabled
fix 3499674 = disabled
fix 4584065 = enabled
fix 4602374 = enabled
fix 4569940 = enabled
fix 4631959 = enabled
fix 4519340 = enabled
fix 4550003 = enabled
fix 4488689 = enabled
fix 3118776 = enabled
fix 4519016 = enabled
fix 4487253 = enabled
fix 4556762 = 15
fix 4728348 = enabled
fix 4723244 = enabled
fix 4554846 = enabled
fix 4175830 = enabled
fix 4722900 = enabled
fix 5094217 = enabled
fix 4904890 = enabled
fix 4483286 = disabled
fix 4969880 = disabled
fix 4711525 = enabled
fix 4717546 = enabled
fix 4904838 = enabled
fix 5005866 = enabled
fix 4600710 = enabled
fix 5129233 = enabled
fix 5195882 = enabled
fix 5084239 = enabled
fix 4595987 = enabled
fix 4134994 = enabled
fix 5104624 = enabled
fix 4908162 = enabled
fix 5015557 = enabled
fix 5263572 = enabled
fix 4483240 = enabled
fix 5099909 = enabled
fix 5650477 = enabled
fix 4273361 = enabled
fix 5694984 = enabled
fix 5449488 = enabled
fix 5236908 = enabled
fix 5618040 = enabled
fix 5634346 = enabled
fix 5220356 = enabled
fix 5611962 = enabled
fix 5741121 = enabled
fix 5547058 = enabled
fix 5762598 = enabled
fix 5509293 = enabled
fix 5396162 = enabled
fix 5891471 = enabled
fix 4872602 = disabled
fix 5882954 = enabled
fix 5884780 = enabled
fix 5680702 = enabled
fix 5240607 = enabled
fix 4924149 = enabled
fix 4752814 = enabled
fix 4583239 = enabled
fix 5949981 = enabled
fix 5096560 = enabled
fix 5838613 = enabled
fix 5482831 = enabled
fix 5624216 = enabled
fix 5976822 = enabled
fix 5741044 = enabled
fix 5385629 = enabled
fix 5705630 = disabled
fix 5483301 = enabled
fix 6122894 = enabled
fix 5842686 = disabled
fix 6006300 = disabled
fix 6070954 = enabled
fix 2492766 = enabled
fix 6042205 = enabled
fix 5302124 = enabled
fix 6051211 = enabled
fix 5620485 = enabled
fix 4545802 = enabled
fix 4716096 = enabled
fix 5259048 = enabled
fix 6163564 = enabled
fix 6082745 = enabled
fix 5944076 = enabled
fix 4878299 = enabled
fix 5288623 = enabled
fix 5570494 = enabled
fix 5387148 = enabled
fix 4605810 = enabled
fix 4704779 = enabled
fix 5547895 = enabled
fix 6188881 = enabled
fix 5872956 = enabled
fix 4708389 = enabled
fix 3151991 = enabled
fix 3426050 = enabled
fix 599680 = enabled
fix 5505157 = enabled
fix 5996801 = enabled
fix 5765456 = 0
fix 6494943 = enabled
fix 6251917 = enabled
fix 6087237 = enabled
fix 6239971 = enabled
fix 6062266 = enabled
fix 5520732 = 0
fix 6151963 = enabled
fix 4567767 = enabled
fix 6007259 = enabled
fix 6694548 = enabled
*************************************
PARAMETERS WITH DEFAULT VALUES
******************************
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 = 10.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 = 16
_optimizer_max_permutations = 2000
pga_aggregate_target = 1024000 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 = 1024 KB
_smm_max_size = 102400 KB
_smm_px_max_size = 512000 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 10.2.0.4
parallel_query_mode = enabled
parallel_dml_mode = disabled
parallel_ddl_mode = enabled
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
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
_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
_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
_fix_control_key = 0
_optimizer_skip_scan_guess = false
_enable_row_shipping = false
_row_shipping_threshold = 80
_row_shipping_explain = false
_optimizer_rownum_bind_default = 10
_first_k_rows_dynamic_proration = true
_px_ual_serial_input = true
_optimizer_native_full_outer_join = off
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_optimizer_fkr_index_cost_bias = 10
_optimizer_connect_by_combine_sw = true
_optimizer_use_subheap = true
_optimizer_or_expansion_subheap = true
_optimizer_sortmerge_join_inequality = true
_optimizer_use_histograms = true
_optimizer_enable_density_improvements = false
*********************************
Bug Fix Control Environment
***************************
fix 4611850 = enabled
fix 4663804 = enabled
fix 4663698 = enabled
fix 4545833 = enabled
fix 3499674 = disabled
fix 4584065 = enabled
fix 4602374 = enabled
fix 4569940 = enabled
fix 4631959 = enabled
fix 4519340 = enabled
fix 4550003 = enabled
fix 4488689 = enabled
fix 3118776 = enabled
fix 4519016 = enabled
fix 4487253 = enabled
fix 4556762 = 15
fix 4728348 = enabled
fix 4723244 = enabled
fix 4554846 = enabled
fix 4175830 = enabled
fix 4722900 = enabled
fix 5094217 = enabled
fix 4904890 = enabled
fix 4483286 = disabled
fix 4969880 = disabled
fix 4711525 = enabled
fix 4717546 = enabled
fix 4904838 = enabled
fix 5005866 = enabled
fix 4600710 = enabled
fix 5129233 = enabled
fix 5195882 = enabled
fix 5084239 = enabled
fix 4595987 = enabled
fix 4134994 = enabled
fix 5104624 = enabled
fix 4908162 = enabled
fix 5015557 = enabled
fix 5263572 = enabled
fix 4483240 = enabled
fix 5099909 = enabled
fix 5650477 = enabled
fix 4273361 = enabled
fix 5694984 = enabled
fix 5449488 = enabled
fix 5236908 = enabled
fix 5618040 = enabled
fix 5634346 = enabled
fix 5220356 = enabled
fix 5611962 = enabled
fix 5741121 = enabled
fix 5547058 = enabled
fix 5762598 = enabled
fix 5509293 = enabled
fix 5396162 = enabled
fix 5891471 = enabled
fix 4872602 = disabled
fix 5882954 = enabled
fix 5884780 = enabled
fix 5680702 = enabled
fix 5240607 = enabled
fix 4924149 = enabled
fix 4752814 = enabled
fix 4583239 = enabled
fix 5949981 = enabled
fix 5096560 = enabled
fix 5838613 = enabled
fix 5482831 = enabled
fix 5624216 = enabled
fix 5976822 = enabled
fix 5741044 = enabled
fix 5385629 = enabled
fix 5705630 = disabled
fix 5483301 = enabled
fix 6122894 = enabled
fix 5842686 = disabled
fix 6006300 = disabled
fix 6070954 = enabled
fix 2492766 = enabled
fix 6042205 = enabled
fix 5302124 = enabled
fix 6051211 = enabled
fix 5620485 = enabled
fix 4545802 = enabled
fix 4716096 = enabled
fix 5259048 = enabled
fix 6163564 = enabled
fix 6082745 = enabled
fix 5944076 = enabled
fix 4878299 = enabled
fix 5288623 = enabled
fix 5570494 = enabled
fix 5387148 = enabled
fix 4605810 = enabled
fix 4704779 = enabled
fix 5547895 = enabled
fix 6188881 = enabled
fix 5872956 = enabled
fix 4708389 = enabled
fix 3151991 = enabled
fix 3426050 = enabled
fix 599680 = enabled
fix 5505157 = enabled
fix 5996801 = enabled
fix 5765456 = 0
fix 6494943 = enabled
fix 6251917 = enabled
fix 6087237 = enabled
fix 6239971 = enabled
fix 6062266 = enabled
fix 5520732 = 0
fix 6151963 = enabled
fix 4567767 = enabled
fix 6007259 = enabled
fix 6694548 = enabled
***************************************
PARAMETERS IN OPT_PARAM HINT
****************************
***************************************
Column Usage Monitoring is ON: tracking level = 1
***************************************
****************
QUERY BLOCK TEXT
****************
select /*+ 10053 */ b.recordlocator, bp.fullname,
pjs.segmentid, pjs.departuredate, pjs.flightnumber, pjs.departurestation, pjs.arrivalstation
from ejmis.booking b, ejmis.bookingpassenger bp, ejmis.passengerjourneysegment pjs
where b.bookingid = bp.bookingid
and bp.passengerid = pjs.passengerid
and pjs.departuredate = :v1 and pjs.departurestation = :v2
*********************
QUERY BLOCK SIGNATURE
*********************
qb name was generated
signature (optimizer): qb_name=SEL$1 nbfros=3 flg=0
fro(0): flg=0 objn=178683 hint_alias="B"@"SEL$1"
fro(1): flg=0 objn=178692 hint_alias="BP"@"SEL$1"
fro(2): flg=0 objn=182667 hint_alias="PJS"@"SEL$1"
*****************************
SYSTEM STATISTICS INFORMATION
*****************************
Using NOWORKLOAD Stats
CPUSPEED: 865 millions instruction/sec
IOTFRSPEED: 4096 bytes per millisecond (default is 4096)
IOSEEKTIM: 10 milliseconds (default is 10)
***************************************
BASE STATISTICAL INFORMATION
***********************
Table Stats::
Table: PASSENGERJOURNEYSEGMENT Alias: PJS Partition [9]
#Rows: 1024371 #Blks: 20297 AvgRowLen: 145.00
#Rows: 1024371 #Blks: 20297 AvgRowLen: 145.00
Index Stats::
Index: PASSENGERJOURNEYSEGMENT_IDX_0 Col#: 3 5 6
LVLS: 2 #LB: 26447 #DK: 7247 LB/K: 3.00 DB/K: 446.00 CLUF: 3232568.00
Index: PJS_IDX_PAXID Col#: 1 2
LVLS: 2 #LB: 18655 #DK: 4620011 LB/K: 1.00 DB/K: 1.00 CLUF: 4337664.00
Index: XPKSEGMENT Col#: 2
LVLS: 2 #LB: 16093 #DK: 5151417 LB/K: 1.00 DB/K: 1.00 CLUF: 4658972.00
***********************
Table Stats::
Table: BOOKINGPASSENGER Alias: BP (Using composite stats)
#Rows: 5503682 #Blks: 24648 AvgRowLen: 26.00
Index Stats::
Index: BOOKINGPASSENGER_UIDX_0 Col#: 3 1 6
LVLS: 2 #LB: 26108 #DK: 5657099 LB/K: 1.00 DB/K: 1.00 CLUF: 4482518.00
Index: XPKPASSENGER Col#: 1
LVLS: 2 #LB: 19466 #DK: 5599585 LB/K: 1.00 DB/K: 1.00 CLUF: 4406701.00
***********************
Table Stats::
Table: BOOKING Alias: B (Using composite stats)
#Rows: 2029841 #Blks: 10686 AvgRowLen: 32.00
Index Stats::
Index: BOOKING_UIDX_0 Col#: 1 2
LVLS: 2 #LB: 6981 #DK: 2155621 LB/K: 1.00 DB/K: 1.00 CLUF: 2076396.00
Index: BOOKING_UIDX_1 Col#: 1 3
LVLS: 2 #LB: 7928 #DK: 1987803 LB/K: 1.00 DB/K: 1.00 CLUF: 1901192.00
Index: XPKBOOKING Col#: 1
LVLS: 2 #LB: 6952 #DK: 1918170 LB/K: 1.00 DB/K: 1.00 CLUF: 1835215.00
***************************************
SINGLE TABLE ACCESS PATH
-----------------------------------------
BEGIN Single Table Cardinality Estimation
-----------------------------------------
Table: BOOKING Alias: B
Card: Original: 2029841 Rounded: 2029841 Computed: 2029841.00 Non Adjusted: 2029841.00
-----------------------------------------
END Single Table Cardinality Estimation
-----------------------------------------
Access Path: TableScan
Cost: 2383.47 Resp: 2383.47 Degree: 0
Cost_io: 2339.00 Cost_cpu: 461769498
Resp_io: 2339.00 Resp_cpu: 461769498
Access Path: index (index (FFS))
Index: BOOKING_UIDX_1
resc_io: 1736.00 resc_cpu: 294995136
ix_sel: 0.0000e+00 ix_sel_with_filters: 1
Access Path: index (FFS)
Cost: 1764.41 Resp: 1764.41 Degree: 1
Cost_io: 1736.00 Cost_cpu: 294995136
Resp_io: 1736.00 Resp_cpu: 294995136
Access Path: index (FullScan)
Index: BOOKING_UIDX_1
resc_io: 7930.00 resc_cpu: 454033619
ix_sel: 1 ix_sel_with_filters: 1
Cost: 3986.86 Resp: 3986.86 Degree: 1
Best:: AccessPath: IndexRange Index: BOOKING_UIDX_1
Cost: 3986.86 Degree: 1 Resp: 3986.86 Card: 2029841.00 Bytes: 0
***************************************
SINGLE TABLE ACCESS PATH
-----------------------------------------
BEGIN Single Table Cardinality Estimation
-----------------------------------------
Table: BOOKINGPASSENGER Alias: BP
Card: Original: 5503682 Rounded: 5503682 Computed: 5503682.00 Non Adjusted: 5503682.00
-----------------------------------------
END Single Table Cardinality Estimation
-----------------------------------------
Access Path: TableScan
Cost: 5521.21 Resp: 5521.21 Degree: 0
Cost_io: 5393.00 Cost_cpu: 1331302473
Resp_io: 5393.00 Resp_cpu: 1331302473
Best:: AccessPath: TableScan
Cost: 5521.21 Degree: 1 Resp: 5521.21 Card: 5503682.00 Bytes: 0
***************************************
SINGLE TABLE ACCESS PATH
-----------------------------------------
BEGIN Single Table Cardinality Estimation
-----------------------------------------
Column (#3): DEPARTUREDATE(VARCHAR2) Part#: 9
AvgLen: 9.00 NDV: 92 Nulls: 0 Density: 0.0032632
Histogram: Freq #Bkts: 91 UncompBkts: 5516 EndPtVals: 91
Column (#3): DEPARTUREDATE(VARCHAR2)
AvgLen: 9.00 NDV: 92 Nulls: 0 Density: 0.0032632
Histogram: Freq #Bkts: 91 UncompBkts: 5516 EndPtVals: 91
Column (#5): DEPARTURESTATION(VARCHAR2) Part#: 9
AvgLen: 4.00 NDV: 10 Nulls: 0 Density: 9.0645e-05
Histogram: Freq #Bkts: 10 UncompBkts: 5516 EndPtVals: 10
Column (#5): DEPARTURESTATION(VARCHAR2)
AvgLen: 4.00 NDV: 10 Nulls: 0 Density: 9.0645e-05
Histogram: Freq #Bkts: 10 UncompBkts: 5516 EndPtVals: 10
Table: PASSENGERJOURNEYSEGMENT Alias: PJS
Card: Original: 1024371 Rounded: 798 Computed: 797.92 Non Adjusted: 797.92
-----------------------------------------
END Single Table Cardinality Estimation
-----------------------------------------
Access Path: TableScan
Cost: 4483.61 Resp: 4483.61 Degree: 0
Cost_io: 4442.00 Cost_cpu: 432080117
Resp_io: 4442.00 Resp_cpu: 432080117
Access Path: index (RangeScan)
Index: PASSENGERJOURNEYSEGMENT_IDX_0
resc_io: 2541.00 resc_cpu: 13261043
ix_sel: 7.7893e-04 ix_sel_with_filters: 7.7893e-04
Cost: 1271.14 Resp: 1271.14 Degree: 1
Best:: AccessPath: IndexRange Index: PASSENGERJOURNEYSEGMENT_IDX_0
Cost: 1271.14 Degree: 1 Resp: 1271.14 Card: 797.92 Bytes: 0
***************************************
OPTIMIZER STATISTICS AND COMPUTATIONS
***************************************
GENERAL PLANS
***************************************
Considering cardinality-based initial join order.
Permutations for Starting Table :0
***********************
Join order[1]: PASSENGERJOURNEYSEGMENT[PJS]#0 BOOKING[B]#1 BOOKINGPASSENGER[BP]#2
***************
Now joining: BOOKING[B]#1
***************
NL Join
Outer table: Card: 797.92 Cost: 1271.14 Resp: 1271.14 Degree: 1 Bytes: 34
Inner table: BOOKING Alias: B
Access Path: TableScan
NL Join: Cost: 1902134.61 Resp: 1902134.61 Degree: 1
Cost_io: 1866647.50 Cost_cpu: 368498689798
Resp_io: 1866647.50 Resp_cpu: 368498689798
Access Path: index (index (FFS))
Index: BOOKING_UIDX_1
resc_io: 1734.25 resc_cpu: 294995136
ix_sel: 0.0000e+00 ix_sel_with_filters: 1
Inner table: BOOKING Alias: B
Access Path: index (FFS)
NL Join: Cost: 1407874.19 Resp: 1407874.19 Degree: 1
Cost_io: 1385203.50 Cost_cpu: 235412749305
Resp_io: 1385203.50 Resp_cpu: 235412749305
Access Path: index (FullScan)
Index: BOOKING_UIDX_1
resc_io: 7930.00 resc_cpu: 454033619
ix_sel: 1 ix_sel_with_filters: 1
NL Join: Cost: 3182787.13 Resp: 3182787.13 Degree: 1
Cost_io: 3165340.50 Cost_cpu: 181166044582
Resp_io: 3165340.50 Resp_cpu: 181166044582
Best NL cost: 3182787.13
resc: 3182787.13 resc_io: 3165340.50 resc_cpu: 181166044582
resp: 3182787.13 resp_io: 3165340.50 resp_cpu: 181166044582
Join Card: 1619642359.01 = outer (797.92) * inner (2029841.00) * sel (1)
Join Card - Rounded: 1619642359 Computed: 1619642359.01
Best:: JoinMethod: NestedLoop
Cost: 3182787.13 Degree: 1 Resp: 3182787.13 Card: 1619642359.01 Bytes: 47
***************
Now joining: BOOKINGPASSENGER[BP]#2
***************
NL Join
Outer table: Card: 1619642359.01 Cost: 3182787.13 Resp: 3182787.13 Degree: 1 Bytes: 47
Inner table: BOOKINGPASSENGER Alias: BP
Access Path: TableScan
NL Join: Cost: 1277196904606.57 Resp: 1277196904606.57 Degree: 1
Cost_io: 1247532692360.50 Cost_cpu: 308033592324131776
Resp_io: 1247532692360.50 Resp_cpu: 308033592324131776
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (UniqueScan)
Index: XPKPASSENGER
resc_io: 1.00 resc_cpu: 8381
ix_sel: 1.8170e-07 ix_sel_with_filters: 1.8170e-07
NL Join: Cost: 813657612.48 Resp: 813657612.48 Degree: 1
Cost_io: 812986520.00 Cost_cpu: 6968633671291
Resp_io: 812986520.00 Resp_cpu: 6968633671291
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (RangeScan)
Index: BOOKINGPASSENGER_UIDX_0
resc_io: 2.00 resc_cpu: 14653
ix_sel: 8.1058e-14 ix_sel_with_filters: 8.1058e-14
NL Join: Cost: 1623967884.64 Resp: 1623967884.64 Degree: 1
Cost_io: 1622807699.50 Cost_cpu: 12047378609254
Resp_io: 1622807699.50 Resp_cpu: 12047378609254
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (AllEqUnique)
Index: XPKPASSENGER
resc_io: 1.00 resc_cpu: 8381
ix_sel: 1.8170e-07 ix_sel_with_filters: 1.8170e-07
NL Join: Cost: 813657612.48 Resp: 813657612.48 Degree: 1
Cost_io: 812986520.00 Cost_cpu: 6968633671291
Resp_io: 812986520.00 Resp_cpu: 6968633671291
****** trying bitmap/domain indexes ******
****** finished trying bitmap/domain indexes ******
Best NL cost: 813657612.48
resc: 813657612.48 resc_io: 812986520.00 resc_cpu: 6968633671291
resp: 813657612.48 resp_io: 812986520.00 resp_cpu: 6968633671291
Join Card: 723.10 = outer (1619642359.01) * inner (5503682.00) * sel (8.1120e-14)
Join Card - Rounded: 723 Computed: 723.10
Best:: JoinMethod: NestedLoop
Cost: 813657612.48 Degree: 1 Resp: 813657612.48 Card: 723.10 Bytes: 66
***********************
Best so far: Table#: 0 cost: 1271.1385 card: 797.9159 bytes: 27132
Table#: 1 cost: 3182787.1296 card: 1619642359.0126 bytes: 76123190873
Table#: 2 cost: 813657612.4829 card: 723.1022 bytes: 47718
***********************
Join order[2]: PASSENGERJOURNEYSEGMENT[PJS]#0 BOOKINGPASSENGER[BP]#2 BOOKING[B]#1
***************
Now joining: BOOKINGPASSENGER[BP]#2
***************
NL Join
Outer table: Card: 797.92 Cost: 1271.14 Resp: 1271.14 Degree: 1 Bytes: 34
Inner table: BOOKINGPASSENGER Alias: BP
Access Path: TableScan
NL Join: Cost: 630546.44 Resp: 630546.44 Degree: 1
Cost_io: 615930.21 Cost_cpu: 151775112457
Resp_io: 615930.21 Resp_cpu: 151775112457
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (UniqueScan)
Index: XPKPASSENGER
resc_io: 1.00 resc_cpu: 8381
ix_sel: 1.8170e-07 ix_sel_with_filters: 1.8170e-07
NL Join: Cost: 1670.46 Resp: 1670.46 Degree: 1
Cost_io: 1669.50 Cost_cpu: 9974716
Resp_io: 1669.50 Resp_cpu: 9974716
kkofmx: index filter:"BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTUREDATE"=:B1 AND "PJS"."DEPARTURESTATION"=:B2
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (FullScan)
Index: BOOKINGPASSENGER_UIDX_0
resc_io: 21018.00 resc_cpu: 1281098646
ix_sel: 1 ix_sel_with_filters: 1.8170e-07
NL Join: Cost: 8436678.65 Resp: 8436678.65 Degree: 1
Cost_io: 8387452.50 Cost_cpu: 511164990244
Resp_io: 8387452.50 Resp_cpu: 511164990244
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (AllEqUnique)
Index: XPKPASSENGER
resc_io: 1.00 resc_cpu: 8381
ix_sel: 1.8170e-07 ix_sel_with_filters: 1.8170e-07
NL Join: Cost: 1670.46 Resp: 1670.46 Degree: 1
Cost_io: 1669.50 Cost_cpu: 9974716
Resp_io: 1669.50 Resp_cpu: 9974716
****** trying bitmap/domain indexes ******
****** finished trying bitmap/domain indexes ******
Best NL cost: 1670.46
resc: 1670.46 resc_io: 1669.50 resc_cpu: 9974716
resp: 1670.46 resp_io: 1669.50 resp_cpu: 9974716
Join Card: 797.92 = outer (797.92) * inner (5503682.00) * sel (1.8170e-07)
Join Card - Rounded: 798 Computed: 797.92
Best:: JoinMethod: NestedLoop
Cost: 1670.46 Degree: 1 Resp: 1670.46 Card: 797.92 Bytes: 53
***************
Now joining: BOOKING[B]#1
***************
NL Join
Outer table: Card: 797.92 Cost: 1670.46 Resp: 1670.46 Degree: 1 Bytes: 53
Inner table: BOOKING Alias: B
Access Path: TableScan
NL Join: Cost: 381843.16 Resp: 381843.16 Degree: 1
Cost_io: 374744.90 Cost_cpu: 73708386571
Resp_io: 374744.90 Resp_cpu: 73708386571
Access Path: index (index (FFS))
Index: BOOKING_UIDX_1
resc_io: 1734.25 resc_cpu: 294995136
ix_sel: 0.0000e+00 ix_sel_with_filters: 1
Inner table: BOOKING Alias: B
Access Path: index (FFS)
NL Join: Cost: 282991.07 Resp: 282991.07 Degree: 1
Cost_io: 278456.10 Cost_cpu: 47091198473
Resp_io: 278456.10 Resp_cpu: 47091198473
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (UniqueScan)
Index: XPKBOOKING
resc_io: 1.00 resc_cpu: 8361
ix_sel: 4.9265e-07 ix_sel_with_filters: 4.9265e-07
NL Join: Cost: 2069.78 Resp: 2069.78 Degree: 1
Cost_io: 2068.50 Cost_cpu: 13310931
Resp_io: 2068.50 Resp_cpu: 13310931
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (RangeScan)
Index: BOOKING_UIDX_0
resc_io: 3.00 resc_cpu: 22144
ix_sel: 5.0145e-07 ix_sel_with_filters: 5.0145e-07
NL Join: Cost: 2868.31 Resp: 2868.31 Degree: 1
Cost_io: 2866.50 Cost_cpu: 18810300
Resp_io: 2866.50 Resp_cpu: 18810300
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (IndexOnly)
Index: BOOKING_UIDX_1
resc_io: 1.00 resc_cpu: 7321
ix_sel: 5.0145e-07 ix_sel_with_filters: 5.0145e-07
NL Join: Cost: 2069.74 Resp: 2069.74 Degree: 1
Cost_io: 2068.50 Cost_cpu: 12895971
Resp_io: 2068.50 Resp_cpu: 12895971
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (AllEqUnique)
Index: XPKBOOKING
resc_io: 1.00 resc_cpu: 8361
ix_sel: 5.0145e-07 ix_sel_with_filters: 5.0145e-07
NL Join: Cost: 2069.78 Resp: 2069.78 Degree: 1
Cost_io: 2068.50 Cost_cpu: 13310931
Resp_io: 2068.50 Resp_cpu: 13310931
****** trying bitmap/domain indexes ******
****** finished trying bitmap/domain indexes ******
Best NL cost: 2069.74
resc: 2069.74 resc_io: 2068.50 resc_cpu: 12895971
resp: 2069.74 resp_io: 2068.50 resp_cpu: 12895971
Join Card: 730.99 = outer (797.92) * inner (2029841.00) * sel (4.5133e-07)
Join Card - Rounded: 731 Computed: 730.99
Plan cardinality mismatch: best card= 723.10223310249 curr card= 730.99373869985
Best:: JoinMethod: NestedLoop
Cost: 2069.74 Degree: 1 Resp: 2069.74 Card: 730.99 Bytes: 66
***********************
Best so far: Table#: 0 cost: 1271.1385 card: 797.9159 bytes: 27132
Table#: 2 cost: 1670.4606 card: 797.9159 bytes: 42294
Table#: 1 cost: 2069.7419 card: 730.9937 bytes: 48246
***********************
Join order[3]: BOOKING[B]#1 PASSENGERJOURNEYSEGMENT[PJS]#0 BOOKINGPASSENGER[BP]#2
***************
Now joining: PASSENGERJOURNEYSEGMENT[PJS]#0
***************
NL Join
Outer table: Card: 2029841.00 Cost: 3986.86 Resp: 3986.86 Degree: 1 Bytes: 13
Inner table: PASSENGERJOURNEYSEGMENT Alias: PJS
Access Path: TableScan
NL Join: Cost: 9096896533.62 Resp: 9096896533.62 Degree: 1
Cost_io: 9012434574.00 Cost_cpu: 877054162846472
Resp_io: 9012434574.00 Resp_cpu: 877054162846472
Access Path: index (RangeScan)
Index: PASSENGERJOURNEYSEGMENT_IDX_0
resc_io: 2541.00 resc_cpu: 13261043
ix_sel: 7.7893e-04 ix_sel_with_filters: 7.7893e-04
NL Join: Cost: 2580213095.09 Resp: 2580213095.09 Degree: 1
Cost_io: 2578916955.50 Cost_cpu: 13459131530682
Resp_io: 2578916955.50 Resp_cpu: 13459131530682
Best NL cost: 2580213095.09
resc: 2580213095.09 resc_io: 2578916955.50 resc_cpu: 13459131530682
resp: 2580213095.09 resp_io: 2578916955.50 resp_cpu: 13459131530682
Join Card: 1619642359.01 = outer (2029841.00) * inner (797.92) * sel (1)
Join Card - Rounded: 1619642359 Computed: 1619642359.01
Join order aborted: cost > best plan cost
***********************
***********************
Join order[4]: BOOKING[B]#1 BOOKINGPASSENGER[BP]#2 PASSENGERJOURNEYSEGMENT[PJS]#0
***************
Now joining: BOOKINGPASSENGER[BP]#2
***************
NL Join
Outer table: Card: 2029841.00 Cost: 3986.86 Resp: 3986.86 Degree: 1 Bytes: 13
Inner table: BOOKINGPASSENGER Alias: BP
Access Path: TableScan
NL Join: Cost: 11204638869.14 Resp: 11204638869.14 Degree: 1
Cost_io: 10944399178.00 Cost_cpu: 2702332570357184
Resp_io: 10944399178.00 Resp_cpu: 2702332570357184
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (RangeScan)
Index: BOOKINGPASSENGER_UIDX_0
resc_io: 3.00 resc_cpu: 22594
ix_sel: 4.4612e-07 ix_sel_with_filters: 4.4612e-07
NL Join (ordered): Cost: 3050956.70 Resp: 3050956.70 Degree: 1
Cost_io: 3048726.50 Cost_cpu: 23158455361
Resp_io: 3048726.50 Resp_cpu: 23158455361
Best NL cost: 3050956.70
resc: 3050956.70 resc_io: 3048726.50 resc_cpu: 23158455361
resp: 3050956.70 resp_io: 3048726.50 resp_cpu: 23158455361
Join Card: 4983856.92 = outer (2029841.00) * inner (5503682.00) * sel (4.4612e-07)
Join Card - Rounded: 4983857 Computed: 4983856.92
Join order aborted: cost > best plan cost
***********************
***********************
Join order[5]: BOOKINGPASSENGER[BP]#2 PASSENGERJOURNEYSEGMENT[PJS]#0 BOOKING[B]#1
***************
Now joining: PASSENGERJOURNEYSEGMENT[PJS]#0
***************
NL Join
Outer table: Card: 5503682.00 Cost: 5521.21 Resp: 5521.21 Degree: 1 Bytes: 19
Inner table: PASSENGERJOURNEYSEGMENT Alias: PJS
Access Path: TableScan
NL Join: Cost: 24665190509.25 Resp: 24665190509.25 Degree: 1
Cost_io: 24436181485.00 Cost_cpu: 2378032891239862
Resp_io: 24436181485.00 Resp_cpu: 2378032891239862
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (RangeScan)
Index: PASSENGERJOURNEYSEGMENT_IDX_0
resc_io: 2535.00 resc_cpu: 13218314
ix_sel: 7.7893e-04 ix_sel_with_filters: 7.7893e-04
NL Join: Cost: 6979425407.96 Resp: 6979425407.96 Degree: 1
Cost_io: 6975922328.00 Cost_cpu: 36376031039431
Resp_io: 6975922328.00 Resp_cpu: 36376031039431
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (RangeScan)
Index: PJS_IDX_PAXID
resc_io: 9.00 resc_cpu: 47122
ix_sel: 1.7095e-06 ix_sel_with_filters: 1.7095e-06
NL Join: Cost: 24784577.81 Resp: 24784577.81 Degree: 1
Cost_io: 24771962.00 Cost_cpu: 131002710294
Resp_io: 24771962.00 Resp_cpu: 131002710294
****** trying bitmap/domain indexes ******
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (IndexOnly)
Index: PASSENGERJOURNEYSEGMENT_IDX_0
resc_io: 17.00 resc_cpu: 906064
ix_sel: 7.7893e-04 ix_sel_with_filters: 7.7893e-04
NL Join: Cost: 47026932.04 Resp: 47026932.04 Degree: 1
Cost_io: 46786690.00 Cost_cpu: 2494676687181
Resp_io: 46786690.00 Resp_cpu: 2494676687181
SORT resource Sort statistics
Sort width: 598 Area size: 1048576 Max Area size: 104857600
Degree: 1
Blocks to Sort: 10 Row size: 21 Total Rows: 3839
Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
Total IO sort cost: 0 Total CPU sort cost: 12443418
Total Temp space used: 0
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (IndexOnly)
Index: PJS_IDX_PAXID
resc_io: 1.00 resc_cpu: 8721
ix_sel: 1.7095e-06 ix_sel_with_filters: 1.7095e-06
NL Join: Cost: 2759673.45 Resp: 2759673.45 Degree: 1
Cost_io: 2757234.00 Cost_cpu: 25331318644
Resp_io: 2757234.00 Resp_cpu: 25331318644
SORT resource Sort statistics
Sort width: 598 Area size: 1048576 Max Area size: 104857600
Degree: 1
Blocks to Sort: 1 Row size: 21 Total Rows: 1
Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
Total IO sort cost: 0 Total CPU sort cost: 10384014
Total Temp space used: 0
****** finished trying bitmap/domain indexes ******
Best NL cost: 24784577.81
resc: 24784577.81 resc_io: 24771962.00 resc_cpu: 131002710294
resp: 24784577.81 resp_io: 24771962.00 resp_cpu: 131002710294
Join Card: 797.92 = outer (5503682.00) * inner (797.92) * sel (1.8170e-07)
Join Card - Rounded: 798 Computed: 797.92
Join order aborted: cost > best plan cost
***********************
***********************
Join order[6]: BOOKINGPASSENGER[BP]#2 BOOKING[B]#1 PASSENGERJOURNEYSEGMENT[PJS]#0
***************
Now joining: BOOKING[B]#1
***************
NL Join
Outer table: Card: 5503682.00 Cost: 5521.21 Resp: 5521.21 Degree: 1 Bytes: 19
Inner table: BOOKING Alias: B
Access Path: TableScan
NL Join: Cost: 2621994594.66 Resp: 2621994594.66 Degree: 1
Cost_io: 2573045524.40 Cost_cpu: 508287825984682
Resp_io: 2573045524.40 Resp_cpu: 508287825984682
Access Path: index (index (FFS))
Index: BOOKING_UIDX_1
resc_io: 1734.25 resc_cpu: 294995136
ix_sel: 0.0000e+00 ix_sel_with_filters: 1
Inner table: BOOKING Alias: B
Access Path: index (FFS)
NL Join: Cost: 1940227986.23 Resp: 1940227986.23 Degree: 1
Cost_io: 1908957495.00 Cost_cpu: 324713215672859
Resp_io: 1908957495.00 Resp_cpu: 324713215672859
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (UniqueScan)
Index: XPKBOOKING
resc_io: 1.00 resc_cpu: 8361
ix_sel: 4.9265e-07 ix_sel_with_filters: 4.9265e-07
NL Join: Cost: 2759578.05 Resp: 2759578.05 Degree: 1
Cost_io: 2757234.00 Cost_cpu: 24340655884
Resp_io: 2757234.00 Resp_cpu: 24340655884
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (RangeScan)
Index: BOOKING_UIDX_0
resc_io: 3.00 resc_cpu: 22144
ix_sel: 5.0145e-07 ix_sel_with_filters: 5.0145e-07
NL Join: Cost: 8266912.62 Resp: 8266912.62 Degree: 1
Cost_io: 8260916.00 Cost_cpu: 62268950166
Resp_io: 8260916.00 Resp_cpu: 62268950166
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (IndexOnly)
Index: BOOKING_UIDX_1
resc_io: 1.00 resc_cpu: 7321
ix_sel: 5.0145e-07 ix_sel_with_filters: 5.0145e-07
NL Join: Cost: 2759302.44 Resp: 2759302.44 Degree: 1
Cost_io: 2757234.00 Cost_cpu: 21478741244
Resp_io: 2757234.00 Resp_cpu: 21478741244
OPTIMIZER PERCENT INDEX CACHING = 20
Access Path: index (AllEqUnique)
Index: XPKBOOKING
resc_io: 1.00 resc_cpu: 8361
ix_sel: 5.0145e-07 ix_sel_with_filters: 5.0145e-07
NL Join: Cost: 2759578.05 Resp: 2759578.05 Degree: 1
Cost_io: 2757234.00 Cost_cpu: 24340655884
Resp_io: 2757234.00 Resp_cpu: 24340655884
****** trying bitmap/domain indexes ******
****** finished trying bitmap/domain indexes ******
Best NL cost: 2759302.44
resc: 2759302.44 resc_io: 2757234.00 resc_cpu: 21478741244
resp: 2759302.44 resp_io: 2757234.00 resp_cpu: 21478741244
Join Card: 4983856.92 = outer (5503682.00) * inner (2029841.00) * sel (4.4612e-07)
Join Card - Rounded: 4983857 Computed: 4983856.92
Join order aborted: cost > best plan cost
***********************
(newjo-stop-1) k:0, spcnt:0, perm:6, maxperm:2000
*********************************
Number of join permutations tried: 6
*********************************
(newjo-save) [0 1 2 ]
Final - First Rows Plan: Best join order: 2
Cost: 2069.7419 Degree: 1 Card: 731.0000 Bytes: 48246
Resc: 2069.7419 Resc_io: 2068.5000 Resc_cpu: 12895971
Resp: 2069.7419 Resp_io: 2068.5000 Resc_cpu: 12895971
kkoipt: Query block SEL$1 (#0)
******* UNPARSED QUERY IS *******
SELECT "B"."RECORDLOCATOR" "RECORDLOCATOR","BP"."FULLNAME" "FULLNAME","PJS"."SEGMENTID" "SEGMENTID","PJS"."DEPARTUREDATE" "DEPARTUREDATE","PJS"."FLIGHTNUMBER" "FLIGHTNUMBER","PJS"."DEPARTURESTATION" "DEPARTURESTATION","PJS"."ARRIVALSTATION" "ARRIVALSTATION" FROM "EJMIS"."BOOKING" "B","EJMIS"."BOOKINGPASSENGER" "BP","EJMIS"."PASSENGERJOURNEYSEGMENT" "PJS" WHERE "B"."BOOKINGID"="BP"."BOOKINGID" AND "BP"."PASSENGERID"="PJS"."PASSENGERID" AND "PJS"."DEPARTURESTATION"=:B1 AND "PJS"."DEPARTUREDATE"=:B2
kkoqbc-subheap (delete addr=11044c690, in-use=90456, alloc=91728)
kkoqbc-end
: call(in-use=123352, alloc=234248), compile(in-use=60208, alloc=63456)
apadrv-end: call(in-use=123352, alloc=234248), compile(in-use=61136, alloc=63456)
sql_id=1bnm0qmwr9325.
Current SQL statement for this session:
select /*+ 10053 */ b.recordlocator, bp.fullname,
pjs.segmentid, pjs.departuredate, pjs.flightnumber, pjs.departurestation, pjs.arrivalstation
from ejmis.booking b, ejmis.bookingpassenger bp, ejmis.passengerjourneysegment pjs
where b.bookingid = bp.bookingid
and bp.passengerid = pjs.passengerid
and pjs.departuredate = :v1 and pjs.departurestation = :v2
============
Plan Table
============
-----------------------------------------------------------------------------+-----------------------------------+---------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | Pstart| Pstop |
-----------------------------------------------------------------------------+-----------------------------------+---------------+
| 0 | SELECT STATEMENT | | | | 2070 | | | |
| 1 | NESTED LOOPS | | 731 | 47K | 2070 | 00:00:25 | | |
| 2 | NESTED LOOPS | | 798 | 41K | 1670 | 00:00:21 | | |
| 3 | TABLE ACCESS BY GLOBAL INDEX ROWID | PASSENGERJOURNEYSEGMENT | 798 | 26K | 1271 | 00:00:16 | ROW LOCATION| ROW LOCATION|
| 4 | INDEX RANGE SCAN | PASSENGERJOURNEYSEGMENT_IDX_0| 3924 | | 12 | 00:00:01 | | |
| 5 | TABLE ACCESS BY GLOBAL INDEX ROWID | BOOKINGPASSENGER | 1 | 19 | 1 | 00:00:01 | ROW LOCATION| ROW LOCATION|
| 6 | INDEX UNIQUE SCAN | XPKPASSENGER | 1 | | 1 | 00:00:01 | | |
| 7 | INDEX RANGE SCAN | BOOKING_UIDX_1 | 1 | 13 | 1 | 00:00:01 | | |
-----------------------------------------------------------------------------+-----------------------------------+---------------+
Predicate Information:
----------------------
4 - access("PJS"."DEPARTUREDATE"=:V1 AND "PJS"."DEPARTURESTATION"=:V2)
6 - access("BP"."PASSENGERID"="PJS"."PASSENGERID")
7 - access("B"."BOOKINGID"="BP"."BOOKINGID")
Content of other_xml column
===========================
db_version : 10.2.0.4
parse_schema : SYS
plan_hash : 2455797174
Peeked Binds
============
Bind variable information
position=1
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=846
char format=1
max length=32
value=20110430
Bind variable information
position=2
datatype(code)=1
datatype(string)=VARCHAR2(32)
char set id=846
char format=1
max length=32
value=CJJ
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
OPT_PARAM('optimizer_index_cost_adj' 50)
OPT_PARAM('optimizer_index_caching' 20)
FIRST_ROWS
OUTLINE_LEAF(@"SEL$1")
INDEX_RS_ASC(@"SEL$1" "PJS"@"SEL$1" ("PASSENGERJOURNEYSEGMENT"."DEPARTUREDATE" "PASSENGERJOURNEYSEGMENT"."DEPARTURESTATION" "PASSENGERJOURNEYSEGMENT"."ARRIVALSTATION"))
INDEX_RS_ASC(@"SEL$1" "BP"@"SEL$1" ("BOOKINGPASSENGER"."PASSENGERID"))
INDEX(@"SEL$1" "B"@"SEL$1" ("BOOKING"."BOOKINGID" "BOOKING"."RECORDLOCATOR"))
LEADING(@"SEL$1" "PJS"@"SEL$1" "BP"@"SEL$1" "B"@"SEL$1")
USE_NL(@"SEL$1" "BP"@"SEL$1")
USE_NL(@"SEL$1" "B"@"SEL$1")
END_OUTLINE_DATA
*/
Optimizer environment:
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 = 10.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 = 16
_optimizer_max_permutations = 2000
pga_aggregate_target = 1024000 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 = 1024 KB
_smm_max_size = 102400 KB
_smm_px_max_size = 512000 KB
_cpu_to_io = 0
_optimizer_undo_cost_change = 10.2.0.4
parallel_query_mode = enabled
parallel_dml_mode = disabled
parallel_ddl_mode = enabled
optimizer_mode = first_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 = 50
optimizer_index_caching = 20
_system_index_caching = 0
_disable_datalayer_sampling = false
query_rewrite_enabled = true
query_rewrite_integrity = trusted
_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
_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
_fix_control_key = 0
_optimizer_skip_scan_guess = false
_enable_row_shipping = false
_row_shipping_threshold = 80
_row_shipping_explain = false
_optimizer_rownum_bind_default = 10
_first_k_rows_dynamic_proration = true
_px_ual_serial_input = true
_optimizer_native_full_outer_join = off
_optimizer_star_trans_min_cost = 0
_optimizer_star_trans_min_ratio = 0
_optimizer_fkr_index_cost_bias = 10
_optimizer_connect_by_combine_sw = true
_optimizer_use_subheap = true
_optimizer_or_expansion_subheap = true
_optimizer_sortmerge_join_inequality = true
_optimizer_use_histograms = true
_optimizer_enable_density_improvements = false
*********************************
Bug Fix Control Environment
***************************
fix 4611850 = enabled
fix 4663804 = enabled
fix 4663698 = enabled
fix 4545833 = enabled
fix 3499674 = disabled
fix 4584065 = enabled
fix 4602374 = enabled
fix 4569940 = enabled
fix 4631959 = enabled
fix 4519340 = enabled
fix 4550003 = enabled
fix 4488689 = enabled
fix 3118776 = enabled
fix 4519016 = enabled
fix 4487253 = enabled
fix 4556762 = 15
fix 4728348 = enabled
fix 4723244 = enabled
fix 4554846 = enabled
fix 4175830 = enabled
fix 4722900 = enabled
fix 5094217 = enabled
fix 4904890 = enabled
fix 4483286 = disabled
fix 4969880 = disabled
fix 4711525 = enabled
fix 4717546 = enabled
fix 4904838 = enabled
fix 5005866 = enabled
fix 4600710 = enabled
fix 5129233 = enabled
fix 5195882 = enabled
fix 5084239 = enabled
fix 4595987 = enabled
fix 4134994 = enabled
fix 5104624 = enabled
fix 4908162 = enabled
fix 5015557 = enabled
fix 5263572 = enabled
fix 4483240 = enabled
fix 5099909 = enabled
fix 5650477 = enabled
fix 4273361 = enabled
fix 5694984 = enabled
fix 5449488 = enabled
fix 5236908 = enabled
fix 5618040 = enabled
fix 5634346 = enabled
fix 5220356 = enabled
fix 5611962 = enabled
fix 5741121 = enabled
fix 5547058 = enabled
fix 5762598 = enabled
fix 5509293 = enabled
fix 5396162 = enabled
fix 5891471 = enabled
fix 4872602 = disabled
fix 5882954 = enabled
fix 5884780 = enabled
fix 5680702 = enabled
fix 5240607 = enabled
fix 4924149 = enabled
fix 4752814 = enabled
fix 4583239 = enabled
fix 5949981 = enabled
fix 5096560 = enabled
fix 5838613 = enabled
fix 5482831 = enabled
fix 5624216 = enabled
fix 5976822 = enabled
fix 5741044 = enabled
fix 5385629 = enabled
fix 5705630 = disabled
fix 5483301 = enabled
fix 6122894 = enabled
fix 5842686 = disabled
fix 6006300 = disabled
fix 6070954 = enabled
fix 2492766 = enabled
fix 6042205 = enabled
fix 5302124 = enabled
fix 6051211 = enabled
fix 5620485 = enabled
fix 4545802 = enabled
fix 4716096 = enabled
fix 5259048 = enabled
fix 6163564 = enabled
fix 6082745 = enabled
fix 5944076 = enabled
fix 4878299 = enabled
fix 5288623 = enabled
fix 5570494 = enabled
fix 5387148 = enabled
fix 4605810 = enabled
fix 4704779 = enabled
fix 5547895 = enabled
fix 6188881 = enabled
fix 5872956 = enabled
fix 4708389 = enabled
fix 3151991 = enabled
fix 3426050 = enabled
fix 599680 = enabled
fix 5505157 = enabled
fix 5996801 = enabled
fix 5765456 = 0
fix 6494943 = enabled
fix 6251917 = enabled
fix 6087237 = enabled
fix 6239971 = enabled
fix 6062266 = enabled
fix 5520732 = 0
fix 6151963 = enabled
fix 4567767 = enabled
fix 6007259 = enabled
fix 6694548 = enabled
Query Block Registry:
*********************
SEL$1 0x10447ae0 (PARSER) [FINAL]
Optimizer State Dump: call(in-use=136784, alloc=234248), compile(in-use=102600, alloc=152304)
'Oracle' 카테고리의 다른 글
| [1] Oracle 11g 설치하기 (0) | 2015.12.27 |
|---|---|
| OLTP, ODS, DSS .... [Terminology] (0) | 2011.09.13 |
| oradebug help (0) | 2011.07.31 |
| HangAnalyze 10 (0) | 2011.07.31 |
| Dump systemstate 2 (0) | 2011.07.31 |
