Statspack - ajuda para analisar...

Olá pessoal! Pode me ajudar a melhorar a performance do banco analisando este pedaço do statspack??? O que tem de maiores problemas aqui?



Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 4,891.78
[b:f9cfe9fdea] [color=red:f9cfe9fdea] Logical reads: 2,770.66[/color:f9cfe9fdea][/b:f9cfe9fdea]
Block changes: 32.71
Physical reads: 84.38
Physical writes: 6.02
User calls: 37.46
Parses: 14.13
Hard parses: 4.06
Sorts: 3.47
Logons: 1.00
Executes: 15.75
Transactions:

¬ Blocks changed per Read: 1.18 Recursive Call ¬: 59.04
Rollback per transaction ¬: 0.02 Rows per Sort: #

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ ¬ Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
[b:f9cfe9fdea][color=red:f9cfe9fdea]latch free 3,655,345 1,599,041 85.64[/color:f9cfe9fdea][/b:f9cfe9fdea]
library cache lock 43,459 97,637 5.23
buffer busy waits 2,247,597 87,895 4.71
CPU time 34,459 1.85
db file scattered read 3,067,210 14,308 .77
-------------------------------------------------------------


Instance Efficiency Percentages (Target 100¬)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait ¬: 99.72 Redo NoWait ¬: 100.00
Buffer Hit ¬: 97.14 In-memory Sort ¬: 99.92
Library Hit ¬: 90.62 Soft Parse ¬: 71.25
[b:f9cfe9fdea] [color=red:f9cfe9fdea] Execute to Parse ¬: 10.25 Latch Hit ¬: 99.74[/color:f9cfe9fdea][/b:f9cfe9fdea]
Parse CPU to Parse Elapsd ¬: 0.22 ¬ Non-Parse CPU: 94.84

Shared Pool Statistics Begin End
------ ------
Memory Usage ¬: 7.52 84.02
¬ SQL with executions>1: 46.03 3.94
¬ Memory for SQL w/exec>1: 28.98 7.47



Agradeço qualquer ajuda!