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 AI 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 AI Database 26ai.

Note: This parameter is available starting with Oracle AI Database 26ai.

See Also: “RESULT_CACHE_MODE”