Hello everyone,

Question about the LRU list in the database buffer cache in the SGA:

Does the LRU (Least Recently Used) list has a size (in terms of blocks or whatever)? Or is there a parameter where you actually specify the size of the LRU list? The book I'm reading says "... Consider the LRU list as a queue of blocks, in which the most recently accessed blocks are always in the front (MRU). The least-used blocks are thrown out of the list when new blocks are accessed and added to the list...." Having that in mind, how does Oracle know when it has to throw out a block from the LRU list? How does oracle know when the list is full?

Any ideas would be greatly appreciated.

Cheers!