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