What is consistent gets and db block gets?

An excerpt from What are Consistent Gets?
Consistent Gets – a normal reading of a block from the buffer cache. A check will be made if the data needs reconstructing from rollback info to give you a consistent view but most of the time it won’t.

DB Block Gets – Internal processing. Don’t worry about them unless you are interested in Oracle Internals and have a lot of time to spend on it.

Physical Reads – Where Oracle has to get a block from the IO subsystem

Quick Tips
Consistent Gets – 2

Comments are closed.