Hello,

Can any body give any pointers on the statspack wait events. I am looking to improve the performance. I am using Oracle Parallel Server 8.1.7 on Linux.

Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Event Waits WaitTime (cs) % TotalWt Time
-------------------------------------------- ------------ ------------ -------
global cache lock s to x 65 8 72.73
enqueue 1,327 1 9.09
control file sequential read 37 1 9.09
refresh controlfile command 6 1 9.09
latch free 67,133 0 .00

Please let me know the pointers if any ..??

Regards, Raj