Cache Payback

June 26, 2008

[From OTN]

Oracle Data Provider for .NET (ODP.NET) enables you to take advantage of features exposed by the underlying Oracle Call Interface. One such feature new in Oracle Database 11g Release 1 and Oracle Database 11g Release 1 Client is the client result cache.

The client result cache is a portion of memory that is automatically allocated (on the client) to cache query results. Caching query results on the client makes it possible to avoid round-trips to the server to execute, query, and fetch data. This, in turn, leads to better performance and decreased resource consumption on the network and the server.

The article continues at http://www.oracle.com/technology/oramag/oracle/08-jul/o48odpnet.html