| Property | Description |
| Parameter type | Big integer |
| Syntax | RESULT_CACHE_MAX_SIZE = integer [K | M | G] |
| Default value | Derived from the values of SHARED_POOL_SIZE, SGA_TARGET, and MEMORY_TARGET |
| Modifiable | ALTER SYSTEM |
| Range of values | 0 to operating system-dependent |
| Basic | No |
| Real Application Clusters | you must either set this parameter to 0 on all instances to disable the result cache, or use a nonzero value on all instances. Disabling the result cache on some instances may lead to incorrect results. |
RESULT_CACHE_MAX_SIZE specifies the maximum amount of SGA memory (in bytes) that can be used by the Result Cache. Values of this parameter greater than 0 are rounded up to the next multiple of 32 KB. If the value of this parameter is 0, then the feature is disabled.
Note:
1. The parameter was introduced in 11g. The Query Result Cache feature is available in Oracle Enterprise Edition only. Need to setting a minimum value for shared_pool_size to enable result cache.
2. Query for the current value of the parameter
select name, value, isdefault, isses_modifiable, issys_modifiable,
isinstance_modifiable, isdeprecated, description
from v$parameter
where upper(name) = 'RESULT_CACHE_MAX_SIZE';
No comments:
Post a Comment