Search notes:

Oracle hint: RESULT_CACHE

Some variants/parameters of this hint are
/*+ result_cache */
/*+ result_cache(snapshot = 3600) */ 3600 seconds or one hour
/*+ result_cache(shelflife = 3600) */
/*+ result_cache(sysobj=true) */
/*+ result_cache(temp=false) */
/*+ result_cache(force_spatial) */ Apparently used for spacial geometry ADTs (such as SDO_GEOMETRY).

See also

The RESULT CACHE SQL plan operator
Result cache tables
Other hints

Index