What indicates that the rate of writing data blocks to the disk is very slow?
A.
very high cache-hit ratio
B.
increasing number of free buffer waits
C.
increasing number of buffer busy waits
D.
waits on latch: cache buffers chains event
What indicates that the rate of writing data blocks to the disk is very slow?
What indicates that the rate of writing data blocks to the disk is very slow?
A.
very high cache-hit ratio
B.
increasing number of free buffer waits
C.
increasing number of buffer busy waits
D.
waits on latch: cache buffers chains event
B is right. free buffer waits. DB writer too slow to free up the blocks