Oracle Database - Buffer Pool

1 - About

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

3 - 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

4 - Documentation / Reference

db/oracle/buffer_pool.txt ยท Last modified: 2017/09/06 19:30 by gerardnico