SQL Monitoring Report


SQL Text

select /*+ PARALLEL(T1 3) */ count(*) from t1

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

.
41604

.
35355 IO

.

.
280s
Session ID : 170
SQL ID : 255xfn4xrq51a
SQL Execution ID : 16777218
Plan Hash Value : 3110199320
Execution Started : 04/07/2009 17:59:19
First Refresh Time : 04/07/2009 17:59:19
Last Refresh Time : 04/07/2009 18:00:26
Fetch Calls :


Parallel Execution Details (DOP=3)

PX Processes Drill-Down
Name Type Server# Buffer Gets IO Count Database Time Wait Events
PX Coordinator QC
4 (<0.1%)
0s (<0.1%)
p000 Set 1 1

.
13588 (32%)

.
11653 IO (32%)

.

.
93s (33%)
p001 Set 1 2

.
13889 (33%)

.
11466 IO (32%)

.

.
93s (33%)
p002 Set 1 3

.
14123 (33%)

.
12236 IO (34%)

.

.
94s (33%)


SQL Plan Monitoring Details:
Id Operation Name Estimated
Rows 		Cost Active Period
(68s) 		Starts Actual
Rows 		Memory Temp CPU Activity Wait Activity

.

 0 SELECT STATEMENT

.

.

 5394

.

 1

.

.

.

.

.

.

 1 . SORT AGGREGATE

.

 1

.

.

 1

.

.

.

.

.

.

 2 .. PX COORDINATOR

.

.

.

.

 4

.

.

.

.

.

.

 3 ... PX SEND QC (RANDOM) :TQ10000 1

.

.

 3

.

.

.

.

.
> 4 .... SORT AGGREGATE

.

 1

.

.

.
3 0

.

.

.

.
> 5 ..... PX BLOCK ITERATOR

.

 8375K 5394

.

.
3 6053K

.

.

.

.
> 6 ...... TABLE ACCESS FULL T1 8375K 5394

.

.
28 6053K

.

.

.

.