What are the components of DB BUFFER CACHE?
Below mentioned are the components of db buffer cache,
- Default pool (where blocks are normally buffered)
- Big table cache (optional part of the default pool; uses a temperature based algorithm instead of the LRU based one)
- Keep pool - data buffers for frequently running queries
- Recycle pool - data buffers for least running queries
- Non-default buffer pools (used for non-standard block sizes of 2, 4, 16 or 32 KB, when you have different tablespaces with different db block sizing)
- Database Smart Flash Cache (used in flash cache)
- Least Recently Used list (LRU)
- Checkpoint queue
- Flash Buffer Area
No comments:
Post a Comment