Oracle Database - Buffer Pool

Card Puncher Data Processing

About

The buffer pool is a category assigned to a segment to manage the lifetime of a segment in the buffer cache.

Type

Three separate buffer pools:

  • KEEP pool (to maintain frequently accessed segments in the buffer cache)
  • RECYCLE pool (to prevent objects from consuming unnecessary space in the buffer cache)
  • DEFAULT buffer pool (Default)
Pool Segment access Example
keep frequent (hot)
recycle infrequently a large segment that is accessed by a batch job only once a day
default Not known

Documentation / Reference





Discover More
Oracle Segment Extent Data Block
Oracle Segment - Metadata (View, )

DBA_SEGMENTS describes the storage allocated for all segments in the database. A segment name may have several rows. There is a buffer pool column.



Share this page:
Follow us:
Task Runner