O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh 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

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

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