Controling rowset cache mechanism using OraOLEDB.Oracle
This Oracle Provider for OLE DB connection string can be used for connections to Oracle.
Specifies the type of caching used by the provider to store rowset data. OraOLEDB provides two caching mechanisms; File and Memory.
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Memory is the default value. All the rowset data is stored in-memory which provides better performance at the expense of higher memory utilization.
File = All the rowset data is stored on disk. This caching mechanism limits the memory consumption at the expense of performance.