Load a Cache Group

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 load. Then select Load to load the cache group.

The cache agent must be running in order to load 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 load the cache group.

In the Prompts tab of the Load 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 loaded into the cache group, at which a commit is issued during the load operation. By default, a transaction is committed after every 256 rows are loaded into the cache group.

In the Number of threads to run in parallel field within the Prompts tab of the Load dialog box, specify the number of cache agent process threads to spawn and use for the load operation. Parallel processing of the load 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 load operation. The default value of 1 indicates that the load operation will be processed serially.

You can specify an optional WHERE clause for the load operation in the Where clause field within the Prompts tab of the Load dialog box. A WHERE clause is only allowed for a load operation on an AWT, SWT or user managed cache group that does not have automatic refresh defined.

Click the Apply button to load the cache group.

Related Topics

TimesTen Tasks

SQL Developer Concepts and Usage