Forum Discussion

SanNa1910's avatar
SanNa1910
Copper Contributor
Jun 21, 2020

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...
Integration Services
SreekanthB's avatar
SreekanthB
Copper Contributor
Mar 25, 2021

StefanScheuber-4875 

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_Khan's avatar
Basit_Khan
Copper Contributor
May 06, 2021

SreekanthB : 

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

  • SreekanthB's avatar
    SreekanthB
    Copper Contributor
    May 07, 2021
    On the client side(SQL Box) where we had our SSIS packages running.

Resources