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 improve performance by storing a copy of the data from the private SQL area of the
PGA
B.
to enhance the query performance by creating a cache in the client memory for sorting
operations
C.
to avoid round trips to the server by enabling caching of query results in client memory
D.
to avoid the storing of query plans and results in the server by creating a cache in the
client memory