Please provide recommendations to tune the DB .
From the statspack report:
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
log file sync 370,269 3,934 11 64.8
log file parallel write 317,906 1,110 5 25.4
CPU time 168 3.5
direct path read 5,340 102 24 2.3
db file sequential read 80,134 80 1 1.8
Foreground Wait Events :
Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
log file sync 370,299 0 3,834 11 1.1 64.8
direct path read 5,340 0 101 24 0.0 2.3
direct path write 3,212 0 20 6 0.0 .5
Background Wait Events :
Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
log file parallel write 317,906 0 1,110 5 0.8 25.4
db file sequential read 80134 0 69 1 0.3 1.6
db file parallel write 1,376 0 19 14 0.0 .4
log file sequential read 300 0 11 37 0.0 .2
Thank you!!