WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
xxxxx***********xxxx121-Jun-20 10:0612.1.0.2.0NO

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3761801-Apr-21 10:00:21204 3.9
End Snap:3762001-Apr-21 12:00:16213 3.7
Elapsed:  119.92 (mins)  
DB Time:  5,173.22 (mins)  

SQL Summary

SQL IdElapsed Time (ms)ModuleActionSQL Text
72qu725jn51rc297,188,756 Module: JDBC Thin Client   select this_.SUBMISSION_ID as SUBMISSION_ID1_10_1_, this_.ASSIGNMENT_I...


Back to Top

SQL ID: 72qu725jn51rc

#Plan Hash ValueTotal Elapsed Time(ms)Executions1st Capture Snap IDLast Capture Snap ID
13134048982297,188,75614,3213761937620


Back to Top

Plan 1(PHV: 3134048982)

Back to Top

Plan Statistics

Stat NameStatement TotalPer Execution% Snap Total
Elapsed Time (ms)297,188,75620,751.9695.75
CPU Time (ms)31,970,9582,232.4583.43
Executions14,321  
Buffer Gets198,200,34613,839.845.20
Disk Reads00.000.00
Parse Calls14,3211.000.06
Rows00.00 
User I/O Wait Time (ms)0  
Cluster Wait Time (ms)0  
Application Wait Time (ms)0  
Concurrency Wait Time (ms)79,645  
Invalidations0  
Version Count6  
Sharable Mem(KB)268  

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

Execution Plan

Id Operation Name Rows Bytes Cost (%CPU) Time
0 SELECT STATEMENT     20791 (100) 
1    NESTED LOOPS OUTER   1 646 20791 (1) 00:00:01
2      TABLE ACCESS FULL ASN_SUBMISSION 1 564 20788 (1) 00:00:01
3      TABLE ACCESS BY INDEX ROWID BATCHED ASN_SUBMISSION_SUBMITTER 1 82 3 (0) 00:00:01
4        INDEX RANGE SCAN UK_ASN_SUBMISSION 1   2 (0) 00:00:01

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

Full SQL Text

SQL IdSQL Text
72qu725jn51rc select this_.SUBMISSION_ID as SUBMISSION_ID1_10_1_, this_.ASSIGNMENT_ID as ASSIGNMENT_ID21_10_1_, this_.CREATED_DATE as CREATED_DATE2_10_1_, this_.MODIFIED_DATE as MODIFIED_DATE3_10_1_, this_.RETURNED_DATE as RETURNED_DATE4_10_1_, this_.SUBMITTED_DATE as SUBMITTED_DATE5_10_1_, this_.FACTOR as FACTOR6_10_1_, this_.FEEDBACK_COMMENT as FEEDBACK_COMMENT7_10_1_, this_.FEEDBACK_TEXT as FEEDBACK_TEXT8_10_1_, this_.GRADE as GRADE9_10_1_, this_.GRADE_RELEASED as GRADE_RELEASED10_10_1_, this_.GRADED as GRADED11_10_1_, this_.GRADED_BY as GRADED_BY12_10_1_, this_.GROUP_ID as GROUP_ID13_10_1_, this_.HIDDEN_DUE_DATE as HIDDEN_DUE_DATE14_10_1_, this_.HONOR_PLEDGE as HONOR_PLEDGE15_10_1_, this_.PRIVATE_NOTES as PRIVATE_NOTES16_10_1_, this_.RETURNED as RETURNED17_10_1_, this_.SUBMITTED as SUBMITTED18_10_1_, this_.TEXT as TEXT19_10_1_, this_.USER_SUBMISSION as USER_SUBMISSION20_10_1_, submitters2_.SUBMISSION_ID as SUBMISSION_ID6_10_3_, submitters2_.ID as ID1_14_3_, submitters2_.ID as ID1_14_0_, submitters2_.FEEDBACK as FEEDBACK2_14_0_, submitters2_.GRADE as GRADE3_14_0_, submitters2_.SUBMISSION_ID as SUBMISSION_ID6_14_0_, submitters2_.SUBMITTEE as SUBMITTEE4_14_0_, submitters2_.SUBMITTER as SUBMITTER5_14_0_ from ASN_SUBMISSION this_ left outer join ASN_SUBMISSION_SUBMITTER submitters2_ on this_.SUBMISSION_ID=submitters2_.SUBMISSION_ID where this_.ASSIGNMENT_ID=:1 and this_.GROUP_ID=:2


Back to Top