My Oracle Support Banner

SQL Query Result Cache. Includes: [Video] (Doc ID 1108133.1)

Last updated on NOVEMBER 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This bulletin provides information about the SQL Query Result Cache

Scope

Database Administrators and Developers.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Overview of the SQL query result cache
 Managing the Result Cache - Parameter Settings
 RESULT_CACHE_MODE
 RESULT_CACHE_MAX_SIZE
 RESULT_CACHE_MAX_RESULT
 RESULT_CACHE_REMOTE_EXPIRATION
 Using hints
 Hints Can Reduce Initial Query Performance
 Hinted In-line view Example
 Controlling Result Caching Via the Create Table RESULT_CACHE Clause
 Using the DBMS_RESULT_CACHE package
 BYPASS Procedure
 FLUSH Function
 STATUS Function
 INVALIDATE Functions & Procedures
 INVALIDATE_OBJECT Functions & Procedures
 MEMORY_REPORT Procedure
 Examples of Result Cache Procedures
 Viewing SQL result cache dictionary information
 SQL query result cache: Considerations
 RAC Considerations

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.