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

Last updated on AUGUST 02, 2017

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.

Cause

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