Cube processing jobs run slowly after Oracle Client upgrade to 19c

Products

• IT Analytics

Issue/Introduction

After upgrading the Oracle Client installed on the server hosting both the Microsoft SQL Server service and the ITAnalytics database from 12c to 19c, cube processing jobs run slowly, taking days to complete and, in some cases, running interminably.

Environment

Release : 2.9.1

Cause

Performance issues are caused by a defect in the Oracle 19c client (BUG 30395329 - PERFORMANCE ISSUE AFTER UPGRADING OLE DB DRIVER TO 12.2 AND ABOVE (19.3)) that is addressed by the Windows DB Bundle patch 19.7.0.0.2004142, issued by Oracle (Doc ID 2694472.1).

Resolution

Contact Oracle support for assistance with obtaining and installing the patch referenced in the Cause section of this article.