SQL Monitoring Report


SQL Text

SELECT ...

Global Information: EXECUTING
Instance ID : 1
Buffer Gets IO Requests Database Time Wait Activity

.
393K

.

.
342K

.

.
521s

.
100%
Session : SOME_USER (411:46571)
SQL ID : 61q00bqj1zpwj
SQL Execution ID : 16777216
Execution Started : 09/20/2016 15:32:28
First Refresh Time : 09/20/2016 15:32:34
Last Refresh Time : 09/20/2016 15:41:04
Duration : 517s
Module/Action : SOME_MODULE/SOME_ACTION
Service : SOME_SERVICE
Program : SOME_PROGRAM


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

.

 0 SELECT STATEMENT

.

.

.

.

.

.
1 0

.

.
.28%

.

.

 1 . COUNT STOPKEY

.

.

.

.

 1

.

.

.

.

.

.

.

 2 .. HASH JOIN

.

 1 590K

.

 1

.

 211.0KB

.

.

.

.

.

 3 ... PART JOIN FILTER CREATE :BF0000 1 159K

.

 1

.

.

.

.

.

.
-> 4 .... HASH JOIN

.

 1 159K

.

.
1 0 848.0MB 36.5GB

.
336K (98%)

.
56%

.
98%

.
-> 5 ..... MERGE JOIN CARTESIAN

.

 1 159K

.

.
1 273M

.

.

.

.

.

.

 6 ...... HASH JOIN OUTER

.

 1 158K

.

.
1 7466 297.8MB

.
.28%

.

.

 7 ....... HASH JOIN

.

 1 158K

.

.

.
1 2M

.

.
.28%

.

.

 8 ........ PART JOIN FILTER CREATE :BF0001 2M 153K

.

.

.
1 2M

.

.
.28%

.

.

 9 ......... PARTITION LIST SINGLE

.

 2M 153K

.

.

.
1 2M

.

.

.

.

.

.

 10 .......... TABLE ACCESS FULL TABLE_A 2M 153K

.

.
1 2M

.

.

.
5882 (1.7%)

.
35%

.
1.3%
done

.

 11 ........ PARTITION LIST SINGLE

.

 238 4

.

.

.
1 1348

.

.

.

.

.

.

 12 ......... TABLE ACCESS FULL TABLE_B 238 4

.

.

.
1 1348

.

.
3 (<0.1%)

.

.

.

.

 13 ....... VIEW

.

 2000 200

.

.

.
1 2

.

.

.

.

.

.

 14 ........ COUNT

.

.

.

.

.

.
1 2

.

.

.

.

.

.

 15 ......... FILTER

.

.

.

.

.

.
1 2

.

.

.

.

.
-> 16 .......... REMOTE TABLE_C 2000 200

.

.
1 2

.

.

.

.

.

.

 17 ...... BUFFER SORT

.

 2000 159K

.

.
7466 273M 1.4MB

.

.
6.9%

.

.

 18 ....... REMOTE TABLE_D 2000 200

.

.

.
1 36525

.

.

.

.

.

.

 19 ..... REMOTE TABLE_E 1 200

.

.

.

.

.

.

.

.

.

 20 ... PARTITION LIST SINGLE

.

 90M 431K

.

.

.

.

.

.

.

.

.

 21 .... TABLE ACCESS FULL TABLE_F 90M 431K

.

.

.

.

.

.

.

.