1366133.1 SQLHC
11.4.5.2 Report: sqlhc_20121226_180358_f995z9antmhxn_3_execution_plans.html
License : T
Input : f995z9antmhxn
SIGNATURE : 1.1782E+18
SIGNATUREF: 1178211779310957485
RDBMS : 11.2.0.3.0
Platform : 64-BIT WINDOWS
Database : orcl
DBID : 1311055076
Host : csierraus
Instance : 1
CPU Count : 4
Block Size: 8192
OFE : 11.2.0.3
DYN_SAMP : 2
EBS : ""
SIEBEL : ""
PSFT : ""
Date : 2012-12-26/18:03:59
SQL Text
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name,
v.orders_total,
v.credit_limit,
(orders_total - credit_limit) over_limit
FROM customer_v v
WHERE orders_total > credit_limit
AND customer_type = :b1
ORDER BY
over_limit DESC
Current Execution Plans (last execution)
Captured while still in memory. Metrics below are for the last execution of each child cursor.
If STATISTICS_LEVEL was set to ALL at the time of the hard-parse then A-Rows column is populated.
Inst: 1 Child: 0 Plan hash value: 2816325939
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes|E-Temp | Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | | | 19614 (100)| | 922 |00:00:04.06 | 20642 | 13157 | | | |
| 1 | SORT ORDER BY | | 1 | 184 | 18216 | | 19614 (2)| 00:03:56 | 922 |00:00:04.06 | 20642 | 13157 | 124K| 124K| 110K (0)|
|* 2 | FILTER | | 1 | | | | | | 922 |00:00:04.06 | 20642 | 13157 | | | |
| 3 | HASH GROUP BY | | 1 | 184 | 18216 | | 19614 (2)| 00:03:56 | 1176 |00:00:04.06 | 20642 | 13157 | 776K| 776K| 1302K (0)|
|* 4 | HASH JOIN | | 1 | 4274 | 413K| | 19612 (2)| 00:03:56 | 3484 |00:00:04.04 | 20642 | 13157 | 936K| 936K| 1368K (0)|
| 5 | NESTED LOOPS | | 1 | 4274 | 338K| | 690 (2)| 00:00:09 | 3484 |00:00:00.04 | 5931 | 0 | | | |
|* 6 | HASH JOIN | | 1 | 4274 | 317K| | 690 (2)| 00:00:09 | 3484 |00:00:00.04 | 2445 | 0 | 813K| 813K| 1297K (0)|
|* 7 | TABLE ACCESS FULL | CUSTOMER | 1 | 1457 | 93248 | | 221 (1)| 00:00:03 | 1239 |00:00:00.01 | 784 | 0 | | | |
|* 8 | TABLE ACCESS FULL | SALES_ORDER | 1 | 281K| 3298K| | 467 (2)| 00:00:06 | 281K|00:00:00.04 | 1661 | 0 | | | |
|* 9 | INDEX UNIQUE SCAN | CUSTOMER_PK | 3484 | 1 | 5 | | 0 (0)| | 3484 |00:00:00.01 | 3486 | 0 | | | |
| 10 | VIEW | | 1 | 302K| 5325K| | 18919 (2)| 00:03:48 | 299K|00:00:04.03 | 14711 | 13157 | | | |
| 11 | HASH GROUP BY | | 1 | 302K| 7396K| 130M| 18919 (2)| 00:03:48 | 299K|00:00:03.98 | 14711 | 13157 | 26M| 4367K| 28M (0)|
|* 12 | HASH JOIN | | 1 | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 | 3450K|00:00:03.76 | 14711 | 13157 | 8136K| 3216K| 10M (0)|
| 13 | TABLE ACCESS FULL| PART | 1 | 200K| 1953K| | 392 (1)| 00:00:05 | 200K|00:00:00.02 | 1402 | 0 | | | |
| 14 | TABLE ACCESS FULL| ORDER_LINE | 1 | 3450K| 49M| | 3624 (2)| 00:00:44 | 3450K|00:00:01.13 | 13309 | 13157 | | | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
7 - SEL$FD6D9502 / C@SEL$2
8 - SEL$FD6D9502 / O@SEL$4
9 - SEL$FD6D9502 / C@SEL$4
10 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
11 - LINES_ROLLUP_QB
13 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
14 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$FD6D9502" "C"@"SEL$2")
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "C"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "O"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - (VARCHAR2(30), CSID=178): '4'
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("C"."CREDIT_LIMIT"'S' AND "O"."STATUS"<>'C'))
9 - access("O"."CUSTOMER_ID"="C"."CUSTOMER_ID")
12 - access("L"."PART_ID"="P"."PART_ID")
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - (#keys=1) SUM("LINES_TOTAL"."ORDER_TOTAL")-"C"."CREDIT_LIMIT"[22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], SUM("LINES_TOTAL"."ORDER_TOTAL")[22],
"C"."CREDIT_LIMIT"[NUMBER,22]
2 - "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], SUM("LINES_TOTAL"."ORDER_TOTAL")[22]
3 - "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], SUM("LINES_TOTAL"."ORDER_TOTAL")[22]
4 - (#keys=1) "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000],
"LINES_TOTAL"."ORDER_TOTAL"[NUMBER,22]
5 - "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], "O"."ORDER_ID"[NUMBER,22]
6 - (#keys=1) "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], "O"."ORDER_ID"[NUMBER,22]
7 - ROWID[ROWID,10], "C"."CUSTOMER_ID"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], "C"."CREDIT_LIMIT"[NUMBER,22]
8 - "O"."ORDER_ID"[NUMBER,22], "O"."CUSTOMER_ID"[NUMBER,22]
10 - "LINES_TOTAL"."ORDER_ID"[NUMBER,22], "LINES_TOTAL"."ORDER_TOTAL"[NUMBER,22]
11 - "L"."ORDER_ID"[NUMBER,22], COUNT(*)[22], SUM(ROUND("L"."QUANTITY"*"P"."PART_PRICE"*(100-NVL("L"."DISCOUNT_PERC",0))/100,2))[22], SUM("L"."QUANTITY")[22]
12 - (#keys=1) "P"."PART_PRICE"[NUMBER,22], "L"."ORDER_ID"[NUMBER,22], "L"."DISCOUNT_PERC"[NUMBER,22], "L"."QUANTITY"[NUMBER,22]
13 - "P"."PART_ID"[NUMBER,22], "P"."PART_PRICE"[NUMBER,22]
14 - "L"."ORDER_ID"[NUMBER,22], "L"."PART_ID"[NUMBER,22], "L"."QUANTITY"[NUMBER,22], "L"."DISCOUNT_PERC"[NUMBER,22]
Current Execution Plans (all executions)
Captured while still in memory. Metrics below are an aggregate for all the execution of each child cursor.
If STATISTICS_LEVEL was set to ALL at the time of the hard-parse then A-Rows column is populated.
Inst: 1 Child: 0 Plan hash value: 2816325939
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes|E-Temp | Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | O/1/M |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2 | | | | 19614 (100)| | 1844 |00:00:09.24 | 41284 | 30516 | | | |
| 1 | SORT ORDER BY | | 2 | 184 | 18216 | | 19614 (2)| 00:03:56 | 1844 |00:00:09.24 | 41284 | 30516 | 124K| 124K| 2/0/0|
|* 2 | FILTER | | 2 | | | | | | 1844 |00:00:09.24 | 41284 | 30516 | | | |
| 3 | HASH GROUP BY | | 2 | 184 | 18216 | | 19614 (2)| 00:03:56 | 2352 |00:00:09.24 | 41284 | 30516 | 776K| 776K| 2/0/0|
|* 4 | HASH JOIN | | 2 | 4274 | 413K| | 19612 (2)| 00:03:56 | 6968 |00:00:09.22 | 41284 | 30516 | 936K| 936K| 2/0/0|
| 5 | NESTED LOOPS | | 2 | 4274 | 338K| | 690 (2)| 00:00:09 | 6968 |00:00:01.21 | 11862 | 2656 | | | |
|* 6 | HASH JOIN | | 2 | 4274 | 317K| | 690 (2)| 00:00:09 | 6968 |00:00:00.19 | 4890 | 2439 | 813K| 813K| 2/0/0|
|* 7 | TABLE ACCESS FULL | CUSTOMER | 2 | 1457 | 93248 | | 221 (1)| 00:00:03 | 2478 |00:00:00.03 | 1568 | 781 | | | |
|* 8 | TABLE ACCESS FULL | SALES_ORDER | 2 | 281K| 3298K| | 467 (2)| 00:00:06 | 563K|00:00:00.11 | 3322 | 1658 | | | |
|* 9 | INDEX UNIQUE SCAN | CUSTOMER_PK | 6968 | 1 | 5 | | 0 (0)| | 6968 |00:00:00.11 | 6972 | 217 | | | |
| 10 | VIEW | | 2 | 302K| 5325K| | 18919 (2)| 00:03:48 | 599K|00:00:08.74 | 29422 | 27860 | | | |
| 11 | HASH GROUP BY | | 2 | 302K| 7396K| 130M| 18919 (2)| 00:03:48 | 599K|00:00:08.63 | 29422 | 27860 | 26M| 4367K| 2/0/0|
|* 12 | HASH JOIN | | 2 | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 | 6900K|00:00:07.99 | 29422 | 27860 | 8136K| 3216K| 2/0/0|
| 13 | TABLE ACCESS FULL| PART | 2 | 200K| 1953K| | 392 (1)| 00:00:05 | 400K|00:00:01.24 | 2804 | 1399 | | | |
| 14 | TABLE ACCESS FULL| ORDER_LINE | 2 | 3450K| 49M| | 3624 (2)| 00:00:44 | 6900K|00:00:02.56 | 26618 | 26461 | | | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
7 - SEL$FD6D9502 / C@SEL$2
8 - SEL$FD6D9502 / O@SEL$4
9 - SEL$FD6D9502 / C@SEL$4
10 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
11 - LINES_ROLLUP_QB
13 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
14 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$FD6D9502" "C"@"SEL$2")
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "C"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "O"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - (VARCHAR2(30), CSID=178): '4'
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("C"."CREDIT_LIMIT"'S' AND "O"."STATUS"<>'C'))
9 - access("O"."CUSTOMER_ID"="C"."CUSTOMER_ID")
12 - access("L"."PART_ID"="P"."PART_ID")
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - (#keys=1) SUM("LINES_TOTAL"."ORDER_TOTAL")-"C"."CREDIT_LIMIT"[22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], SUM("LINES_TOTAL"."ORDER_TOTAL")[22],
"C"."CREDIT_LIMIT"[NUMBER,22]
2 - "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], SUM("LINES_TOTAL"."ORDER_TOTAL")[22]
3 - "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], SUM("LINES_TOTAL"."ORDER_TOTAL")[22]
4 - (#keys=1) "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000],
"LINES_TOTAL"."ORDER_TOTAL"[NUMBER,22]
5 - "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], "O"."ORDER_ID"[NUMBER,22]
6 - (#keys=1) "O"."CUSTOMER_ID"[NUMBER,22], ROWID[ROWID,10], "C"."CREDIT_LIMIT"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], "O"."ORDER_ID"[NUMBER,22]
7 - ROWID[ROWID,10], "C"."CUSTOMER_ID"[NUMBER,22], "C"."CUSTOMER_NAME"[VARCHAR2,4000], "C"."CREDIT_LIMIT"[NUMBER,22]
8 - "O"."ORDER_ID"[NUMBER,22], "O"."CUSTOMER_ID"[NUMBER,22]
10 - "LINES_TOTAL"."ORDER_ID"[NUMBER,22], "LINES_TOTAL"."ORDER_TOTAL"[NUMBER,22]
11 - "L"."ORDER_ID"[NUMBER,22], COUNT(*)[22], SUM(ROUND("L"."QUANTITY"*"P"."PART_PRICE"*(100-NVL("L"."DISCOUNT_PERC",0))/100,2))[22], SUM("L"."QUANTITY")[22]
12 - (#keys=1) "P"."PART_PRICE"[NUMBER,22], "L"."ORDER_ID"[NUMBER,22], "L"."DISCOUNT_PERC"[NUMBER,22], "L"."QUANTITY"[NUMBER,22]
13 - "P"."PART_ID"[NUMBER,22], "P"."PART_PRICE"[NUMBER,22]
14 - "L"."ORDER_ID"[NUMBER,22], "L"."PART_ID"[NUMBER,22], "L"."QUANTITY"[NUMBER,22], "L"."DISCOUNT_PERC"[NUMBER,22]
Historical Execution Plans
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 2903038705
------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 19129 (100)| |
| 1 | SORT ORDER BY | | 5 | 495 | | 19129 (2)| 00:03:50 |
| 2 | FILTER | | | | | | |
| 3 | HASH GROUP BY | | 5 | 495 | | 19129 (2)| 00:03:50 |
| 4 | HASH JOIN | | 92 | 9108 | | 19127 (2)| 00:03:50 |
| 5 | NESTED LOOPS | | 92 | 7452 | | 206 (0)| 00:00:03 |
| 6 | NESTED LOOPS | | 92 | 6992 | | 206 (0)| 00:00:03 |
| 7 | TABLE ACCESS BY INDEX ROWID| CUSTOMER | 31 | 1984 | | 25 (0)| 00:00:01 |
| 8 | INDEX RANGE SCAN | CUSTOMER_N2 | 31 | | | 2 (0)| 00:00:01 |
| 9 | TABLE ACCESS BY INDEX ROWID| SALES_ORDER | 3 | 36 | | 6 (0)| 00:00:01 |
| 10 | INDEX RANGE SCAN | SALES_ORDER_N2 | 3 | | | 2 (0)| 00:00:01 |
| 11 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| |
| 12 | VIEW | | 302K| 5325K| | 18919 (2)| 00:03:48 |
| 13 | HASH GROUP BY | | 302K| 7396K| 130M| 18919 (2)| 00:03:48 |
| 14 | HASH JOIN | | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 |
| 15 | TABLE ACCESS FULL | PART | 200K| 1953K| | 392 (1)| 00:00:05 |
| 16 | TABLE ACCESS FULL | ORDER_LINE | 3450K| 49M| | 3624 (2)| 00:00:44 |
------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
7 - SEL$FD6D9502 / C@SEL$2
8 - SEL$FD6D9502 / C@SEL$2
9 - SEL$FD6D9502 / O@SEL$4
10 - SEL$FD6D9502 / O@SEL$4
11 - SEL$FD6D9502 / C@SEL$4
12 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
13 - LINES_ROLLUP_QB
15 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
16 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.5')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
INDEX_RS_ASC(@"SEL$FD6D9502" "C"@"SEL$2" ("CUSTOMER"."CUSTOMER_TYPE" "CUSTOMER"."CREDIT_LIMIT"))
INDEX_RS_ASC(@"SEL$FD6D9502" "O"@"SEL$4" ("SALES_ORDER"."CUSTOMER_ID" "SALES_ORDER"."ORDER_DATE"))
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "C"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "O"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '5'
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 3314618365
-------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost |
-------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 15863 |
| 1 | SORT ORDER BY | | 2 | 140 | | 15863 |
| 2 | HASH JOIN | | 2 | 140 | | 15843 |
| 3 | TABLE ACCESS BY INDEX ROWID| CUSTOMER | 31 | 1612 | | 25 |
| 4 | INDEX RANGE SCAN | CUSTOMER_N2 | 31 | | | 2 |
| 5 | VIEW | | 95936 | 1686K| | 15817 |
| 6 | SORT GROUP BY | | 95936 | 4590K| 20M| 15817 |
| 7 | NESTED LOOPS | | 281K| 13M| | 14153 |
| 8 | HASH JOIN | | 281K| 11M| 8880K| 14153 |
| 9 | VIEW | | 302K| 5325K| | 13593 |
| 10 | SORT GROUP BY | | 302K| 7396K| 142M| 13593 |
| 11 | HASH JOIN | | 3416K| 81M| 4304K| 3701 |
| 12 | TABLE ACCESS FULL | PART | 200K| 1953K| | 219 |
| 13 | TABLE ACCESS FULL | ORDER_LINE | 3450K| 49M| | 1999 |
| 14 | TABLE ACCESS FULL | SALES_ORDER | 281K| 7147K| | 259 |
| 15 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | |
-------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1
3 - SEL$F5BB74E1 / C@SEL$2
4 - SEL$F5BB74E1 / C@SEL$2
5 - SEL$07BDC5B4 / ORDERS@SEL$2
6 - SEL$07BDC5B4
9 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
10 - LINES_ROLLUP_QB
12 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
13 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
14 - SEL$07BDC5B4 / O@SEL$4
15 - SEL$07BDC5B4 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('9.2.0.8')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE_LEAF(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
INDEX_RS_ASC(@"SEL$F5BB74E1" "C"@"SEL$2" ("CUSTOMER"."CUSTOMER_TYPE"
"CUSTOMER"."CREDIT_LIMIT"))
NO_ACCESS(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
LEADING(@"SEL$F5BB74E1" "C"@"SEL$2" "ORDERS"@"SEL$2")
USE_HASH(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
FULL(@"SEL$07BDC5B4" "O"@"SEL$4")
NO_ACCESS(@"SEL$07BDC5B4" "LINES_TOTAL"@"SEL$4")
INDEX(@"SEL$07BDC5B4" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$07BDC5B4" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" "C"@"SEL$4")
USE_HASH(@"SEL$07BDC5B4" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$07BDC5B4" "C"@"SEL$4")
SWAP_JOIN_INPUTS(@"SEL$07BDC5B4" "LINES_TOTAL"@"SEL$4")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '5'
Note
-----
- cpu costing is off (consider enabling it)
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 3267771367
-------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 536 (100)| |
| 1 | SORT ORDER BY | | 1 | 94 | 536 (1)| 00:00:07 |
| 2 | FILTER | | | | | |
| 3 | HASH GROUP BY | | 1 | 94 | 536 (1)| 00:00:07 |
| 4 | NESTED LOOPS | | 19 | 1786 | 534 (0)| 00:00:07 |
| 5 | NESTED LOOPS | | 19 | 1539 | 42 (0)| 00:00:01 |
| 6 | NESTED LOOPS | | 19 | 1444 | 42 (0)| 00:00:01 |
| 7 | TABLE ACCESS BY INDEX ROWID | CUSTOMER | 6 | 384 | 7 (0)| 00:00:01 |
| 8 | INDEX RANGE SCAN | CUSTOMER_N2 | 6 | | 2 (0)| 00:00:01 |
| 9 | TABLE ACCESS BY INDEX ROWID | SALES_ORDER | 3 | 36 | 6 (0)| 00:00:01 |
| 10 | INDEX RANGE SCAN | SALES_ORDER_N2 | 3 | | 2 (0)| 00:00:01 |
| 11 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | 0 (0)| |
| 12 | VIEW PUSHED PREDICATE | | 1 | 13 | 26 (0)| 00:00:01 |
| 13 | FILTER | | | | | |
| 14 | SORT AGGREGATE | | 1 | 25 | | |
| 15 | NESTED LOOPS | | | | | |
| 16 | NESTED LOOPS | | 11 | 275 | 26 (0)| 00:00:01 |
| 17 | TABLE ACCESS BY INDEX ROWID| ORDER_LINE | 11 | 165 | 15 (0)| 00:00:01 |
| 18 | INDEX RANGE SCAN | ORDER_LINE_N1 | 11 | | 3 (0)| 00:00:01 |
| 19 | INDEX UNIQUE SCAN | PART_PK | 1 | | 0 (0)| |
| 20 | TABLE ACCESS BY INDEX ROWID | PART | 1 | 10 | 1 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
7 - SEL$FD6D9502 / C@SEL$2
8 - SEL$FD6D9502 / C@SEL$2
9 - SEL$FD6D9502 / O@SEL$4
10 - SEL$FD6D9502 / O@SEL$4
11 - SEL$FD6D9502 / C@SEL$4
12 - SEL$F11C33E3 / LINES_TOTAL@SEL$4
13 - SEL$F11C33E3
17 - SEL$F11C33E3 / L@LINES_ROLLUP_QB
18 - SEL$F11C33E3 / L@LINES_ROLLUP_QB
19 - SEL$F11C33E3 / P@LINES_ROLLUP_QB
20 - SEL$F11C33E3 / P@LINES_ROLLUP_QB
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"SEL$F11C33E3")
PUSH_PRED(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4" 6)
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
INDEX_RS_ASC(@"SEL$FD6D9502" "C"@"SEL$2" ("CUSTOMER"."CUSTOMER_TYPE"
"CUSTOMER"."CREDIT_LIMIT"))
INDEX_RS_ASC(@"SEL$FD6D9502" "O"@"SEL$4" ("SALES_ORDER"."CUSTOMER_ID"
"SALES_ORDER"."ORDER_DATE"))
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "C"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "O"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
INDEX_RS_ASC(@"SEL$F11C33E3" "L"@"LINES_ROLLUP_QB" ("ORDER_LINE"."ORDER_ID"))
INDEX(@"SEL$F11C33E3" "P"@"LINES_ROLLUP_QB" ("PART"."PART_ID"))
LEADING(@"SEL$F11C33E3" "L"@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
USE_NL(@"SEL$F11C33E3" "P"@"LINES_ROLLUP_QB")
NLJ_BATCHING(@"SEL$F11C33E3" "P"@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '7'
Note
-----
- cardinality feedback used for this statement
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 1637264670
----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 20072 (100)| |
| 1 | SORT ORDER BY | | 1567 | 151K| | 20072 (2)| 00:04:01 |
| 2 | FILTER | | | | | | |
| 3 | HASH GROUP BY | | 1567 | 151K| | 20072 (2)| 00:04:01 |
| 4 | NESTED LOOPS | | 36540 | 3532K| | 20067 (2)| 00:04:01 |
| 5 | HASH JOIN | | 36540 | 3354K| 3144K| 20066 (2)| 00:04:01 |
| 6 | JOIN FILTER CREATE | :BF0000 | 36540 | 2711K| | 560 (2)| 00:00:07 |
| 7 | HASH JOIN | | 36540 | 2711K| | 560 (2)| 00:00:07 |
| 8 | TABLE ACCESS BY INDEX ROWID| CUSTOMER | 12490 | 780K| | 91 (0)| 00:00:02 |
| 9 | INDEX RANGE SCAN | CUSTOMER_N2 | 12490 | | | 1 (0)| 00:00:01 |
| 10 | TABLE ACCESS FULL | SALES_ORDER | 280K| 3288K| | 467 (2)| 00:00:06 |
| 11 | VIEW | | 302K| 5325K| | 18919 (2)| 00:03:48 |
| 12 | HASH GROUP BY | | 302K| 7396K| 130M| 18919 (2)| 00:03:48 |
| 13 | JOIN FILTER USE | :BF0000 | 3416K| 81M| | 8676 (2)| 00:01:45 |
| 14 | HASH JOIN | | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 |
| 15 | TABLE ACCESS FULL | PART | 200K| 1953K| | 392 (1)| 00:00:05 |
| 16 | TABLE ACCESS FULL | ORDER_LINE | 3450K| 49M| | 3624 (2)| 00:00:44 |
| 17 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 1 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
8 - SEL$FD6D9502 / C@SEL$2
9 - SEL$FD6D9502 / C@SEL$2
10 - SEL$FD6D9502 / O@SEL$4
11 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
12 - LINES_ROLLUP_QB
15 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
16 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
17 - SEL$FD6D9502 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
OPT_PARAM('optimizer_index_cost_adj' 1)
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
INDEX_RS_ASC(@"SEL$FD6D9502" "C"@"SEL$2" ("CUSTOMER"."CUSTOMER_TYPE" "CUSTOMER"."CREDIT_LIMIT"))
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "O"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
PX_JOIN_FILTER(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '3'
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 3427378629
-----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 21701 (100)| |
| 1 | SORT ORDER BY | | 69 | 4830 | | 21701 (2)| 00:04:21 |
| 2 | MERGE JOIN | | 69 | 4830 | | 21700 (2)| 00:04:21 |
| 3 | SORT JOIN | | 95934 | 1686K| | 21478 (2)| 00:04:18 |
| 4 | VIEW | | 95934 | 1686K| | 21478 (2)| 00:04:18 |
| 5 | HASH GROUP BY | | 95934 | 3091K| | 21478 (2)| 00:04:18 |
| 6 | NESTED LOOPS | | 95934 | 3091K| | 21478 (2)| 00:04:18 |
| 7 | VIEW | VW_GBC_10 | 95934 | 2623K| | 21467 (2)| 00:04:18 |
| 8 | HASH GROUP BY | | 95934 | 2810K| 10M| 21467 (2)| 00:04:18 |
| 9 | HASH JOIN | | 280K| 8222K| 6584K| 20142 (2)| 00:04:02 |
| 10 | TABLE ACCESS FULL | SALES_ORDER | 280K| 3288K| | 467 (2)| 00:00:06 |
| 11 | VIEW | | 302K| 5325K| | 18919 (2)| 00:03:48 |
| 12 | HASH GROUP BY | | 302K| 7396K| 130M| 18919 (2)| 00:03:48 |
| 13 | HASH JOIN | | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 |
| 14 | TABLE ACCESS FULL| PART | 200K| 1953K| | 392 (1)| 00:00:05 |
| 15 | TABLE ACCESS FULL| ORDER_LINE | 3450K| 49M| | 3624 (2)| 00:00:44 |
| 16 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| |
| 17 | FILTER | | | | | | |
| 18 | SORT JOIN | | 1379 | 71708 | | 222 (2)| 00:00:03 |
| 19 | TABLE ACCESS FULL | CUSTOMER | 1379 | 71708 | | 221 (1)| 00:00:03 |
-----------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1
4 - SEL$3A9CBE03 / ORDERS@SEL$2
5 - SEL$3A9CBE03
7 - SEL$86BDBEED / VW_GBC_10@SEL$05D28F8F
8 - SEL$86BDBEED
10 - SEL$86BDBEED / O@SEL$4
11 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
12 - LINES_ROLLUP_QB
14 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
15 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
16 - SEL$3A9CBE03 / C@SEL$4
19 - SEL$F5BB74E1 / C@SEL$2
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
OPT_PARAM('_complex_view_merging' 'false')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$86BDBEED")
OUTLINE_LEAF(@"SEL$3A9CBE03")
PLACE_GROUP_BY(@"SEL$07BDC5B4" ( "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" ) 10)
OUTLINE_LEAF(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$05D28F8F")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
NO_ACCESS(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
FULL(@"SEL$F5BB74E1" "C"@"SEL$2")
LEADING(@"SEL$F5BB74E1" "ORDERS"@"SEL$2" "C"@"SEL$2")
USE_MERGE(@"SEL$F5BB74E1" "C"@"SEL$2")
NO_ACCESS(@"SEL$3A9CBE03" "VW_GBC_10"@"SEL$05D28F8F")
INDEX(@"SEL$3A9CBE03" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$3A9CBE03" "VW_GBC_10"@"SEL$05D28F8F" "C"@"SEL$4")
USE_NL(@"SEL$3A9CBE03" "C"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$3A9CBE03")
FULL(@"SEL$86BDBEED" "O"@"SEL$4")
NO_ACCESS(@"SEL$86BDBEED" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$86BDBEED" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_HASH(@"SEL$86BDBEED" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$86BDBEED")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '4'
Note
-----
- cardinality feedback used for this statement
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 24296316
-------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 2769 (100)| |
| 1 | SORT ORDER BY | | 2 | 130 | 2769 (1)| 00:00:34 |
| 2 | NESTED LOOPS | | 2 | 130 | 2768 (1)| 00:00:34 |
| 3 | TABLE ACCESS BY INDEX ROWID | CUSTOMER | 32 | 1664 | 25 (0)| 00:00:01 |
| 4 | INDEX RANGE SCAN | CUSTOMER_N2 | 32 | | 2 (0)| 00:00:01 |
| 5 | VIEW PUSHED PREDICATE | | 1 | 13 | 86 (0)| 00:00:02 |
| 6 | FILTER | | | | | |
| 7 | SORT AGGREGATE | | 1 | 31 | | |
| 8 | NESTED LOOPS | | 1 | 31 | 86 (0)| 00:00:02 |
| 9 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | 1 (0)| 00:00:01 |
| 10 | VIEW PUSHED PREDICATE | VW_GBC_10 | 1 | 26 | 85 (0)| 00:00:02 |
| 11 | FILTER | | | | | |
| 12 | SORT AGGREGATE | | 1 | 25 | | |
| 13 | NESTED LOOPS | | 3 | 75 | 85 (0)| 00:00:02 |
| 14 | TABLE ACCESS BY INDEX ROWID | SALES_ORDER | 3 | 36 | 7 (0)| 00:00:01 |
| 15 | INDEX RANGE SCAN | SALES_ORDER_N2 | 3 | | 3 (0)| 00:00:01 |
| 16 | VIEW PUSHED PREDICATE | | 1 | 13 | 26 (0)| 00:00:01 |
| 17 | FILTER | | | | | |
| 18 | SORT AGGREGATE | | 1 | 25 | | |
| 19 | NESTED LOOPS | | | | | |
| 20 | NESTED LOOPS | | 11 | 275 | 26 (0)| 00:00:01 |
| 21 | TABLE ACCESS BY INDEX ROWID| ORDER_LINE | 11 | 165 | 15 (0)| 00:00:01 |
| 22 | INDEX RANGE SCAN | ORDER_LINE_N1 | 11 | | 3 (0)| 00:00:01 |
| 23 | INDEX UNIQUE SCAN | PART_PK | 1 | | 0 (0)| |
| 24 | TABLE ACCESS BY INDEX ROWID | PART | 1 | 10 | 1 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1
3 - SEL$F5BB74E1 / C@SEL$2
4 - SEL$F5BB74E1 / C@SEL$2
5 - SEL$7A7C4113 / ORDERS@SEL$2
6 - SEL$7A7C4113
9 - SEL$7A7C4113 / C@SEL$4
10 - SEL$01BF5B5D / VW_GBC_10@SEL$05D28F8F
11 - SEL$01BF5B5D
14 - SEL$01BF5B5D / O@SEL$4
15 - SEL$01BF5B5D / O@SEL$4
16 - SEL$F11C33E3 / LINES_TOTAL@SEL$4
17 - SEL$F11C33E3
21 - SEL$F11C33E3 / L@LINES_ROLLUP_QB
22 - SEL$F11C33E3 / L@LINES_ROLLUP_QB
23 - SEL$F11C33E3 / P@LINES_ROLLUP_QB
24 - SEL$F11C33E3 / P@LINES_ROLLUP_QB
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
OPT_PARAM('_complex_view_merging' 'false')
ALL_ROWS
OUTLINE_LEAF(@"SEL$F11C33E3")
PUSH_PRED(@"SEL$86BDBEED" "LINES_TOTAL"@"SEL$4" 1)
OUTLINE_LEAF(@"SEL$01BF5B5D")
PUSH_PRED(@"SEL$3A9CBE03" "VW_GBC_10"@"SEL$05D28F8F" 1)
OUTLINE_LEAF(@"SEL$7A7C4113")
PUSH_PRED(@"SEL$F5BB74E1" "ORDERS"@"SEL$2" 3)
OUTLINE_LEAF(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$86BDBEED")
OUTLINE(@"SEL$3A9CBE03")
PLACE_GROUP_BY(@"SEL$07BDC5B4" ( "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" ) 10)
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$05D28F8F")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
INDEX_RS_ASC(@"SEL$F5BB74E1" "C"@"SEL$2" ("CUSTOMER"."CUSTOMER_TYPE" "CUSTOMER"."CREDIT_LIMIT"))
NO_ACCESS(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
LEADING(@"SEL$F5BB74E1" "C"@"SEL$2" "ORDERS"@"SEL$2")
USE_NL(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
INDEX(@"SEL$7A7C4113" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
NO_ACCESS(@"SEL$7A7C4113" "VW_GBC_10"@"SEL$05D28F8F")
LEADING(@"SEL$7A7C4113" "C"@"SEL$4" "VW_GBC_10"@"SEL$05D28F8F")
USE_NL(@"SEL$7A7C4113" "VW_GBC_10"@"SEL$05D28F8F")
INDEX_RS_ASC(@"SEL$01BF5B5D" "O"@"SEL$4" ("SALES_ORDER"."CUSTOMER_ID" "SALES_ORDER"."ORDER_DATE"))
NO_ACCESS(@"SEL$01BF5B5D" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$01BF5B5D" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$01BF5B5D" "LINES_TOTAL"@"SEL$4")
INDEX_RS_ASC(@"SEL$F11C33E3" "L"@"LINES_ROLLUP_QB" ("ORDER_LINE"."ORDER_ID"))
INDEX(@"SEL$F11C33E3" "P"@"LINES_ROLLUP_QB" ("PART"."PART_ID"))
LEADING(@"SEL$F11C33E3" "L"@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
USE_NL(@"SEL$F11C33E3" "P"@"LINES_ROLLUP_QB")
NLJ_BATCHING(@"SEL$F11C33E3" "P"@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '5'
Note
-----
- cardinality feedback used for this statement
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 142578110
-----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 21701 (100)| |
| 1 | SORT ORDER BY | | 625 | 43750 | | 21701 (2)| 00:04:21 |
| 2 | HASH JOIN | | 625 | 43750 | | 21700 (2)| 00:04:21 |
| 3 | JOIN FILTER CREATE | :BF0000 | 12490 | 634K| | 221 (1)| 00:00:03 |
| 4 | TABLE ACCESS FULL | CUSTOMER | 12490 | 634K| | 221 (1)| 00:00:03 |
| 5 | VIEW | | 95934 | 1686K| | 21478 (2)| 00:04:18 |
| 6 | HASH GROUP BY | | 95934 | 3091K| | 21478 (2)| 00:04:18 |
| 7 | JOIN FILTER USE | :BF0000 | 95934 | 3091K| | 21478 (2)| 00:04:18 |
| 8 | NESTED LOOPS | | 95934 | 3091K| | 21478 (2)| 00:04:18 |
| 9 | VIEW | VW_GBC_10 | 95934 | 2623K| | 21467 (2)| 00:04:18 |
| 10 | HASH GROUP BY | | 95934 | 2810K| 10M| 21467 (2)| 00:04:18 |
| 11 | HASH JOIN | | 280K| 8222K| 6584K| 20142 (2)| 00:04:02 |
| 12 | TABLE ACCESS FULL | SALES_ORDER | 280K| 3288K| | 467 (2)| 00:00:06 |
| 13 | VIEW | | 302K| 5325K| | 18919 (2)| 00:03:48 |
| 14 | HASH GROUP BY | | 302K| 7396K| 130M| 18919 (2)| 00:03:48 |
| 15 | HASH JOIN | | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 |
| 16 | TABLE ACCESS FULL| PART | 200K| 1953K| | 392 (1)| 00:00:05 |
| 17 | TABLE ACCESS FULL| ORDER_LINE | 3450K| 49M| | 3624 (2)| 00:00:44 |
| 18 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| |
-----------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1
4 - SEL$F5BB74E1 / C@SEL$2
5 - SEL$3A9CBE03 / ORDERS@SEL$2
6 - SEL$3A9CBE03
9 - SEL$86BDBEED / VW_GBC_10@SEL$05D28F8F
10 - SEL$86BDBEED
12 - SEL$86BDBEED / O@SEL$4
13 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
14 - LINES_ROLLUP_QB
16 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
17 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
18 - SEL$3A9CBE03 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
OPT_PARAM('_complex_view_merging' 'false')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$86BDBEED")
OUTLINE_LEAF(@"SEL$3A9CBE03")
PLACE_GROUP_BY(@"SEL$07BDC5B4" ( "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" ) 10)
OUTLINE_LEAF(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$05D28F8F")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$F5BB74E1" "C"@"SEL$2")
NO_ACCESS(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
LEADING(@"SEL$F5BB74E1" "C"@"SEL$2" "ORDERS"@"SEL$2")
USE_HASH(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
PX_JOIN_FILTER(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
NO_ACCESS(@"SEL$3A9CBE03" "VW_GBC_10"@"SEL$05D28F8F")
INDEX(@"SEL$3A9CBE03" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$3A9CBE03" "VW_GBC_10"@"SEL$05D28F8F" "C"@"SEL$4")
USE_NL(@"SEL$3A9CBE03" "C"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$3A9CBE03")
FULL(@"SEL$86BDBEED" "O"@"SEL$4")
NO_ACCESS(@"SEL$86BDBEED" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$86BDBEED" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_HASH(@"SEL$86BDBEED" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$86BDBEED")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '3'
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 2816325939
------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 19946 (100)| |
| 1 | SORT ORDER BY | | 173 | 17127 | | 19946 (4)| 00:04:00 |
| 2 | FILTER | | | | | | |
| 3 | HASH GROUP BY | | 173 | 17127 | | 19946 (4)| 00:04:00 |
| 4 | HASH JOIN | | 4034 | 390K| | 19944 (4)| 00:04:00 |
| 5 | NESTED LOOPS | | 4034 | 319K| | 701 (4)| 00:00:09 |
| 6 | HASH JOIN | | 4034 | 299K| | 700 (3)| 00:00:09 |
| 7 | TABLE ACCESS FULL | CUSTOMER | 1379 | 88256 | | 223 (2)| 00:00:03 |
| 8 | TABLE ACCESS FULL | SALES_ORDER | 280K| 3288K| | 473 (3)| 00:00:06 |
| 9 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| |
| 10 | VIEW | | 302K| 5325K| | 19239 (4)| 00:03:51 |
| 11 | HASH GROUP BY | | 302K| 7396K| 130M| 19239 (4)| 00:03:51 |
| 12 | HASH JOIN | | 3416K| 81M| 4304K| 8783 (3)| 00:01:46 |
| 13 | TABLE ACCESS FULL| PART | 200K| 1953K| | 396 (2)| 00:00:05 |
| 14 | TABLE ACCESS FULL| ORDER_LINE | 3450K| 49M| | 3682 (4)| 00:00:45 |
------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
7 - SEL$FD6D9502 / C@SEL$2
8 - SEL$FD6D9502 / O@SEL$4
9 - SEL$FD6D9502 / C@SEL$4
10 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
11 - LINES_ROLLUP_QB
13 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
14 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$FD6D9502" "C"@"SEL$2")
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "C"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "O"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '4'
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 657302870
--------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 20205 (100)| |
| 1 | SORT ORDER BY | | 1567 | 151K| | 20205 (2)| 00:04:03 |
| 2 | FILTER | | | | | | |
| 3 | HASH GROUP BY | | 1567 | 151K| | 20205 (2)| 00:04:03 |
| 4 | NESTED LOOPS | | 36540 | 3532K| | 20200 (2)| 00:04:03 |
| 5 | HASH JOIN | | 36540 | 3354K| 3144K| 20196 (2)| 00:04:03 |
| 6 | JOIN FILTER CREATE | :BF0000 | 36540 | 2711K| | 690 (2)| 00:00:09 |
| 7 | HASH JOIN | | 36540 | 2711K| | 690 (2)| 00:00:09 |
| 8 | TABLE ACCESS FULL | CUSTOMER | 12490 | 780K| | 221 (1)| 00:00:03 |
| 9 | TABLE ACCESS FULL | SALES_ORDER | 280K| 3288K| | 467 (2)| 00:00:06 |
| 10 | VIEW | | 302K| 5325K| | 18919 (2)| 00:03:48 |
| 11 | HASH GROUP BY | | 302K| 7396K| 130M| 18919 (2)| 00:03:48 |
| 12 | JOIN FILTER USE | :BF0000 | 3416K| 81M| | 8676 (2)| 00:01:45 |
| 13 | HASH JOIN | | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 |
| 14 | TABLE ACCESS FULL| PART | 200K| 1953K| | 392 (1)| 00:00:05 |
| 15 | TABLE ACCESS FULL| ORDER_LINE | 3450K| 49M| | 3624 (2)| 00:00:44 |
| 16 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| |
--------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
8 - SEL$FD6D9502 / C@SEL$2
9 - SEL$FD6D9502 / O@SEL$4
10 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
11 - LINES_ROLLUP_QB
14 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
15 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
16 - SEL$FD6D9502 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$FD6D9502" "C"@"SEL$2")
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "O"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
PX_JOIN_FILTER(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '3'
Note
-----
- cardinality feedback used for this statement
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 1503269649
-------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 20997 (100)| |
| 1 | SORT ORDER BY | | 4820 | 465K| | 20997 (2)| 00:04:12 |
| 2 | FILTER | | | | | | |
| 3 | HASH GROUP BY | | 4820 | 465K| | 20997 (2)| 00:04:12 |
| 4 | NESTED LOOPS | | 112K| 10M| | 20985 (2)| 00:04:12 |
| 5 | HASH JOIN | | 112K| 10M| 8880K| 20971 (2)| 00:04:12 |
| 6 | VIEW | | 302K| 5325K| | 18919 (2)| 00:03:48 |
| 7 | HASH GROUP BY | | 302K| 7396K| 130M| 18919 (2)| 00:03:48 |
| 8 | HASH JOIN | | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 |
| 9 | TABLE ACCESS FULL| PART | 200K| 1953K| | 392 (1)| 00:00:05 |
| 10 | TABLE ACCESS FULL| ORDER_LINE | 3450K| 49M| | 3624 (2)| 00:00:44 |
| 11 | HASH JOIN | | 112K| 8345K| 2856K| 1149 (2)| 00:00:14 |
| 12 | TABLE ACCESS FULL | CUSTOMER | 38437 | 2402K| | 221 (1)| 00:00:03 |
| 13 | TABLE ACCESS FULL | SALES_ORDER | 280K| 3288K| | 467 (2)| 00:00:06 |
| 14 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| |
-------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
6 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
7 - LINES_ROLLUP_QB
9 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
10 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
12 - SEL$FD6D9502 / C@SEL$2
13 - SEL$FD6D9502 / O@SEL$4
14 - SEL$FD6D9502 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$FD6D9502" "C"@"SEL$2")
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "O"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
SWAP_JOIN_INPUTS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '1'
Note
-----
- cardinality feedback used for this statement
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 737414948
----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost |
----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 15964 |
| 1 | SORT ORDER BY | | 73 | 5110 | | 15964 |
| 2 | HASH JOIN | | 73 | 5110 | | 15944 |
| 3 | TABLE ACCESS FULL | CUSTOMER | 1457 | 75764 | | 123 |
| 4 | VIEW | | 95936 | 1686K| | 15817 |
| 5 | SORT GROUP BY | | 95936 | 4590K| 20M| 15817 |
| 6 | NESTED LOOPS | | 281K| 13M| | 14153 |
| 7 | HASH JOIN | | 281K| 11M| 8880K| 14153 |
| 8 | VIEW | | 302K| 5325K| | 13593 |
| 9 | SORT GROUP BY | | 302K| 7396K| 142M| 13593 |
| 10 | HASH JOIN | | 3416K| 81M| 4304K| 3701 |
| 11 | TABLE ACCESS FULL| PART | 200K| 1953K| | 219 |
| 12 | TABLE ACCESS FULL| ORDER_LINE | 3450K| 49M| | 1999 |
| 13 | TABLE ACCESS FULL | SALES_ORDER | 281K| 7147K| | 259 |
| 14 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | |
----------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1
3 - SEL$F5BB74E1 / C@SEL$2
4 - SEL$07BDC5B4 / ORDERS@SEL$2
5 - SEL$07BDC5B4
8 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
9 - LINES_ROLLUP_QB
11 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
12 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
13 - SEL$07BDC5B4 / O@SEL$4
14 - SEL$07BDC5B4 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('9.2.0.8')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE_LEAF(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
FULL(@"SEL$F5BB74E1" "C"@"SEL$2")
NO_ACCESS(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
LEADING(@"SEL$F5BB74E1" "C"@"SEL$2" "ORDERS"@"SEL$2")
USE_HASH(@"SEL$F5BB74E1" "ORDERS"@"SEL$2")
FULL(@"SEL$07BDC5B4" "O"@"SEL$4")
NO_ACCESS(@"SEL$07BDC5B4" "LINES_TOTAL"@"SEL$4")
INDEX(@"SEL$07BDC5B4" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$07BDC5B4" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" "C"@"SEL$4")
USE_HASH(@"SEL$07BDC5B4" "LINES_TOTAL"@"SEL$4")
USE_NL(@"SEL$07BDC5B4" "C"@"SEL$4")
SWAP_JOIN_INPUTS(@"SEL$07BDC5B4" "LINES_TOTAL"@"SEL$4")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '4'
Note
-----
- cpu costing is off (consider enabling it)
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 3322900607
-------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
-------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 3180 (100)| | | | |
| 1 | PX COORDINATOR | | | | | | | | | |
| 2 | PX SEND QC (ORDER) | :TQ10008 | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,08 | P->S | QC (ORDER) |
| 3 | SORT ORDER BY | | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,08 | PCWP | |
| 4 | PX RECEIVE | | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,08 | PCWP | |
| 5 | PX SEND RANGE | :TQ10007 | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,07 | P->P | RANGE |
| 6 | FILTER | | | | | | | Q1,07 | PCWC | |
| 7 | HASH GROUP BY | | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,07 | PCWP | |
| 8 | PX RECEIVE | | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,07 | PCWP | |
| 9 | PX SEND HASH | :TQ10006 | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,06 | P->P | HASH |
| 10 | HASH GROUP BY | | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,06 | PCWP | |
| 11 | HASH JOIN | | 142K| 13M| | 3176 (2)| 00:00:39 | Q1,06 | PCWP | |
| 12 | PX RECEIVE | | 302K| 5325K| | 3077 (2)| 00:00:37 | Q1,06 | PCWP | |
| 13 | PX SEND HASH | :TQ10004 | 302K| 5325K| | 3077 (2)| 00:00:37 | Q1,04 | P->P | HASH |
| 14 | VIEW | | 302K| 5325K| | 3077 (2)| 00:00:37 | Q1,04 | PCWP | |
| 15 | HASH GROUP BY | | 302K| 7396K| 130M| 3077 (2)| 00:00:37 | Q1,04 | PCWP | |
| 16 | PX RECEIVE | | 3416K| 81M| | 560 (2)| 00:00:07 | Q1,04 | PCWP | |
| 17 | PX SEND HASH | :TQ10001 | 3416K| 81M| | 560 (2)| 00:00:07 | Q1,01 | P->P | HASH |
| 18 | HASH JOIN | | 3416K| 81M| | 560 (2)| 00:00:07 | Q1,01 | PCWP | |
| 19 | PX RECEIVE | | 200K| 1953K| | 54 (0)| 00:00:01 | Q1,01 | PCWP | |
| 20 | PX SEND BROADCAST | :TQ10000 | 200K| 1953K| | 54 (0)| 00:00:01 | Q1,00 | P->P | BROADCAST |
| 21 | PX BLOCK ITERATOR | | 200K| 1953K| | 54 (0)| 00:00:01 | Q1,00 | PCWC | |
| 22 | TABLE ACCESS FULL| PART | 200K| 1953K| | 54 (0)| 00:00:01 | Q1,00 | PCWP | |
| 23 | PX BLOCK ITERATOR | | 3450K| 49M| | 503 (2)| 00:00:07 | Q1,01 | PCWC | |
| 24 | TABLE ACCESS FULL | ORDER_LINE | 3450K| 49M| | 503 (2)| 00:00:07 | Q1,01 | PCWP | |
| 25 | PX RECEIVE | | 142K| 11M| | 98 (5)| 00:00:02 | Q1,06 | PCWP | |
| 26 | PX SEND HASH | :TQ10005 | 142K| 11M| | 98 (5)| 00:00:02 | Q1,05 | P->P | HASH |
| 27 | BUFFER SORT | | 6126 | 592K| | 3180 (2)| 00:00:39 | Q1,05 | PCWP | |
| 28 | NESTED LOOPS | | 142K| 11M| | 98 (5)| 00:00:02 | Q1,05 | PCWP | |
| 29 | HASH JOIN | | 142K| 10M| | 96 (3)| 00:00:02 | Q1,05 | PCWP | |
| 30 | JOIN FILTER CREATE | :BF0000 | 48708 | 3044K| | 31 (4)| 00:00:01 | Q1,05 | PCWP | |
| 31 | PX RECEIVE | | 48708 | 3044K| | 31 (4)| 00:00:01 | Q1,05 | PCWP | |
| 32 | PX SEND HASH | :TQ10002 | 48708 | 3044K| | 31 (4)| 00:00:01 | Q1,02 | P->P | HASH |
| 33 | PX BLOCK ITERATOR | | 48708 | 3044K| | 31 (4)| 00:00:01 | Q1,02 | PCWC | |
| 34 | TABLE ACCESS FULL | CUSTOMER | 48708 | 3044K| | 31 (4)| 00:00:01 | Q1,02 | PCWP | |
| 35 | PX RECEIVE | | 281K| 3298K| | 65 (2)| 00:00:01 | Q1,05 | PCWP | |
| 36 | PX SEND HASH | :TQ10003 | 281K| 3298K| | 65 (2)| 00:00:01 | Q1,03 | P->P | HASH |
| 37 | JOIN FILTER USE | :BF0000 | 281K| 3298K| | 65 (2)| 00:00:01 | Q1,03 | PCWP | |
| 38 | PX BLOCK ITERATOR | | 281K| 3298K| | 65 (2)| 00:00:01 | Q1,03 | PCWC | |
| 39 | TABLE ACCESS FULL | SALES_ORDER | 281K| 3298K| | 65 (2)| 00:00:01 | Q1,03 | PCWP | |
| 40 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| | Q1,05 | PCWP | |
-------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
14 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
15 - LINES_ROLLUP_QB
22 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
24 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
34 - SEL$FD6D9502 / C@SEL$2
39 - SEL$FD6D9502 / O@SEL$4
40 - SEL$FD6D9502 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$FD6D9502" "C"@"SEL$2")
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
LEADING(@"SEL$FD6D9502" "C"@"SEL$2" "O"@"SEL$4" "C"@"SEL$4" "LINES_TOTAL"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "O"@"SEL$4")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
PQ_DISTRIBUTE(@"SEL$FD6D9502" "O"@"SEL$4" HASH HASH)
PX_JOIN_FILTER(@"SEL$FD6D9502" "O"@"SEL$4")
PQ_DISTRIBUTE(@"SEL$FD6D9502" "C"@"SEL$4" NONE BROADCAST)
PQ_DISTRIBUTE(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4" HASH HASH)
SWAP_JOIN_INPUTS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
GBY_PUSHDOWN(@"SEL$FD6D9502")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
PQ_DISTRIBUTE(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB" BROADCAST NONE)
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '2'
SQL_ID f995z9antmhxn
--------------------
SELECT /*+ gather_plan_statistics monitor bind_aware */
v.customer_name, v.orders_total, v.credit_limit,
(orders_total - credit_limit) over_limit FROM customer_v v WHERE
orders_total > credit_limit AND customer_type = :b1 ORDER BY
over_limit DESC
Plan hash value: 1186590923
--------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 21128 (100)| |
| 1 | SORT ORDER BY | | 5974 | 577K| | 21128 (2)| 00:04:14 |
| 2 | FILTER | | | | | | |
| 3 | HASH GROUP BY | | 5974 | 577K| | 21128 (2)| 00:04:14 |
| 4 | NESTED LOOPS | | 139K| 13M| | 21113 (2)| 00:04:14 |
| 5 | HASH JOIN | | 139K| 12M| 3544K| 21097 (2)| 00:04:14 |
| 6 | TABLE ACCESS FULL | CUSTOMER | 47646 | 2977K| | 221 (1)| 00:00:03 |
| 7 | HASH JOIN | | 280K| 8222K| 6584K| 20142 (2)| 00:04:02 |
| 8 | TABLE ACCESS FULL | SALES_ORDER | 280K| 3288K| | 467 (2)| 00:00:06 |
| 9 | VIEW | | 302K| 5325K| | 18919 (2)| 00:03:48 |
| 10 | HASH GROUP BY | | 302K| 7396K| 130M| 18919 (2)| 00:03:48 |
| 11 | HASH JOIN | | 3416K| 81M| 4304K| 8676 (2)| 00:01:45 |
| 12 | TABLE ACCESS FULL| PART | 200K| 1953K| | 392 (1)| 00:00:05 |
| 13 | TABLE ACCESS FULL| ORDER_LINE | 3450K| 49M| | 3624 (2)| 00:00:44 |
| 14 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 5 | | 0 (0)| |
--------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$FD6D9502
6 - SEL$FD6D9502 / C@SEL$2
8 - SEL$FD6D9502 / O@SEL$4
9 - LINES_ROLLUP_QB / LINES_TOTAL@SEL$4
10 - LINES_ROLLUP_QB
12 - LINES_ROLLUP_QB / P@LINES_ROLLUP_QB
13 - LINES_ROLLUP_QB / L@LINES_ROLLUP_QB
14 - SEL$FD6D9502 / C@SEL$4
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
DB_VERSION('11.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"LINES_ROLLUP_QB")
OUTLINE_LEAF(@"SEL$FD6D9502")
MERGE(@"SEL$07BDC5B4")
OUTLINE(@"LINES_ROLLUP_QB")
OUTLINE(@"SEL$F5BB74E1")
MERGE(@"SEL$2")
OUTLINE(@"SEL$07BDC5B4")
MERGE(@"SEL$4")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$4")
FULL(@"SEL$FD6D9502" "O"@"SEL$4")
NO_ACCESS(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
FULL(@"SEL$FD6D9502" "C"@"SEL$2")
INDEX(@"SEL$FD6D9502" "C"@"SEL$4" ("CUSTOMER"."CUSTOMER_ID"))
LEADING(@"SEL$FD6D9502" "O"@"SEL$4" "LINES_TOTAL"@"SEL$4" "C"@"SEL$2" "C"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "LINES_TOTAL"@"SEL$4")
USE_HASH(@"SEL$FD6D9502" "C"@"SEL$2")
USE_NL(@"SEL$FD6D9502" "C"@"SEL$4")
SWAP_JOIN_INPUTS(@"SEL$FD6D9502" "C"@"SEL$2")
USE_HASH_AGGREGATION(@"SEL$FD6D9502")
FULL(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB")
FULL(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
LEADING(@"LINES_ROLLUP_QB" "P"@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH(@"LINES_ROLLUP_QB" "L"@"LINES_ROLLUP_QB")
USE_HASH_AGGREGATION(@"LINES_ROLLUP_QB")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :B1 (VARCHAR2(30), CSID=178): '2'
1366133.1 SQLHC 11.4.5.2 2012-12-26/18:03:59