WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB Name DB Id Instance Inst num Startup Time Release RAC

DEMO 3430975138 DEMO1 1 30-Jun-09 12:06 11.1.0.7.0 YES

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1041 02-Jul-09 12:43:26 46 1.7

End Snap: 1042 02-Jul-09 12:46:16 46 1.8

Elapsed: 2.84 (mins)

DB Time: 43.29 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1041	02-Jul-09 12:43:26	46	1.7
End Snap:	1042	02-Jul-09 12:46:16	46	1.8
Elapsed:		2.84 (mins)
DB Time:		43.29 (mins)

SQL Summary

SQL Id	Elapsed Time (ms)	Module	Action	SQL Text
arty65g64fmt7	2,505,237	SQL*Plus		select /* one / /+ parallel (t1, 16) parallel (t2, 16) */ ...

SQL ID: arty65g64fmt7

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

#	Plan Hash Value	Total Elapsed Time(ms)	Executions	1st Capture Snap ID	Last Capture Snap ID
1	1755470101	2,505,237	1	1042	1042

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)	2,505,237	2,505,236.74	96.46
CPU Time (ms)	1,022,023	1,022,022.63	97.78
Executions	1
Buffer Gets	7,533,664	7,533,664.00	98.31
Disk Reads	11,730,906	11,730,906.00	99.29
Parse Calls	17	17.00	1.37
Rows	1	1.00
User I/O Wait Time (ms)	1,179,164
Cluster Wait Time (ms)	0
Application Wait Time (ms)	116
Concurrency Wait Time (ms)	1,475
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

arty65g64fmt7 select /* one */ /*+ 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