ttCacheConnPoolApply
This procedure enables you to dynamically resize the cache connection pool parameters on each child server process, after which the cache connection pool parameters are associated with the child server process.
Use the ChildServer
connection attribute to identify each child server process, where ChildServer=
n
and n
is a number ranging from 1 to the number of running child server processes. Once connected to the child server process, you can run the ttCacheConnPoolApply
built-in procedure that is meant for a specific child server process.
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
ttCacheConnPoolApply()
Parameters
There are no parameters for this procedure.
Result Set
ttCacheConnPoolApply
returns no results..
Examples
The following connects to the child server process identified as 1 and applies the saved 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;
Notes
-
This procedure is available only for cache operations.
-
You can only run the
ttCacheConnPoolApply
built-in procedure from a multithreaded client/server connection. -
If the cache connection pool fails, you can recreate the pool by executing the
ttCacheConnPoolApply
built-in procedure from any child server process.
See Also