Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FetchSize not recognized in app.config for managed ODP.NET?

Sebastian...Dec 23 2020

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...

Comments
Post Details
Added on Dec 23 2020
9 comments
823 views