STMT_CACHE_HITS configuration parameter

Use the STMT_CACHE_HITS configuration parameter to specify the number of hits (references) to a statement before it is fully inserted in the SQL statement cache.

onconfig.std value
STMT_CACHE_HITS 0
values
0 = Fully insert all qualified statements in the SQL statement cache.

>0 = The first time a user issues a unique statement, the database server inserts a key-only entry in the cache that identifies the statement. Subsequent identical statements increment the hit count of the key-only cache entry. When the hit count of the key-only cache entry reaches the specified number of hits, the database server fully inserts the statement in the cache. Set hits to 1 or more to exclude ad hoc queries from entering the cache.

units
Integer
takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Copyright© 2019 HCL Technologies Limited