Replacement strategies determine where the page is placed in cache when it is read from disk. The optimizer decides on the cache replacement strategy to be used for each query. The two strategies are:

Cache replacement strategies can affect the cache hit ratio for your query mix:

See “Specifying the cache strategy” and “Controlling large I/O and cache strategies” for information on specifying the cache strategy in queries or setting values for tables.