RESULT_CACHE_MAX_TEMP_RESULT

RESULT_CACHE_MAX_TEMP_RESULT specifies the percentage of RESULT_CACHE_MAX_TEMP_SIZE that any single cached query result can consume.

Property	Description
Parameter type	Integer
Default value	5 percent
Modifiable	ALTER SYSTEM
Modifiable in a PDB	Yes
Range of values	0 to 100
Basic	No
Oracle RAC	Multiple instances can have different values.