SQL Monitoring Report


SQL Text

SELECT /*+ MONITOR */ d.dname, WM_CONCAT(e.ename) AS employees FROM emp e JOIN dept d ON e.deptno = d.deptno GROUP BY d.dname ORDER BY d.dname

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

.
41

.

.

.

.
0s
Session : SCOTT (53:1261)
SQL ID : 526mvccm5nfy4
SQL Execution ID : 16777217
Execution Started : 03/19/2011 12:55:13
First Refresh Time : 03/19/2011 12:55:13
Last Refresh Time : 03/19/2011 12:55:13
Duration : .014344s
Module/Action : SQL*Plus/-
Service : SYS$USERS
Program : sqlplus@oel5-11gR2-demo.localdomain (TNS V1-V3)
Fetch Calls : 4


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

.

 0 SELECT STATEMENT

.

.

.

.
1 3

.

.

.

.

.

 1 . SORT GROUP BY

.

 4 7

.
1 3 2.0KB

.

.

.

.

 2 .. MERGE JOIN

.

 14 6

.
1 14

.

.

.

.

.

 3 ... TABLE ACCESS BY INDEX ROWID DEPT 4 2

.
1 4

.

.

.

.

.

 4 .... INDEX FULL SCAN PK_DEPT 4 1

.
1 4

.

.

.

.

.

 5 ... SORT JOIN

.

 14 4

.
4 14 2.0KB

.

.

.

.

 6 .... TABLE ACCESS FULL EMP 14 3

.
1 14

.

.

.

.