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

SORT ressource Sort statistics
Sort width: 6142 Area size: 1048576 Max Area size: 1073741824
Degree: 1
Blocks to Sort: 12109 Row size: 23 Total Rows: 4299997
Initial runs: 2 Merge passes: 1 IO Cost / pass: 6560
Total IO sort cost: 18669 Total CPU sort cost: 4599195307
Total Temp space used: 207234000
SM join: Resc: 488437.23 Resp: 488437.23 [multiMatchCost=0.00]
SM Join
SM cost: 488437.23
resc: 488437.23 resc_io: 486280.00 resc_cpu: 68781395928
resp: 488437.23 resp_io: 486280.00 resp_cpu: 68781395928
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
Cost per ptn: 74009.27 #ptns: 1
hash_area: 256 (max=262144) buildfrag: 178460 probefrag: 12073 ppasses: 1
Hash join: Resc: 258016.32 Resp: 258016.32 [multiMatchCost=120.10]
Outer table: ORDERS Alias: ORD
resc: 5458.23 card 4299997.00 bytes: 11 deg: 1 resp: 5458.23
Inner table: ORDER_LINE Alias: OL
resc: 178428.72 card: 42998248.00 bytes: 22 deg: 1 resp: 178428.72
using dmeth: 2 #groups: 1
Cost per ptn: 74069.96 #ptns: 1
hash_area: 256 (max=262144) buildfrag: 12073 probefrag: 178460 ppasses: 1
Hash join: Resc: 257956.91 Resp: 257956.91 [multiMatchCost=0.00]
HA Join
HA cost: 257956.91 swapped
resc: 257956.91 resc_io: 257313.00 resc_cpu: 20530453418
resp: 257956.91 resp_io: 257313.00 resp_cpu: 20530453418
GROUP BY sort
ColGroup Usage:: PredCnt: 3 Matches Full: Partial:
GROUP BY adjustment factor: 0.500000
GROUP BY cardinality: 150.000000, TABLE cardinality: 42592863.000000
SORT ressource Sort statistics
Sort width: 6142 Area size: 1048576 Max Area size: 1073741824
Degree: 1
Blocks to Sort: 245087 Row size: 47 Total Rows: 42592863
Initial runs: 1 Merge passes: 0 IO Cost / pass: 0
Total IO sort cost: 0 Total CPU sort cost: 48667303854
Total Temp space used: 0
Join order aborted: cost > best plan cost
***********************
(newjo-stop-1) k:0, spcnt:0, perm:2, maxperm:2000