Forum Discussion

MichaelT_QIC's avatar
MichaelT_QIC
Frequent Visitor
5 years ago

Performance tuning Oracle ODAC driver with FetchSize option on OnPremises Data Gateway

Hello everyone,   We are using the Oracle ODAC 64bit driver in conjunction with the Microsoft OnPremises Data Gateway solution for retrieving data from a  "on prem" Oracle database and populating o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for posting this Michael. I definitely saw improvements when adjusting this locally. However, I do not see those gains on the gateway server. I adjusted this mashup config but did not see an improvement. Did you reboot the server or just the gateway service via the administrator tool? Thanks in advance.

MichaelT_QIC's avatar
MichaelT_QIC
Frequent Visitor
4 years ago

Hi, would have been a gateway service restart while figuring out the best value.  Server has also been reboot since then as part of server patching processes. 

  • MallikarjunaBan's avatar
    MallikarjunaBan
    Helper III
    3 years ago

    Hi MichaelT_QIC   will this work for oracle odac version 12 i am troubled now need to pull 32million records 

    • MichaelT_QIC's avatar
      MichaelT_QIC
      Frequent Visitor
      3 years ago

      Hi MallikarjunaBan the Oracle database we are connecting to now is version 19c and I'm not sure when the DB was upgrade to that version, so not sure I can guarantee it would work with version 12. 

      We are also in the process of upgrading to the latest Oracle-Client-for-Microsoft-Tools.exe as part of an environment uplift to latest versions.