Oracle Database - (Db Block Get|Current Get) Buffer Mode (CU)

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.

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.

Statistics

In a statistics form, the statistic “db_block_gets” gives the Number of times a CURRENT block was requested

Reference


Powered by ComboStrap