SQL Query Result Cache in Oracle

• SQL Query Result Cache can improve the performance of your queries by caching the results of a query in memory, and then using the cached results in future executions of the query or query fragments. 
• The cached results reside in the result cache memory portion of the SGA. 
• This feature is designed to speed up query execution on systems with large memories.

• SQL result caching is useful when queries need to analyze a large number of rows to return a small number of rows or a single row.
• Two new optimizer hints are available to turn on and turn off SQL result caching:
• /*+ result_cache */
• /*+ no_result_cache */
• These hints enable you to override the settings of the RESULT_CACHE_MODE initialization parameter.
• You can execute DBMS_RESULT_CACHE.MEMORY_REPORT to produce a memory usage report of the result cache.