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.