Brave new stats in 11.1.0.7
There are some very strange new statistics in 11.1.0.7, namely the "fastpath" mechanism for consistent gets. There are 2 types
of fastpath consistent gets, one for the db blocks, one apart from that one, probably for the index blocks. That would be consistent
with Jonathan's and Alex Fatkulin's blogs which have recently blogged about "consistent gets from cache (fastpath)" statistics.
Now, consistent gets are at the basis of how Oracle RDBMS functions: when returning data from a query, Oracle rebuilds the blocks
from the UNDO segments so that they are consistent with last transaction committed before the query had started. That process of
of fastpath consistent gets, one for the db blocks, one apart from that one, probably for the index blocks. That would be consistent
with Jonathan's and Alex Fatkulin's blogs which have recently blogged about "consistent gets from cache (fastpath)" statistics.
Now, consistent gets are at the basis of how Oracle RDBMS functions: when returning data from a query, Oracle rebuilds the blocks
from the UNDO segments so that they are consistent with last transaction committed before the query had started. That process of
0