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 ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.