Oracle Database - Buffer Pool


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


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

Powered by ComboStrap