Saturday 15 October 2022

Components of Oracle DB BUFFER CACHE

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