RESULT_CACHE_MODE specifies when a
ResultCache operator is spliced into a query's execution plan.
ResultCache operator is added only when the query is annotated (that is, hints).
ResultCache operator is added to the root of all
SELECT statements (provided that it is valid to do so).
FORCEmode is not recommended because the database and clients will attempt to cache all queries, which may create significant performance and latching overhead. Moreover, because queries that call non-deterministic PL/SQL functions are also cached, enabling the result cache in such a broad-based manner may cause material changes to the results.
FORCE setting, if the statement contains a
NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting.
See Also:Oracle Database SQL Language Reference for more information about the NO_RESULT_CACHE hint