My Oracle Support Banner

How Does the Bulk Insert Feature Commit Frequency Parameter Influence ALM and ALM-LRM Processes? (Doc ID 2373510.1)

Last updated on MARCH 16, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

Question 1: How to activate bulk insert for ALM processing to improve performance?

Question 2: Is bulk insert also used for the Audit part of the process, especially when the Detailed Cash Flow is activated and the process is writing in FSI_O_PROCESS_CASH_FLOWS table?

It has been noticed that after every line that it is inserted, a commit is also made, thus taking a lot of time.  This function is desired to be activated for the ALM processes running for Oracle Financial Services Liquidity Risk Management (LRM) purposes.
 
Question 3: What are the optimal parameter setting combinations for bulk insert?
 
Question 4: Where is process tuning detailed, based on process type?

Changing the commit frequency to '999' for the ALM-LRM process helped in decreasing the run time. However, for other ALM processes, process works best if commit_frequency = '0'.

Performance tuning documentation states that COMMIT_FREQUENCY is advised to be set as 0. Since this is not the case for all processes (i.e. ALM-LRM processes), it is expected to be documented in some place other than the <Document 1307766.1> Definition of OFSAA Process Tuning Options?

Solution

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
Goal
Solution
References


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