Query Cache-Related Parameters

The following are parameters related to the query cache functionality that provides execution results cached for the same SELECT statement. The type and value range for each parameter are as follows:

max_plan_cache_entries

max_plan_cache_entries is a parameter that configures the maximum number of query plans to be cached in the memory. If the max_plan_cache_entries parameter is configured to -1 or 0, generated query plans are not stored in the memory cache; if it is configured to an integer value equal to or greater than 1, a specified number of query plans are cached in the memory. Also, the value of this parameter must be configured to an integer value equal to or greater than 1 to use the query cache functionality that caches the results of the same query.

The following example shows how to cache up to 1,000 queries.

max_plan_cache_entries=1000