Oracle Database - Buffer cache

1 - About

For many types of operations, Oracle Database uses the buffer cache to store data blocks read from disk. Oracle Database bypasses the buffer cache for particular operations, such as sorting and parallel reads.

Buffer Cache is an other name for logical oracle RAM buffer and is a part of the in System Global Area (SGA).

The “buffer cache”:

  • caches the physical blocks read (hold a copies of the data blocks of the data files)
  • is shared by all concurrent process

3 - Management

3.1 - Flush


alter system flush buffer_cache

Many people think that they must flush the buffer cache before tuning, to emulate the real world.

If you tune with logical_io (consistent_gets) in mind, the physical_io will take care of themselves over time (assuming you ensure an even distribution of I/O across disks).

Flushing the buffer cache gets rid of tons of information that rightly would be there in a production environment when you run the query.

4 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap