Informatica ETL has gotten slow following upgrading

(Doc ID 2225346.1)

Last updated on MARCH 01, 2017

Applies to:

Informatica OEM PowerCenter ETL Server - Version to [Release V7]
Information in this document applies to any platform.



Oracle Database EE Release

Informatica 9.6.1

Following Informatica upgrade, customer is running custom (not OBIA EP)  ETL with 100+ jobs fails on one job 90% of the time.  10% of the time it succeeds.
Database errors out with : ORA 12805 parallel query server died unexpectedly


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms