O'Reilly logo

Advanced Oracle PL/SQL Developer's Guide - Second Edition by Saurabh K. Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL query Result Cache

You can store the results of a SQL query in the SQL query result cache in three ways:

  • Enabling automatic result cache at the database level: Automatic SQL result caching is enabled by setting the initialization parameter RESULT_CACHE_MODE to FORCE, which enforces caching for all the SQL statements. However, you can prevent specific SQL queries from exhausting the Server Result Cache by using the NO_RESULT_CACHE hint.
  • Enabling automatic result cache at the table level: You can set RESULT_CACHE mode to FORCE for a particular table so that the results from the queries on this table will be cached in the query result cache.
    ALTER TABLE my_objects RESULT_CACHE (MODE FORCE)
    /

    You can specify a NO_RESULT_CACHE hint to avoid the cache ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required