1. Cache Guide
  2. Cache Performance
  3. Dynamic Load Performance
  4. Managing a Cache Connection Pool to the Oracle Database for Dynamic Load Requests
  5. Dynamically Applying Cache Connection Pool Sizing Modifications

Dynamically Applying Cache Connection Pool Sizing Modifications

The cache connection pool parameters are saved in the Oracle database, which are used to initialize the cache connection pool for the TimesTen database every time that the TimesTen server restarts. The sizing is set on the Oracle database with the ttCacheConnPoolSet built-in procedure. This sizing applies to each TimesTen server and child server processes when started.

However, you can dynamically resize the cache connection pool parameters for each child server process (while the database is running) with the ttCacheConnPoolApply built-in procedure.

  • Execute the ttCacheConnPoolSet built-in procedure to set a new set of parameters that are stored on the Oracle database.

  • Connect to the child server process.

  • Dynamically associate the new set of cache connection pool parameters for this particular child server process with the ttCacheConnPoolApply built-in procedure.

For example, the following connects to the child server process identified as 1 and applies the new cache connection pool configuration to this child server process. It does the same process for child server process 2 (given that ServersPerDSN=2). 

Command> connect "DSN=cache1;ChildServer=1;";
Command> call ttCacheConnPoolApply;
Command> disconnect;

Command> connect "DSN=cache1;ChildServer=2;";
Command> call ttCacheConnPoolApply;
Command> disconnect;

You can run the ttCacheConnPoolApply built-in procedure only from a multithreaded client/server connection.

If the cache connection pool fails, you can recreate the pool by running the ttCacheConnPoolApply built-in procedure from any child server process.

See Example Demonstrating Management of the Cache Connection Pool.