Configuring the database for the server result cache

In this section, we will learn the configuration of the server-side result cache feature. Oracle 11g adds four new initialization parameters to DBA's basket to configure the caching feature on a database server. These parameters can be set at the database level and session level. Since these settings enable caching at the server side, results from both SQL and PL/SQL namespaces can be cached under the server cache.

The parameters are as follows:

  • RESULT_CACHE_MODE: This parameter controls the caching operation by the server. The server operates the caching feature in three modes—AUTO, MANUAL, and FORCE. Check the server behavior in these modes. The result is held in the cache memory until it is ...

Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial