WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB Name DB Id Instance Inst num Startup Time Release RAC

JDE900 4252748376 jde900 1 04-Aug-13 23:08 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
JDE900	4252748376	jde900	1	04-Aug-13 23:08	11.2.0.3.0	NO

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 8251 05-Aug-13 00:00:27 94 20.1

End Snap: 8287 06-Aug-13 12:00:05 196 30.1

Elapsed: 2,159.63 (mins)

DB Time: 4,485.16 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	8251	05-Aug-13 00:00:27	94	20.1
End Snap:	8287	06-Aug-13 12:00:05	196	30.1
Elapsed:		2,159.63 (mins)
DB Time:		4,485.16 (mins)

SQL Summary

SQL Id	Elapsed Time (ms)	Module	Action	SQL Text
ccvq8pqppq5ag	105,368,999	runbatch@JDEDB (TNS V1-V3)		UPDATE PRODDTA.F0911 SET GLPOST=:BND1, GLALT4=:BND2, GLUSER=:BND3, GLP...

SQL ID: ccvq8pqppq5ag

1st Capture and Last Capture Snap IDs refer to Snapshot IDs witin the snapshot range
UPDATE PRODDTA.F0911 SET GLPOST=:BND1,GLALT4=:BND2,GLUSER=:BND3,GLPID...

#	Plan Hash Value	Total Elapsed Time(ms)	Executions	1st Capture Snap ID	Last Capture Snap ID
1	3801329154	105,368,999	0	8258	8287

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	% Snap Total
Elapsed Time (ms)	105,368,999	39.15
CPU Time (ms)	103,479,597	56.72
Executions	0
Buffer Gets	31,977,561,632	45.24
Disk Reads	2,947,474	0.89
Parse Calls	1	0.00
Rows	0
User I/O Wait Time (ms)	1,953,055
Cluster Wait Time (ms)	0
Application Wait Time (ms)	0
Concurrency Wait Time (ms)	0
Invalidations	0
Version Count	30
Sharable Mem(KB)	2,135

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

Execution Plan

Id	Operation	Name	Rows	Bytes	Cost (%CPU)	Time
0	UPDATE STATEMENT				7 (100)
1	UPDATE	F0911
2	INDEX RANGE SCAN	F0911_30	12	3672	4 (0)	00:00:01

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

Full SQL Text

SQL Id SQL Text

ccvq8pqppq5ag UPDATE PRODDTA.F0911 SET GLPOST=:BND1, GLALT4=:BND2, GLUSER=:BND3, GLPID=:BND4, GLJOBN=:BND5, GLUPMJ=:BND6, GLUPMT=:BND7 WHERE ( GLPOST = :KEY1 AND GLICUT = :KEY2 AND GLICU = :KEY3 )