SQL Monitoring Report


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

Global Information: DONE (ALL ROWS)
Instance ID : 1
Buffer Gets IO Requests Database Time Wait Activity

.

6570

.

34

.

.

1s
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

Binds
Name Position Type Value
:B1 1 VARCHAR2(32) 5


SQL Plan Monitoring Details (Plan Hash Value=3935795003)
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

.

.

100%

.

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

.

.

.

34

.

.

.

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

.

.

.

.