Applications with the Oracle Call Interface (OCI) client can largely benefit from the result cache feature. The results from an SQL query and a PL/SQL function can be cached within the OCI client process cache and not in the database server memory. Caching results in the client process cache helps in multiple ways. First, the query response time improves drastically as the results are served directly from the cache without even hitting the database server. Second, the reduced network roundtrips enhance application performance and the effective utilization of database resources.
How is the consistency of results in the client process cache maintained? The Oracle Database server is responsible for monitoring the consistency of cached results. If the underlying data is modified, the database server notifies the client process and invalidates the result set. On its next roundtrip to the server, the client process rebuilds the stale results.
The client result cache is independent...
