Cache Database Attributes

Cache database attributes are only used when caching Oracle Database data.

The cache database attributes are described in detail next.

CacheAWTParallelism

CacheAWTParallelism indicates the number of threads that apply changes to the Oracle database.

This attribute has a relationship to ReplicationParallelism and ReplicationApplyOrdering.

If you do not set this attribute or if you set it to the default value of 1, the number of threads that apply changes to the Oracle database is twice the setting for ReplicationParallelism to the maximum value of 31.

If both ReplicationParallelism and CacheAWTParallelism attributes are set, the value set in CacheAWTParallelism configures the number of threads used for parallel propagation. The setting for CacheAWTParallelism determines the number of apply threads for parallel propagation and the setting for ReplicationParallelism determines the number of threads for parallel replication.

CacheAWTParallelism only has an affect when there are AWT cache groups.

To learn more about parallel AWT caching, see Configuring Parallel Propagation to Oracle Database Tables in Oracle TimesTen In-Memory Database Cache Guide.

Required Privilege

Only the instance administrator can change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set CacheAWTParallelism as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic	CacheAWTParallelism	n - An integer between 1 and 31 that indicates the number of threads that apply changes to the Oracle database. The default is 1.
Windows ODBC Data Source Administrator	Not applicable

UseCacheConnPool

Enable the cache connection pool with the UseCacheConnPool connection attribute.

The cache connection pool can only be initiated from client/server applications and is used only for dynamic loads initiated for dynamic read-only cache groups.

To learn more about the cache connection pool, see Managing a Cache Connection Pool to the Oracle Database for Dynamic Load Requests in Oracle TimesTen In-Memory Database Cache Guide.

Required Privilege

No privilege is required to change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set UseCacheConnPool as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic	UseCacheConnPool	2 - Enabled: For each statement that requires a dynamic load from the Oracle database, the connections to Oracle are released after the load completes and the connection is returned to the cache connection pool. If a dynamic load is performed from a direct connection, the dynamic load proceeds as if the feature is not enabled. 0 (default) - Disabled: For each statement that requires a dynamic load from the Oracle database, the connections to Oracle are not closed by TimesTen after the load completes.
Windows ODBC Data Source Administrator	Not applicable