11 Cache Group and Cache Table Characteristics
This chapter focuses on viewing cache table characteristics. After you create a cache group, you can view the characteristics of the cache group including the type of cache group, the automatic refresh attributes and the aging policy (if any). You can also alter the automatic refresh attributes.
Note:
TimesTen cache is not supported with TimesTen Scaleout databases.
Topics include:
Viewing the characteristics of a cache group
To view the characteristics of a cache group:
Viewing the cache tables
To view the list of cache tables in a cache group:
- Right-click the Cache Groups node.
- Click the + to the left of the node that contains the name of the cache group.
Viewing the cache group definition
To view the CREATE CACHE GROUP
statement:
- Select the cache group tab.
- Select the SQL tab.
If you are unable to find the cache group, see Locating a TimesTen database object for information.
Viewing the aging attributes
The Aging attributes tab, located within the cache group tab, shows information such as the aging policy type, aging cycle, and aging state for cache groups that have an aging policy defined.
For cache groups that have an LRU aging policy, the TimesTen database memory usage thresholds are displayed. For information on LRU aging and LRU thresholds, see Specifying an aging policy.
For cache groups that have a time-based aging policy, the name of the non-nullable DATE
or TIMESTAMP
column used to store the timestamp value (indicating when each row was added or most recently updated) and the length of time that non-updated data is not deleted is displayed.
Altering the automatic refresh attributes of a cache group
You can alter the automatic refresh attributes of a read-only cache group or a user managed cache group that has automatic refresh defined.
For more information about automatic refresh of cache groups, see "AUTOREFRESH cache group attribute" in the Oracle TimesTen In-Memory Database Cache Guide.