Enabling the Oracle adapter to use the Oracle client result cache

Enable the client result cache on the Oracle server, and configure the Oracle adapter command and the SQL SELECT query to use the cache.

• On the Oracle server, set the CLIENT_RESULT_CACHE_SIZE initialization parameter and restart the database. For example:

  alter system set client_result_cache_size=4M scope=spfile

  See your Oracle documentation for details and for other Oracle server initialization parameters.

• Add the -CACHE option to the Oracle adapter command line on the input card or on the GET, DBLookup, or DBQuery functions.
• Add the SQL RESULT_CACHE hint to the SELECT query. Ensure that there are no spaces between the asterisk (*) character and the and plus (+) character in the hint. For example:

  =GET("DB","-CACHE -STMT ""SELECT /*+ RESULT_CACHE */ name FROM employee WHERE id=:bind('12')"" -DBTYPE ORACLE -CONNECT ORA -U u1 -P p1")