STMT_CACHE_SIZE configuration parameter

Use the STMT_CACHE_SIZE configuration parameter to specify the size of the SQL statement caches in kilobytes. The new cache size takes effect the next time a statement is added to a cache.

onconfig.std value
STMT_CACHE_SIZE 512
values
Positive integer
units
Kilobytes
takes effect
After you edit your onconfig file and restart the database server.

Copyright© 2019 HCL Technologies Limited