WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

 

DB Name DB Id Instance Inst num Release RAC Host
O102EE1 2384218455 o102ee1 1 10.2.0.3.0 NO hpap0601

 

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 7478 02-Apr-07 20:01:05 24 11.5
End Snap: 7479 02-Apr-07 20:09:17 24 11.8
Elapsed:   8.21 (mins)    
DB Time:   31.18 (mins)    

SQL Summary

SQL Id Elapsed Time (ms) Module Action SQL Text
b7twbdp012nbw 74 SQL*Plus   select emp1no, ename from emp1 where emp1no = 15996 ...


Back to Top

SQL ID: b7twbdp012nbw

# Plan Hash Value Total Elapsed Time(ms) Executions 1st Capture Snap ID Last Capture Snap ID
1 2226897347 74 1 7479 7479


Back to Top

Plan 1(PHV: 2226897347)

Back to Top

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) 74 74.23 0.00
CPU Time (ms) 74 74.23 0.00
Executions 1    
Buffer Gets 3,243 3,243.00 0.01
Disk Reads 1,245 1,245.00 0.04
Parse Calls 1 1.00 0.00
Rows 1 1.00  
User I/O Wait Time (ms) 19    
Cluster Wait Time (ms) 0    
Application Wait Time (ms) 0    
Concurrency Wait Time (ms) 0    
Invalidations 0    
Version Count 1    
Sharable Mem(KB) 8    

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

Execution Plan

Id Operation Name Rows Bytes Cost (%CPU) Time
0 SELECT STATEMENT       905 (100)  
1    TABLE ACCESS FULL EMP1 1 12 905 (2) 00:00:11

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

 

Full SQL Text

 

SQL Id SQL Text
b7twbdp012nbw select emp1no, ename from emp1 where emp1no = 15996


Back to Top