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.
Related Topics
Parent topic: Complementary Caching Features