Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Does ODP also have a CacheType feature like OraOLEDB?

Does ODP also have a CacheType feature like OraOLEDB?

From: <sunil_at_volcanomail.com>
Date: 26 Feb 2006 22:25:06 -0800
Message-ID: <1141021506.055779.100140@v46g2000cwv.googlegroups.com>


Dear All,

   Does ODP.Net also have a CacheType feature like OraOLEDB? Also if the value is set to file where is the file stored? on the DB server or on the client?
Here is the description:
  OraOLEDB-specific connection string attributes which affect the performance of the
rowset are:
¦ CacheType - specifies the type of caching used by the provider to
store rowset
data. OraOLEDB provides two caching mechanisms:
¦ Memory - The provider stores all the rowset data in-memory. This
caching
mechanism provides better performance at the expense of higher memory utilization. The default is Memory.
¦ File - The provider stores all the rowset data on disk. This
caching mechanism
limits memory consumption at the expense of performance.

Please help...

Thanks & regards
Sunil Received on Mon Feb 27 2006 - 00:25:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US