There is some overhead associated with using this advisory view. The benefit from increasing buffers decreases as the number of buffers increases. The benefit from increasing buffers from point A to point B is considerably higher than from point B to point C. The decrease in the physical I/O between points A and B and points B and C is not smooth, as indicated by the dotted line in the graph. Figure 13-1 Physical I/O Ratio and Buffer Cache Sizeĭescription of 'Figure 13-1 Physical I/O Ratio and Buffer Cache Size'Įxamining the example illustrated in the above figure leads to the following observations:Īs the number of buffers increases, the physical I/O ratio decreases.
