Result_cache_mode

Type:String
Syntax:RESULT_CACHE_MODE = { MANUAL | FORCE }
Default:MANUAL
Modify:ALTER SESSION, ALTER SYSTEM
Basic:No
Notes:RESULT_CACHE_MODE specifies when a ResultCache operator is spliced into a query's execution plan.

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
(provided that 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.