Oracle client result cache support

The Oracle adapter supports the Oracle client result cache. The Oracle client result cache stores the results of an Oracle database SQL SELECT query in memory on the Oracle client. Subsequent identical SQL queries can retrieve data from the cached query results in memory rather than through I/O to the Oracle database, reducing the number of Oracle server round trips and query executions.

Maps that make identical SQL SELECT queries to an Oracle database can potentially improve performance by using the adapter cache (-CACHE) option. The queries must be for simple data types in a read-only or read-mostly database.