发现我们都错了,物理读的次数肯定是包含在逻辑读里面的。
文档内容:
consistent gets from cache:Number of times a consistent read was requested for a block from the buffer cache.
db block gets from cache:Number of times a CURRENT block was requested from the buffer cache.
physical reads cache Total number of data blocks read from disk into buffer cache.
有哪种情况,出现物理读而没有逻辑读的,就是说数据读到buffer cache中以后就啥事情都不做了,这种情况有没有?
如果有的话,就有可能出现物理读大于逻辑读。