My Oracle Support Banner

FTP 8.0.5 Processing Slow Performance Issue (Doc ID 2856309.1)

Last updated on MARCH 16, 2022

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On FTP 8.0.5, all FTP engine batches are running abnormally slow during production processing.  All standard batches that normally run in 10-15 minutes are taking more than 2-3 hours.  The slowness is not tied to a specific product, FTP process, or instrument table (appears to be widespread).

Other tasks like SQL Rules are running in expected times.

DBA gathered schema stats and recycled server and services but the performance issue continues.
DBA is not seeing any issues with network/server or database performance.

Changes

Issue seems to have appeared after applying non related Break Identification patches (not FTP engine patches):

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.