understanding statspack report
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 99.93
Buffer Hit %: 12.77 In-memory Sort %: 100.00
Library Hit %: 81.20 Soft Parse %: 90.69
Execute to Parse %: 20.14 Latch Hit %: 99.98
Parse CPU to Parse Elapsd %: 65.97% Non-Parse CPU: 98.59
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 91.91 92.40
% SQL with executions>1: 67.98 71.23
% Memory for SQL w/exec>1: 70.17 73.94
Top 5 Timed Events Avg % Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
db file scattered read 188,614 171 1 57.8
CPU time 67 22.7
db file sequential read 9,144 55 6 18.5
log file sequential read 23 1 34 .3
control file sequential read 1,022 1 1 .3
Statistic Time (s) % of DB time
----------------------------------- -------------------- ------------
sql execute elapsed time 275.4 99.6
DB CPU 67.8 24.5
PL/SQL execution elapsed time 47.2 17.1