SSIS Performance issue uisng Oracle 19c client

%3CLINGO-SUB%20id%3D%22lingo-sub-1479308%22%20slang%3D%22en-US%22%3ESSIS%20Performance%20issue%20uisng%20Oracle%2019c%20client%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479308%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20SSIS%20package%20takes%20around%2020%2B%20minutes%20with%20Oralce%2019c%20client.%26nbsp%3B%20The%20same%20package%20was%20taking%20around%204%20min.%20with%2012.1.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EEarlier%20to%20I%20noticed%20issue%20with%2012.2%26nbsp%3B%20and%20saw%20that%20is%20know%20bug%20-%20OraOLEDB%2012.2%2C%20which%20has%20memory%20issue%20(%20%3CA%20href%3D%22https%3A%2F%2Fsupport.oracle.com%2Fknowledge%2FOracle%2520Database%2520Products%2F2579259_1.html%23FIX%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EOracle%20Support%3C%2FA%3E)%20.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20anybody%20face%20similar%20isuse%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1479308%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntegration%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1785704%22%20slang%3D%22en-US%22%3ERe%3A%20SSIS%20Performance%20issue%20uisng%20Oracle%2019c%20client%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1785704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F705880%22%20target%3D%22_blank%22%3E%40SanNa1910%3C%2FA%3E%26nbsp%3Bwe%20have%20the%20same%20issue.%26nbsp%3B%20It%20is%20currently%20holding%20us%20back%20from%20upgrading%20the%20Oracle%20client%20off%20of%2012.1%20and%20moving%20to%20new%20SQL%20Server%202019%20servers%20from%202016.%26nbsp%3B%20We%20have%20at%20least%20600%20packages%20that%20used%20the%20Oracle%20OLE%20DB%20connection%20to%20pull%20data%20from%20Oracle%20to%20SQL%20Server.%26nbsp%3B%20I%20would%20love%20a%20resolution%20to%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1786089%22%20slang%3D%22en-US%22%3ERe%3A%20SSIS%20Performance%20issue%20uisng%20Oracle%2019c%20client%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834211%22%20target%3D%22_blank%22%3E%40Mark_Strait%3C%2FA%3E%26nbsp%3B%20Please%20contact%20Oracle%20support.%20it%20was%20resolved%20for%20us%20by%20applying%20Patching%20after%2019c%20update.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1809361%22%20slang%3D%22en-US%22%3ERe%3A%20SSIS%20Performance%20issue%20uisng%20Oracle%2019c%20client%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1809361%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F705880%22%20target%3D%22_blank%22%3E%40SanNa1910%3C%2FA%3E%26nbsp%3B%20Can%20you%20detail%20which%20patch%20you%20applied%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1966851%22%20slang%3D%22en-US%22%3ERe%3A%20SSIS%20Performance%20issue%20uisng%20Oracle%2019c%20client%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834211%22%20target%3D%22_blank%22%3E%40Mark_Strait%3C%2FA%3E%26nbsp%3BWe%20seems%20to%20face%20the%20exact%20same%20issue.%20Did%20you%20get%20any%20information%20what%20kind%20of%20patch%20this%20is%20and%20where%20it%20can%20be%20downloaded%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

8 Replies

@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?

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.

@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!! 

@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

On the client side(SQL Box) where we had our SSIS packages running.