Record Facts Cache
Specify whether cached records are stored in memory or in file.
This additional parameter specifies whether to cache manipulated or locked record facts in memory (default), in file, or not at all. These records are used to optimize queries by solving more queries locally.
When to use
If possible, always set this parameter to In Memory. Only set it to On File if you experience problems with memory that cannot be solved by reducing the value of the Record Facts Cache Size parameter. If you set this parameter to Not Active, there will be no caching.
To change the Record Facts Cache setting: