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. |