7.1 Server-Side Result Set Cache

The server-side result cache is used to cache the results of the current queries, query fragments, and PL/SQL functions in memory. The cached results are used in future uses of the query, query fragment, or PL/SQL function.

The cached results stay in the result cache memory part of the SGA. A cached result is automatically invalidated whenever a database object used in its creation is successfully changed. See Tuning the Result Cache for more information about configuring the server-side result set cache.

To enable the server-side result cache on True Cache, issue the following command on the primary database:

ALTER TABLE table_name RESULT_CACHE (STANDBY ENABLE);

Support for server-side result set caching is available for both JDBC Thin and JDBC Oracle Call Interface (JDBC OCI) drivers.