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.

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

db/oracle/db_block_gets.txt · Last modified: 2017/09/06 19:27 by gerardnico