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: 5486 12-Jan-07 14:00:01 28 14.6
End Snap: 5489 12-Jan-07 15:00:03 22 11.1
Elapsed:   60.04 (mins)    
DB Time:   37.71 (mins)    

SQL Summary

SQL Id Elapsed Time (ms) Module Action SQL Text
9a5wbppva8npu 543,807 SQL*Plus   SELECT ENAME FROM EMP WHERE EMPNO = :num...


Back to Top

SQL ID: 9a5wbppva8npu

# Plan Hash Value Total Elapsed Time(ms) Executions 1st Capture Snap ID Last Capture Snap ID
1 3956160932 543,807 1,000 5489 5489


Back to Top

Plan 1(PHV: 3956160932)

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) 543,807 543.81 24.03
CPU Time (ms) 541,049 541.05 34.48
Executions 1,000    
Buffer Gets 12,657,030 12,657.03 24.77
Disk Reads 12,587,733 12,587.73 52.23
Parse Calls 1,000 1.00 2.07
Rows 1,000 1.00  
User I/O Wait Time (ms) 193,697    
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: 3956160932)
Back to Top

Execution Plan

Id Operation Name Rows Bytes Cost (%CPU) Time
0 SELECT STATEMENT       3443 (100)  
1    TABLE ACCESS FULL EMP 1 12 3443 (1) 00:00:42

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

 

Full SQL Text

SQL Id SQL Text
9a5wbppva8npu SELECT ENAME FROM EMP WHERE EMPNO = :num


Back to Top