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 flushed off explicitly. The cached results are invalidated when the result data is updated in the table or the table structure is altered.

  • AUTO: The server decides on its own whether the result of the SQL query has to be cached or not. The server...