Hi everyone,
I have a problem with setting the parameter FetchSize via an app.config file for the managed ODP.NET driver (oracle.manageddataaccess.dll). While the unmanaged ODP.NET driver seems to recognize and set the parameter according to what I specify in the application's app.config, the managed driver seems to ignore that parameter.
For the unmanaged client I use this section in the app config (works fine):
<oracle.dataaccess.client>
<settings>
<add name="FetchSize" value="1310720"/>
</settings>
</oracle.dataaccess.client>
According to https://docs.oracle.com/cd/E48297_01/doc/win.121/e41125/featConfig.htm#autoId7, the following setting should work for the managed driver:
<oracle.manageddataaccess.client>
<version number="4.122.19.1">
<settings>
<setting name="FetchSize" value="1310720"/>
</settings>
</version>
</oracle.manageddataaccess.client>
However, it does not seem to do anything. Reading OracleConfiguration.FetchSize gives me the default value of 131072 and with network throughput seem unaffected. Replacing the actual version number with "*" doesn't have any effect either.
Is this a bug in the managed ODP.NET driver? According to the documentation, it should work...