我在oracle文檔看到下面的一句話,(Because the shared pool acts as a cache, nothing will ever be aged out until all thefree memory has been used up. Free memory is more properly thought of aswasted space. A high value of free memory is a symptom of fragmentation.)
也就是說,通常我們看見shared pool 的free memory很大的話,那證明library cache的碎片就很多了。
那問題是怎麼樣減少shared pool的碎片呢?