Caching results with the client-side result cache
In this recipe we will see how to enable and use the client-side result cache to reach significant improvement in repeatedly executing complex queries.
Getting ready
To enable the client result cache feature in a database, we need to alter the CLIENT_RESULT_CACHE_SIZE parameter and set a size for caching larger than zero (the default value). This parameter specifies the size in bytes used by all the client processes as the maximum size of the client per-process result set cache.
To do so we need to execute the following commands, querying for the actual value of the parameter:
CONNNECT / AS SYSDBA SHOW PARAMETER CLIENT_RESULT_CACHE_SIZE
If we need to alter the size, because it is set to zero, or if ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
