Click the + to the left of the Cache Groups node to view the list of cache groups. Next right-click the name of the cache group that you want to refresh. Then select Refresh to refresh the cache group.
The cache agent must be running in order to refresh a cache group.
For a read-only cache group or a user managed cache group that has automatic refresh defined, its automatic refresh state must be set to Paused before you can refresh the cache group.
In the Prompts tab of the Refresh dialog box, specify a numeric value in the Commit every n rows field to indicate the frequency, based on the number of rows that are refreshed into the cache group, at which a commit is issued during the refresh operation. By default, a transaction is committed after every 256 rows are refreshed into the cache group.
In the Number of threads to run in parallel field within the Prompts tab of the Refresh dialog box, specify the number of cache agent process threads to spawn and use for the refresh operation. Parallel processing of the refresh operation can potentially improve the operation's throughput. The numeric value specified in this field cannot exceed 10 and should not exceed the number of CPUs on the system that can be dedicated to the parallel refresh operation. The default value of 1 indicates that the refresh operation will be processed serially.
You can specify an optional WHERE clause for the refresh operation in the Where clause field within the Prompts tab of the Refresh dialog box. A WHERE clause is only allowed for a refresh operation on an AWT, SWT or user managed cache group that does not have automatic refresh defined.
Click the Apply button to refresh the cache group.
Related Topics