ttCacheConnPoolSet

The ttCacheConnPoolSet procedure also saves the values of these parameters on the Oracle database, which are then used as the default values when restarting the TimesTen server.

If you are dynamically changing the sizing, you can apply the changes to each TimesTen server by executing the ttCacheConnPoolApply built-in procedure.

For more details, see Managing a Cache Connection Pool to the Oracle Database for Dynamic Load Requests in Oracle TimesTen In-Memory Database Cache Guide.

Required Privilege

This procedure requires TimesTen cache administration manager or Admin privileges to run.

Usage in TimesTen Scaleout and TimesTen Classic

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

Related Views

This procedure has no related views.

Syntax

ttCacheConnPoolSet(MinSize, MaxSize, IncrSize, Timeout, ConnNoWait)

Parameters

All parameters must be specified for the ttCacheConnPoolSet built-in procedure. You can run the ttCacheConnPoolSet built-in procedure from a direct connection, a single-threaded client/server connection or a multithreaded client/server connection.

Parameter	Type	Description
`MinSize_IN`	`TT_INTEGER`	Specifies the minimum number of open connections for the cache connection pool. The default is 10 connections. The minimum is 1; the maximum is 2000 connections.
`MaxSize_IN`	`TT_INTEGER`	Specifies the maximum number of open connections for the cache connection pool. The default is 32 connections. The minimum is 1; the maximum is 2000 connections.
`IncrSize_IN`	`TT_INTEGER`	Specifies the increment by which the number of open connections increases when needed. The default increment is 1. The minimum is 1; the maximum is 2000 connections.
`Timeout_IN`	`TT_INTEGER`	Specifies a timeout (in seconds) for the connections in the cache connection pool. Connections that idle for more than this timeout are terminated to maintain an optimum number of open connections and returned to the cache connection pool. The default is 100 seconds. If set to 0, then the connections never time out. The minimum is 0; the maximum is 300.
`ConnNoWait_IN`	`TT_INTEGER`	Specifies whether to wait for an available connection from the cache connection pool when no connection is immediately available. Valid values are: Disabled (`0` - the default): Any dynamic load operations wait for an available connection in the cache connection pool before proceeding. Enabled (`1`): Any dynamic load operations fail with an error if there is no available connection in the cache connection pool.

Examples

The following initiates the minimum and maximum number of pooled connections to be between 10 and 32 connections and the increment is 1. The maximum idle time by the client is set to 10 seconds. And all dynamic load operations will wait for an available connection from the cache connection pool.

Command> call ttCacheConnPoolSet(10, 32, 1, 10, 0);

This procedure is available only for cache operations.