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