STMT_CACHE_QUERY_PLAN configuration parameter
Use the STMT_CACHE_QUERY_PLAN configuration parameter to produce a query plan from any query that exists in the Statement Cache.
- onconfig.std value
- STMT_CACHE_QUERY_PLAN
- values
- 0 = Disabled.
1 = Enabled
- 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.
Usage
You can use STMT_CACHE_QUERY_PLAN to enable SQL statement cache to hold query plan for each cached statement.