My Oracle Support Banner

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

Last updated on JUNE 09, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.


This bulletin provides information about the SQL Query Result Cache


Database Administrators and Developers.


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
 SQL Query Result Cache Video
 Overview of the SQL query result cache
 Managing the Result Cache - Parameter Settings
 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
 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.