My Oracle Support Banner

Slow Performance During Execution of Allocations After Significant Increase in Data (Doc ID 2127791.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Profitability Management (PFT) 6.0, Dynamic Driver Allocations that move data from Ledger Stat into instrument tables are experiencing slow performance after a significant increase in data being processed.  Between the current month and prior month, the record count increased by 38% from 1.3 million to 1.8 million.  After the change in data, the "MERGE INTO <instrument table> SQL is taking much longer to execute.

You have gathered new statistics on the tables and indexes used by the Allocation already.

The execution plan generated for the "MERGE INTO" SQL shows indexes are being used.  You do not know why the Allocations are running more slowly after the increase in data.  You need to improve the Allocation performance.

Changes

 

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


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