Forum Discussion

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

Mark_Strait

Copper Contributor

Oct 15, 2020

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.

SanNa1910

Copper Contributor

Oct 15, 2020

Mark_Strait Please contact Oracle support. it was resolved for us by applying Patching after 19c update.

Mark_Strait
Copper Contributor
Oct 22, 2020
SanNa1910 Can you detail which patch you applied?
- StefanScheuber-4875
  Copper Contributor
  Dec 08, 2020
  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?
  - StefanScheuber-4875
    Copper Contributor
    Dec 08, 2020
    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.