DERG1600 Performance Degradation Post USFED 80970 Upgrade
(Doc ID 2760432.1)
Last updated on MARCH 21, 2021
Applies to:Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and later
Information in this document applies to any platform.
REG REP USFED 80970
DE DERG1600 refresh is running longer post upgrade to 80970. The change in 80970 is the count query added in BPRG2203(as shown below)
This query is evaluated for each row fetched in the DE join.
If we can add this to the data set and prevent this from being evaluated for every row the performance will improve
and FCT_REG_CREDIT_LINE_DETAILS.N_RUN_SKEY =
) > 0
END AS BPRG2203,
This BP is evaluated for every row and scans the 24 M rows in FCT_REG_CREDIT_LINE_DETAILS
In 80970 the count query added in BPRG2203
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