Table of Contents
Oracle Database - consistent gets statistic
About
logical_io statistic which give the number of times, a consistent read was requested for a block in the buffer_cache to get data from a data block.
Number of times, a consistent read was requested for a block in the buffer cache. Consistent reads may require read asides to the undo (rollback) information, and these reads to the undo will be counted here as well.
Consistent gets are the retrieval of blocks from the buffer_cache in “read consistent” mode and may include read asides to UNDO (rollback segments).
A query will generally perform “consistent gets” and no current get, then the term logical I/O refer often to it.
