Add an LRU Aging Policy to a Table

To add an aging policy to a regular table or a cache table, under the Tables node, right-click the name of the table that you want to add an aging policy to. An aging policy can be added to a cache table only if it is the root table of a cache group.

After you right-click the name of the table that you want to add an aging policy to, select Aging, then Add Usage-based to add an LRU aging policy.

In the Prompts tab of the Add Usage-based dialog box, specify an aging state by selecting either the on or off button in the Usage-based aging field. The default aging state is on. Then click the Apply button to add the LRU aging policy to the table.

The TimesTen database memory usage thresholds determine when data starts and stops being removed from the table. The default memory usage threshold that determines when data starts being removed from the table is 90%. The default memory usage threshold that determines when data stops being removed from the table is 80%. The default LRU aging cycle is 1 minute.

An LRU aging policy can be added to any regular table, and only to cache tables in an AWT, SWT or user-managed cache group that does not have automatic refresh defined.

Related Topics

TimesTen Tasks

SQL Developer Concepts and Usage