SQL Queries on Instrument Tables Have Slow Performance After Running FTP Processes
(Doc ID 2771287.1)
Last updated on NOVEMBER 01, 2022
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
After running a batch of FTP Processes, SQL queries on instrument tables (ex. FSI_D_CASA, FSI_D_CREDIT_CARDS, FSI_D_LOAN_CONTRACTS, etc.) have very slow performance. A SQL query that was 10 seconds now takes 10 minutes. Reviewing the table statistics, the tables are fragmented and rows are spread across multiple blocks.
The FTP Processes update multiple columns the instrument tables. For example:
You already implemented partitioning on the As of Date column.
You do not expect SQL query performance to decline after running the FTP Processes.
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