Youhaveapplicationsthathavefrequentlyexecutedqueries,andproducesmallandstaticresultsets.Youconfigurethesqlnet.orafileintheclientmachinetosetanonzerovaluefortheOCI_RESULT_CACHE_MAX_SIZEparameter.Whatisthepurposeofthisconfiguration?()
A.toavoidroundtripstotheserverbyenablingcachingofqueryresultsinclientmemory
B.toimproveperformancebystoringacopyofthedatafromtheprivateSQLareaofthePGA
C.toenhancethequeryperformancebycreatingacacheintheclientmemoryforsortingoperations
D.toavoidthestoringofqueryplansandresultsintheserverbycreatingacacheintheclientmemory
时间:2023-03-03 02:45:01