Title: RE: Freeable memory
Hi Mike,
I did a test on one of our 7.3 databases. It seems that some (but not all) freeable chunks get coalesced by flushing the shared pool. I tested it on a database with no other users logged in and took before/after pictures of the chunk breakdown.
SQL
Hi Michael:
Why don't you use this Steve Adams' script to check the fragmentation
of your shared pool, it may be badly
fragmented and this problem could generate a lot of pressure at the shared
pool latch.
And this situation can also generate contention at a lower level latch (like
the libra