Tools and Utilities - Expert Oracle RAC Performance Diagnostics and Tuning - page 185

ix_sel: 0.000000 ix_sel_with_filters: 0.000000
NL Join (ordered): Cost: 43188842.83 Resp: 43188842.83 Degree: 1
Cost_io: 43176368.00 Cost_cpu: 397749433156
Resp_io: 43176368.00 Resp_cpu: 397749433156
kkofmx: index filter:"OL"."OL_O_ID"="ORD"."O_ID"
ColGroup Usage:: PredCnt: 3 Matches Full: Partial:
ColGroup Usage:: PredCnt: 3 Matches Full: Partial:
Access Path: index (AllEqUnique)
Index: ORDERS_I1
resc_io: 1.00 resc_cpu: 9021
ix_sel: 0.000000 ix_sel_with_filters: 0.000000
NL Join (ordered): Cost: 43188842.83 Resp: 43188842.83 Degree: 1
Cost_io: 43176368.00 Cost_cpu: 397749433156
Resp_io: 43176368.00 Resp_cpu: 397749433156
ColGroup Usage:: PredCnt: 2 Matches Full: Partial:
ColGroup Usage:: PredCnt: 3 Matches Full: Partial:
Access Path: index (IndexOnly)
Index: ORDERS_I2
resc_io: 1033.00 resc_cpu: 50357298
ix_sel: 0.051399 ix_sel_with_filters: 0.000000
***** Logdef predicate Adjustment ******
Final IO cst 0.00 , CPU cst 0.00
***** End Logdef Adjustment ******
NL Join (ordered): Cost: 44442301374.02 Resp: 44442301374.02 Degree: 1
Cost_io: 44374390338.00 Cost_cpu: 2165285410693464
Resp_io: 44374390338.00 Resp_cpu: 2165285410693464
****** trying bitmap/domain indexes ******
****** finished trying bitmap/domain indexes ******
Best NL cost: 43188842.83
resc: 43188842.83 resc_io: 43176368.00 resc_cpu: 397749433156
resp: 43188842.83 resp_io: 43176368.00 resc_cpu: 397749433156
Join selectivity using 1 ColGroups: 0.000000 (sel1 = 0.000000, sel2 = 0.000000)
Join Card: 42592862.717274 = = outer (42998248.000000) * inner (4299997.000000) * sel (0.000000)
Join Card - Rounded: 42592863 Computed: 42592862.72
Grouping column cardinality [ OL_NUMBER] 15
Grouping column cardinality [ OL_W_ID] 2
Grouping column cardinality [ OL_D_ID] 10
Outer table: ORDER_LINE Alias: OL
resc: 178428.72 card 42998248.00 bytes: 22 deg: 1 resp: 178428.72
Inner table: ORDERS Alias: ORD
resc: 5458.23 card: 4299997.00 bytes: 11 deg: 1 resp: 5458.23
using dmeth: 2 #groups: 1
SORT ressource Sort statistics
Sort width: 6142 Area size: 1048576 Max Area size: 1073741824
Degree: 1
Blocks to Sort: 184249 Row size: 35 Total Rows: 42998248
Initial runs: 2 Merge passes: 1 IO Cost / pass: 99804
Total IO sort cost: 284053 Total CPU sort cost: 53693990840
Total Temp space used: 3453363000