Controling the fetchsize using OraOLEDB.Oracle

Connection string

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

This one specifies the number of rows the provider will fetch at a time (fetch array).

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

The FetchSize value must be set appropriately depending on the data size and the response time of the network. If the value is set too high, this could result in more wait time during the execution of the query. If the value is set too low, this could result in many more round trips to the database. Valid values are 1 to 429,496,296. The default is 100.