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

Note:

This parameter is available starting with Oracle Database 21c.