Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the total Buffer Cache size and how to find out the single cache sizes?

April 26, 2017buffer cache size total

0

Posted

What is the total Buffer Cache size and how to find out the single cache sizes?

1 Answer

0

Posted

Total Buffer Cache size = DB_CACHE_SIZE + DB_KEEP_CACHE_SIZE + DB_RECYCLE_CACHE_SIZE + DB_2K_CACHE_SIZE + DB_4K_CACHE_SIZE + DB_8K_CACHE_SIZE + DB_16K_CACHE_SIZE + DB_32K_CACHE_SIZE They can be read from SQL Plus via the “show parameter cache_size” command.