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

Last updated on JUNE 09, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 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.

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

SQL Query Result Cache Video

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

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

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.