Re: difference between cache buffer lru chain and cache buffers chains

On Thu, 23 Mar 2006 08:40:22 -0800, Chintu wrote:

> What is the difference between cache buffer lru chain and cache buffers
> chains ?? Are these two different chains with different set of buffered
> blocks or two chains maintain buffer block information in two different
> ways?

Cache buffer LRU chain no longer exists as of version 8i. Buffers maintain something called "touch count" which is increased each time buffer is accessed. Using touch count instead of LRU chain avoids use of latches and increases concurrency. These terms are supposed to be synonymous, but it seems that you've got hold of some really old DBA book.

-- 
http://www.mgogala.com