RESULT_CACHE_EXECUTION_THRESHOLD

RESULT_CACHE_EXECUTION_THRESHOLD specifies the maximum number of times a PL/SQL function can be executed before its result is stored in the result cache.

Property Description
Parameter type Integer
Default value 2
Modifiable ALTER SYSTEM
Modifiable in a PDB Yes
Range of values 0 to operating system-dependent
Basic No
Oracle RAC Multiple instances can have different values.