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.