10 Cache Group Operations
This chapter focuses on the operations you can perform on your cache group. Topics include:
Note:
TimesTen cache is not supported with TimesTen Scaleout databases.
Loading or refreshing a cache group
To load or refresh a cache group:
For more information about loading or refreshing a cache group, see "Loading and refreshing a cache group" in the Oracle TimesTen In-Memory Database Cache Guide.
Unloading a cache group
To unload a cache group:
- Click the + to the left of the Cache Groups node to view the list of cache groups.
- Right-click the name of the cache group to unload.
- Select Unload to unload the cache group.
- In the Where clause field within the Prompts tab of the Unload dialog, specify an optional
WHERE
clause for the unload operation. You can use aWHERE
clause for an unload operation on an AWT, SWT or user managed cache group that does not have automatic refresh defined. - Click Apply to unload the cache group.
For more information about unloading a cache group, see "Unloading a cache group" in the Oracle TimesTen In-Memory Database Cache Guide.
Flushing a cache group
Only user managed cache groups containing cache tables that are not all read-only, or not all updatable where updates on the tables are propagated to the corresponding Oracle tables can be flushed.
- Click the + to the left of the Cache Groups node to view the list of cache groups.
- Right-click the name of the cache group that you to flush.
- Select Flush to flush the cache group.
- In the Where clause field within the Prompts tab of the Flush dialog, specify an optional WHERE clause for the flush operation.
- Click Apply to flush the cache group.
For more information about flushing a cache group, see "Flushing a user managed cache group" in the Oracle TimesTen In-Memory Database Cache Guide.