"Sunil Menon" wrote:

> Dear All,
>    Does MS supplied  .NET Framework Data Provider for Oracle 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
>
>