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
Global Information: DONE (ALL ROWS)Instance ID | : | 1 |
|
||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Session | : | QTUNE (15:1477) | |||||||||||||||||||
SQL ID | : | f995z9antmhxn | |||||||||||||||||||
SQL Execution ID | : | 16777299 | |||||||||||||||||||
Execution Started | : | 02/04/2013 10:39:02 | |||||||||||||||||||
First Refresh Time | : | 02/04/2013 10:39:02 | |||||||||||||||||||
Last Refresh Time | : | 02/04/2013 10:39:03 | |||||||||||||||||||
Duration | : | 1s | |||||||||||||||||||
Module/Action | : | SQL*Plus/- | |||||||||||||||||||
Service | : | SYS$USERS | |||||||||||||||||||
Program | : | sqlplus@host01.example.com (TNS V1-V3) | |||||||||||||||||||
Fetch Calls | : | 4 |
Name | Position | Type | Value |
---|---|---|---|
:B1 | 1 | VARCHAR2(32) | 5 |
Id | Operation | Name |
Estimated
Rows |
Cost |
Active Period
(1s) |
Execs | Rows |
Memory
(Max) |
Temp
(Max) |
IO Requests | CPU Activity | Wait Activity | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
. |
0 | SELECT STATEMENT |
. |
. |
. |
|
1 | 42 |
. |
. |
|
. |
. |
||||||
. |
1 | . SORT ORDER BY |
. |
12 | 7767 |
|
1 | 42 | 4.0KB |
. |
|
. |
. |
||||||
. |
2 | .. FILTER |
. |
. |
. |
|
1 | 42 |
. |
. |
|
. |
. |
||||||
. |
3 | ... HASH GROUP BY |
. |
12 | 7767 |
|
1 | 46 | 1.2MB |
. |
|
. |
. |
||||||
. |
4 | .... NESTED LOOPS |
. |
279 | 7765 |
|
1 | 129 |
. |
. |
|
. |
. |
||||||
. |
5 | ..... NESTED LOOPS |
. |
279 | 7765 |
|
1 | 129 |
. |
. |
|
. |
. |
||||||
. |
6 | ...... HASH JOIN |
. |
279 | 538 |
|
1 | 129 | 1.2MB |
. |
|
|
|
||||||
. |
7 | ....... TABLE ACCESS BY INDEX ROWID | CUSTOMER | 95 | 71 |
|
1 | 47 |
. |
. |
|
. |
. |
||||||
. |
8 | ........ INDEX RANGE SCAN | CUSTOMER_N2 | 95 | 2 |
|
1 | 47 |
. |
. |
|
. |
. |
||||||
. |
9 | ....... TABLE ACCESS FULL | SALES_ORDER | 282K | 465 |
|
1 | 282K |
. |
. |
|
. |
. |
||||||
. |
10 | ...... VIEW PUSHED PREDICATE |
. |
1 | 26 |
|
129 | 129 |
. |
. |
|
. |
. |
||||||
. |
11 | ....... FILTER |
. |
. |
. |
|
129 | 129 |
. |
. |
|
. |
. |
||||||
. |
12 | ........ SORT AGGREGATE |
. |
1 |
. |
|
129 | 129 |
. |
. |
|
. |
. |
||||||
. |
13 | ......... NESTED LOOPS |
. |
. |
. |
|
129 | 1488 |
. |
. |
|
. |
. |
||||||
. |
14 | .......... NESTED LOOPS |
. |
11 | 26 |
|
129 | 1488 |
. |
. |
|
. |
. |
||||||
. |
15 | ........... TABLE ACCESS BY INDEX ROWID | ORDER_LINE | 11 | 15 |
|
129 | 1488 |
. |
. |
|
. |
. |
||||||
. |
16 | ............ INDEX RANGE SCAN | ORDER_LINE_N1 | 11 | 3 |
|
129 | 1488 |
. |
. |
|
. |
. |
||||||
. |
17 | ........... INDEX UNIQUE SCAN | PART_PK | 1 |
. |
|
1488 | 1488 |
. |
. |
|
. |
. |
||||||
. |
18 | .......... TABLE ACCESS BY INDEX ROWID | PART | 1 | 1 |
|
1488 | 1488 |
. |
. |
|
. |
. |
||||||
. |
19 | ..... INDEX UNIQUE SCAN | CUSTOMER_PK | 1 |
. |
|
129 | 129 |
. |
. |
|
. |
. |