Oracle Database - (Db Block Get|Current Get) Buffer Mode (CU)
1 - About
db block get is a buffer retrieval mode.
It's also know as current mode get.
In this mode, the block is retrieved in the buffer cache.
The block is then known as a CURRENT block.
You will see these most frequently during modification statement, which must update only the latest copy of the block.
2 - Articles Related
3 - Example
For example, if an uncommitted transaction has updated two rows in a block, then a current mode get retrieves the block with these uncommitted rows.
4 - Statistics
In a statistics form, the statistic “db_block_gets” gives the Number of times a CURRENT block was requested
5 - Reference
- Oracle® Database Reference 11g Release 2 (11.2) - Statistics Description V$SESSTAT and V$SYSSTAT