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 - OraOLEDB 12.2, which has memory issue ( Oracle Support) .
Please anybody face similar isuse?
Thanks
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?
