1.304 RESULT_CACHE_MODE

RESULT_CACHE_MODE specifies when a ResultCache operator is spliced into a query's execution plan.

Property Description

Parameter type

String

Syntax

RESULT_CACHE_MODE = { MANUAL | FORCE }

Default value

MANUAL

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

Multiple instances can have different values.

Values

  • MANUAL

    The ResultCache operator is added only when the query is annotated (that is, hints).

  • FORCE

    The ResultCache operator is added to the root of all SELECT statements (when it is valid to do so).

    For the FORCE setting, if the statement contains a NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting.

    Note:

    FORCE mode is not generally recommended because queries that call non-deterministic PL/SQL functions are cached, potentially causing material changes to the results. Enabling the result cache in such a broad-based manner can also impact performance in mixed workload environments, where the same tables are continuously updated and retrieved.

See Also: