RESULT_CACHE_MAX

1.292 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	`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`
Modifiable in a PDB	No
Range of values	`0` to operating system-dependent
Basic	No
Oracle RAC	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.

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.