SQL Monitoring Report


SQL Text

SELECT /*+ gather_plan_statistics monitor bind_aware */ s1.channel_id, SUM(p.prod_list_price) price FROM products p, sales s1, sales s2 WHERE s1.cust_id = :b1 AND s1.prod_id = p.prod_id AND s1.time_id = s2.time_id GROUP BY s1.channel_id

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

.

229

.

.

4s
Session : SH (24:12753)
SQL ID : 434kpwwbqamfd
SQL Execution ID : 16777219
Execution Started : 02/04/2013 09:41:19
First Refresh Time : 02/04/2013 09:41:19
Last Refresh Time : 02/04/2013 09:41:24
Duration : 5s
Module/Action : SQL*Plus/-
Service : SYS$USERS
Program : sqlplus@host01.example.com (TNS V1-V3)
Fetch Calls : 2

Binds
Name Position Type Value
:B1 1 NUMBER 10


SQL Plan Monitoring Details (Plan Hash Value=491627931)
Id Operation Name Estimated
Rows
Cost Active Period
(5s)
Execs Rows Memory
(Max)
Temp
(Max)
IO Requests CPU Activity Wait Activity

.

0 SELECT STATEMENT

.

.

.

.

.

1 2

.

.

.

.

.

1 . HASH GROUP BY

.

4 118

.

.

1 2 503.0KB

.

.

.

.

2 .. HASH JOIN

.

130 117

.

.

1 165 1.1MB

.

.

.

.

3 ... JOIN FILTER CREATE :BF0000 130 58

.

.

.

1 165

.

.

.

.

.

4 .... HASH JOIN

.

130 58

.

.

.

1 165 1.2MB

.

.

.

.

5 ..... TABLE ACCESS FULL PRODUCTS 72 3

.

.

.

1 72

.

.

.

.

.

6 ..... PARTITION RANGE ALL

.

130 55

.

.

.

1 165

.

.

.

.

.

7 ...... TABLE ACCESS BY LOCAL INDEX ROWID SALES 130 55

.

.

.

28 165

.

.

.

.

.

8 ....... BITMAP CONVERSION TO ROWIDS

.

.

.

.

.

.

16 165

.

.

.

.

.

9 ........ BITMAP INDEX SINGLE VALUE SALES_CUST_BIX

.

.

.

.

.

16 4

.

.

.

.

.

10 ... VIEW VW_GBF_9 1460 58

.

.

1 28

.

.

.

.

.

11 .... HASH GROUP BY

.

1460 58

.

.

1 28 1.2MB

.

.

.

.

12 ..... JOIN FILTER USE :BF0000 919K 58

.

.

1 16548

.

.

.

50%

.

13 ...... PARTITION RANGE ALL

.

919K 58

.

.

1 919K

.

.

.

50%

.

14 ....... BITMAP CONVERSION TO ROWIDS

.

919K 58

.

.

28 919K

.

.

.

.

.

15 ........ BITMAP INDEX FULL SCAN SALES_TIME_BIX

.

.

.

.

28 1460

.

.

.

.