Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: latch contention
Latch contention in the buffer cache is most often reported on the cache buffers chains latch which should decrease or stay the same as one increases the buffer cache.
On the other hand there are quite a few stories of systems with library cache contention getting stuffed by increasing the shared pool. One reason is that the list of memory chunks becomes larger if the shared pool is larger and there is fragmentation, especially in cases where there are no bind variables. If there is already contention like this and then the shared pool is increase the latch contention becomes worse on the shared pool latch.
Comments and additions appreciated
Best Wishes
Kyle Hailey
http://oraperf.sourceforge.net