Forum Discussion
Performance tuning Oracle ODAC driver with FetchSize option on OnPremises Data Gateway
That only did not try with acceleration of requests to Oracle.
There is one report for 370+ million rows, the initial data loading can take about 4-5 hours.
The server with the gateway and the server with Oracle are practically idle.
RAM 120GB
Processor for 64 cores.
Network 10 gigibit.
Actually loading all the same rests against something.
The fetch size is 16777216. Moreover, both in Microsoft.Mashup.Container.NetFX45.exe and in the registry itself for odac.
No one has found a way to speed up the selection and get a download of at least 200-300 megabits?
hi u mean it did not work after increasing fetch size please let me know for its 3hrs for 32million records
I can not make sense of your message. We have moved on to the Oracle Client for Microsoft Tools. The install can be found at https://www.oracle.com/database/technologies/appdev/ocmt.html.
Good luck.