Forum Discussion
SanNa1910
Jun 21, 2020Copper Contributor
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...
StefanScheuber-4875
Dec 08, 2020Copper Contributor
We received patch p31719903_190000_MSWIN-x86-64.zip from Oracle support which I am about to download and to have a look. It is a bit unclear for now if it has to be applied to the client and/or database.
SreekanthB
Mar 25, 2021Copper Contributor
We ran into exact same issue with Oracle 19C client. Applying this patch took our SSIS package execution times from ~16 hours to 1 hour!!
- Basit_KhanMay 06, 2021Copper Contributor
Did you apply the patch on database side or client side.
We have same the problem and despite applying patch on client side , our execution didn't return to original duration. when we use 12.1 client.
Thanks
Basit Khan
- SreekanthBMay 07, 2021Copper ContributorOn the client side(SQL Box) where we had our SSIS packages running.