Analyzing statspack report
Hi ,
I got the following report from starts pack . Is there anything to be changed in the parameters to improve it.
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 29,546.78 542.54
Logical reads: 2,650.11 48.66
Block changes: 232.15 4.26
Physical reads: 0.00 0.00
Physical writes: 0.68 0.01
User calls: 2,124.94 39.02
Parses: 600.86 11.03
Hard parses: 0.00 0.00
Sorts: 0.55 0.01
Logons: 0.04 0.00
Executes: 1,146.58 21.05
Transactions: 54.46
% Blocks changed per Read: 8.76 Recursive Call %: 55.26
Rollback per transaction %: 0.00 Rows per Sort: 33.08
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.99 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.99 Soft Parse %: 100.00
Execute to Parse %: 47.60 Latch Hit %: 97.97
Parse CPU to Parse Elapsd %: 42.98 % Non-Parse CPU: 97.21
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 20.89 21.08
% SQL with executions>1: 75.41 75.44
% Memory for SQL w/exec>1: 62.58 62.59
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 3,319 78.93
latch free 31,758 508 12.08
log file sync 30,153 369 8.77
control file parallel write 202 3 .08
buffer busy waits 192 2 .04
-------------------------------------------------------------
