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

Card Puncher Data Processing

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





Discover More
Oracle Segment Extent Data Block
Oracle Database - (Data|Db|Logical|Oracle) Block or Page

Articles which talk : block management. ?? At the finest level of granularity in the logical structure of an Oracle Database, the data is stored in data blocks. The data block sizes should be a...
Sql Developer Autotrace
Oracle Database - Autotrace

Autotrace is: a system variable of sql plus can also be found in SQL Developer AUTOTRACE provides you: an execution plan (such as explain plan) and some important regarding its actual execution....
Card Puncher Data Processing
Oracle Database - Buffer IO (Logical IO)

A buffer is a container for data. A logical I/O, also known as a buffer I/O, refers to reads and writes of buffers in the buffer cache. When a requested buffer is not found in memory, the database performs...
Card Puncher Data Processing
Oracle Database - Consistent (Read get|Buffer Mode) (CR)

A consistent read get is a retrieval of a read-consistent version of a block from the buffer_cache and then may include read asides to UNDO (rollback segments). A query will generally perform “consistent...
Card Puncher Data Processing
Oracle Database - Session Statistics (V$SESSTAT)

The second part of the autotrace output are a part of the session statistics. V recursive_calls : Number of SQL...



Share this page:
Follow us:
Task Runner