Controling the chunksize using OraOLEDB.Oracle

Connection string

This Oracle Provider for OLE DB connection string can be used for connections to Oracle.

This one specifies the size, in bytes, of the data in LONG and LONG RAW columns fetched and stored in the provider cache.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Password=myPassword;ChunkSize=200;

Providing a high value for this attribute improves performance, but requires more memory to store the data in the rowset. Valid values are 1 to 65535. The default is 100.