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
答案：（A）
解析：
《Call Interface Programmer's Guide》 10.4.4.1
客户端配置文件是可选的,会覆盖在init.ora初始化参数文件中的设置.这些参数是sqlnet.ora文件的一部分.
可以设置的参数有：
OCI_RESULT_CACHE_MAX_SIZE--每个进程的query cache的最大字节数.
如果在sqlnet.ora文件中指定的大小 < 32768, 则读取这个sqlnet.ora文件的客户端进程会禁用客户端结果缓存功能
OCI_RESULT_CACHE_MAX_RSET_SIZE--针对全局进行设置（单位为字节）
OCI_RESULT_CACHE_MAX_RSET_ROWS--针对全局进行设置（单位为行）