Strategies

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” on page 45 and “Controlling large I/O and cache strategies” on page 47 in the book Performance and Tuning: Optimizer for information on specifying the cache strategy in queries or setting values for tables.