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