About
The buffer pool is a category assigned to a segment to manage the lifetime of a segment in the buffer cache.
Articles Related
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 |