STMT_CACHE_NUMPOOL configuration parameter

Use the STMT_CACHE_NUMPOOL configuration parameter to specify the number of memory pools for the SQL statement cache. To obtain information about these memory pools, use onstat -g ssc pool.

Because the database server does not insert all statements that allocate memory from the memory pools in the cache, the cache size might be smaller than the total size of the memory pools.

onconfig.std value
STMT_CACHE_NUMPOOL 1
values
1 - 256
units
Positive integer
takes effect
After you edit your onconfig file and restart the database server.

Copyright© 2019 HCL Technologies Limited