Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–65535 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
The number of index trips parameter specifies the number of times an aged index page traverses the most recently used/least recently used (MRU/LRU) chain before it is considered for swapping out. As you increase the value of number of index trips, index pages stay in cache for longer periods of time.
A data cache is implemented as an MRU/LRU chain. As the user threads access data and index pages, these pages are placed on the MRU end of the cache’s MRU/LRU chain. In some high transaction environments (and in some benchmarks), it is desirable to keep index pages in cache, since they will probably be needed again soon. Setting number of index trips higher keeps index pages in cache longer; setting it lower allows index pages to be swapped out of cache sooner.
You do not need to set the number of index pages parameter for relaxed LRU pages. For more information, see Chapter 19, “Configuring Data Caches.”
If the cache used by an index is relatively small (especially
if it shares space with other objects) and you have a high transaction
volume, do not set number of index trips too
high. The cache can flood with pages that do not age out, and this
may lead to the timing out of processes that are waiting for cache space.
