Re: Regarding the number of consistent gets.

Hi,

Number of consistent gets would be same as db_cache_size/db_block_size, only if you read all the blocks only once. But generally during the lifetime of the instance sessions read each block many times.

i.e. Session A doing a consistent get on block 1:23 ( 1 consistent get)

      Session B doing a consistent get on block 1:23 ( 1 consistent get)

So number of consistent get can be more that db_cache_size/db_block_size even if the physical reads is 0

amit Received on Mon Sep 19 2005 - 11:51:20 CDT