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

Last updated on JULY 10, 2024

Applies to:

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

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