WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO3 3 30-Jun-09 12:06 11.1.0.7.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DEMO	3430975138	DEMO3	3	30-Jun-09 12:06	11.1.0.7.0	YES

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1047 02-Jul-09 13:12:32 43 1.3

End Snap: 1048 02-Jul-09 13:13:45 43 1.4

Elapsed: 1.21 (mins)

DB Time: 2.24 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1047	02-Jul-09 13:12:32	43	1.3
End Snap:	1048	02-Jul-09 13:13:45	43	1.4
Elapsed:		1.21 (mins)
DB Time:		2.24 (mins)

SQL Summary

SQL Id	Elapsed Time (ms)	Module	Action	SQL Text
8dkv0z9wm9881	124,432	SQL*Plus		select /* eight / /+ parallel (t1, 16) parallel (t2, 16) */...

SQL ID: 8dkv0z9wm9881

1st Capture and Last Capture Snap IDs refer to Snapshot IDs witin the snapshot range
select /* eight */ /*+ parallel (t1, 16) parallel (t2, 16) */ ...

#	Plan Hash Value	Total Elapsed Time(ms)	Executions	1st Capture Snap ID	Last Capture Snap ID
1	1755470101	124,432	1	1048	1048

Plan Statistics

% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Stat Name	Statement Total	Per Execution	% Snap Total
Elapsed Time (ms)	124,432	124,431.53	92.76
CPU Time (ms)	104,710	104,710.08	97.77
Executions	1
Buffer Gets	965,226	965,226.00	98.35
Disk Reads	1,024,324	1,024,324.00	100.00
Parse Calls	3	3.00	0.63
Rows	1	1.00
User I/O Wait Time (ms)	19,180
Cluster Wait Time (ms)	28
Application Wait Time (ms)	5
Concurrency Wait Time (ms)	0
Invalidations	0
Version Count	1
Sharable Mem(KB)	30

Back to Plan 1(PHV: 1755470101)
Back to Top

Execution Plan

Id	Operation	Name	Rows	Bytes	TempSpc	Cost (%CPU)	Time	Pstart	Pstop	TQ	IN-OUT	PQ Distrib
0	SELECT STATEMENT					302K(100)
1	SORT AGGREGATE		1	88
2	PX COORDINATOR
3	PX SEND QC (RANDOM)	:TQ10000	1	88						Q1,00	P->S	QC (RAND)
4	SORT AGGREGATE		1	88						Q1,00	PCWP
5	PX PARTITION HASH ALL		470M	38G		302K (1)	01:00:29	1	64	Q1,00	PCWC
6	HASH JOIN		470M	38G	1395M	302K (1)	01:00:29			Q1,00	PCWP
7	PX PARTITION RANGE ALL		468M	16G		73512 (1)	00:14:43	1	31	Q1,00	PCWC
8	TABLE ACCESS STORAGE FULL	DWB_RTL_TRX	468M	16G		73512 (1)	00:14:43	1	1984	Q1,00	PCWP
9	PX PARTITION RANGE ALL		468M	21G		73481 (1)	00:14:42	1	31	Q1,00	PCWC
10	TABLE ACCESS STORAGE FULL	DWB_RTL_TRX	468M	21G		73481 (1)	00:14:42	1	1984	Q1,00	PCWP

Back to Plan 1(PHV: 1755470101)
Back to Top

Full SQL Text

SQL Id SQL Text

8dkv0z9wm9881 select /* eight */ /*+ parallel (t1, 16) parallel (t2, 16) */ min (t1.bsns_unit_key + t2.bsns_unit_key), max (t1.day_key + t2.day_key), avg (t1.day_key + t2.day_key), max (t1.bsns_unit_typ_cd), max (t2.curr_ind), max (t1.load_dt) from d31.dwb_rtl_trx t1, d31.dwb_rtl_trx t2 where t1.trx_nbr = t2.trx_nbr