Performance issue - latch free on TOP
The Top 5 of the stastpack show the latch free event on top, can anyone help finding out the cause of this issue?
Here I paste some information regarding the latch free. (only part of the stastpack is pasted, the part that I think is useful for now).
The wait seems to be related to library cache, since this is the one with higher wait time in the stastpack.
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
latch free 2,214 7,871 71.84
CPU time 2,401 21.92
PX Deq: Execute Reply 14,807 298 2.72
rdbms ipc reply 156 163 1.49
enqueue 1,328 81 .74
Avg
Total Wait wait Waits