We are using SAP BODS that connects to couple of Oracle DB and loads data from one DB to another and perform multiple other parallel transactions at the DB level at the same time. We are facing issue at the Oracle DB level when the BODS jobs are running with the record commit.
There are more than 10 million records that are loaded and at the same time other SQL statements were also executed. This is causing high frequency of commits at the DB level, which is blocking the sessions. As of now the commit record count is default, which I think is 1000. We need help to identify the correct commit record count at the BODS level that will have less performance impact at the DB level.