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.

See Also:

"RESULT_CACHE_MODE"