2.343 RESULT_CACHE_MAX_SIZE
RESULT_CACHE_MAX_SIZE
specifies the maximum amount of SGA memory (in bytes) that can be used by the result cache.
Property | Description |
---|---|
Parameter type |
Big integer |
Syntax |
|
Default value |
Derived from the values of |
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
|
Basic |
No |
Oracle RAC |
You must either set this parameter to |
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.
See Also:
Oracle Database Performance Tuning Guide for information about tuning the result cache