RESULT_CACHE_INTEGRITY

2.341 RESULT_CACHE_INTEGRITY

RESULT_CACHE_INTEGRITY specifies whether the database enforces result cache integrity.

Property	Description
Parameter type	String
Syntax	`RESULT_CACHE_INTEGRITY = { ENFORCED \| TRUSTED }`
Default value	Oracle Autonomous Database: `ENFORCED` All other Oracle databases: `TRUSTED`
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	Yes
Basic	No
Oracle RAC	Different instances can have different values.

Values:

ENFORCED

Regardless of the setting of the RESULT_CACHE_MODE initialization parameter or any specified hints, only deterministic constructs will be eligible for result caching. For example, queries using PL/SQL functions that are not explicitly declared as deterministic will not be cached. This setting enforces result cache integrity.
TRUSTED

The database honors the setting of the RESULT_CACHE_MODE initialization parameter and any specified hints, and will consider queries using possibly nondeterministic constructs as candidates for result caching. For example, queries using PL/SQL functions that are not explicitly declared as deterministic may be cached. Results that are certain to be nondeterministic (for example, SYSDATE or constructs involving SYSDATE) will not be cached. This setting does not enforce result cache integrity, which matches the behavior in releases prior to Oracle Database 23ai.

Note:

This parameter is available starting with Oracle Database 23ai.