STATSPACK results

[Guest_imported]

Hi

I've got statistic results as follow:

Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Event Waits
-------------------------------------------- ------------
SQL*Net more data to client 32,837
log file parallel write 10,077
log file sync 9,833
SQL*Net break/reset to client 5,752
direct path read 3,626
-------------------------------------------------

and (in another snapshot set):


Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Event Waits
-------------------------------------------- ------------
control file parallel write 484
control file sequential read 48
file open 45
direct path read 17
direct path write 14
-------------------------------------------------

looks like there is a bottleneck writing to
logs/control files.
Do you have any idea on how to correct this situation?

Thanks
Dmitri

 

[karluk]

One possibility for reducing the log file waits is to put your redo logs on a faster device. Specifically try not to put redo logs on RAID 5 devices.