Slow Performance During Execution of Allocations After Significant Increase in Data
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)
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.
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