Forum Discussion
SSIS Performance issue uisng Oracle 19c client
Hi, My SSIS package takes around 20+ minutes with Oralce 19c client. The same package was taking around 4 min. with 12.1. Earlier to I noticed issue with 12.2 and saw that is know bug - OraOLE...
SanNa1910 we have the same issue. It is currently holding us back from upgrading the Oracle client off of 12.1 and moving to new SQL Server 2019 servers from 2016. We have at least 600 packages that used the Oracle OLE DB connection to pull data from Oracle to SQL Server. I would love a resolution to this.
Mark_Strait Please contact Oracle support. it was resolved for us by applying Patching after 19c update.
SanNa1910 Can you detail which patch you applied?
Mark_Strait We seems to face the exact same issue. Did you get any information what kind of patch this is and where it can be downloaded?
