RESULT_CACHE_MAX_TEMP

2.315 RESULT_CACHE_MAX_TEMP_SIZE

RESULT_CACHE_MAX_TEMP_SIZE specifies the maximum amount of temporary tablespace (in bytes) that can be consumed by the result cache.

Property	Description
Parameter type	Big integer
Syntax	`RESULT_CACHE_MAX_TEMP_SIZE =` `integer` `[K \| M \| G]`
Default value	`RESULT_CACHE_SIZE` * `10`
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	Yes
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.

If you attempt to set this parameter to a value that is less than 5% of the size of the SGA, then this parameter will be set to 5% of the size of the SGA. If you attempt to set this parameter to a value that is more than 10% of the current total unused space available for temporary tablespaces in the SYS schema, then this parameter will be set to 10% of the current total unused space available for temporary tablespaces in the SYS schema.

If the value of this parameter is 0, then the result cache is disabled for the PDB.

Note:

This parameter is available starting with Oracle Database 21c.