Friday, March 15, 2013

Buffer cache management tip:

New buffer gets are assigned to the head of the LRU (MRU).
But Blocks coming from Full Table Scans are placed to the end of the LRU, and there is a limit for them = db_block_multi_read_count
This method prevents hot blocks to be flushed out from the buffer cache.
This can be thought as default behaviour and can be altered using CACHE clause on table creation or altering. Using Cache clause, blocks coming from an FTS can be placed at the MRU.

Click for details.. 

No comments :

Post a Comment

If you will ask a question, please don't comment here..

For your questions, please create an issue into my forum.

Forum Link:

Register and create an issue in the related category.
I will support you from there.