Youhaveapplicationsthathavefrequentlyexecutedqueries,andproducesmallandstaticresultsets.Youconfigurethesqlnet.orafileintheclientmachinetosetanonzerovaluefortheOCI_RESULT_CACHE_MAX_SIZEparameter.Whatisthepurposeofthisconfiguration?()

A.toavoidroundtripstotheserverbyenablingcachingofqueryresultsinclientmemory B.toimproveperformancebystoringacopyofthedatafromtheprivateSQLareaofthePGA C.toenhancethequeryperformancebycreatingacacheintheclientmemoryforsortingoperations D.toavoidthestoringofqueryplansandresultsintheserverbycreatingacacheintheclientmemory

时间:2023-03-03 02:45:01

相似题目