What is the purpose of this configuration?

You have applications that have frequently executed queries, and produce small and static
result sets. You configure the sqlnet.ora file in the client machine to set a nonzero value for
the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

You have applications that have frequently executed queries, and produce small and static
result sets. You configure the sqlnet.ora file in the client machine to set a nonzero value for
the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

A.
to avoid round trips to the server by enabling caching of query results in client memory

B.
to improve performance by storing a copy of the data from the private SQL area of the
PGA

C.
to enhance the query performance by creating a cache in the client memory for sorting
operations

D.
to avoid the storing of query plans and results in the server by creating a cache in the
client memory



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jake from SF

Jake from SF

A is correct

https://docs.oracle.com/cd/B28359_01/appdev.111/b28395/oci10new.htm

OCI applications can use client memory to take advantage of the OCI result cache to improve response times of repetitive queries.

This feature enables client-side caching of SQL query result sets in client memory. The OCI result cache is completely transparent to OCI applications, and its cache of result set data is kept consistent with any session or database changes that affect its result set.