Recommended Thread Count, Chunk Size, Max Batch Count and Commit Frequency for TFM Jobs (Doc ID 2349615.1)

Last updated on DECEMBER 08, 2023

Applies to:

Goal

1. While processing 3 million transactions daily for the TFM, and up to 21 million transactions weekly, please recommend the appropriate thread count, chunk size, max batch count and commit frequency for the following TFM batch jobs. The environment has 4 application servers, 6 batch servers and 4 database servers and the maximum threads configured is 1440.
- C1-TXNIP = thread count, chunk size, max batch count and commit frequency for daily? and for weekly?
- C1-TXNVP = thread count, chunk size, max batch count and commit frequency for daily? and for weekly?
- C1-TXNEX = thread count, chunk size, max batch count and commit frequency for daily? and for weekly?
- C1-TXNSQ = thread count, chunk size, max batch count and commit frequency for daily? and for weekly?
- C1-TXNCM = thread count, chunk size, max batch count and commit frequency for daily? and for weekly?
- C1-TXNCU = thread count, chunk size, max batch count and commit frequency for daily? and for weekly?
 

Solution

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