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