Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How ODI commit every n number of rows

Zuhair AmjadMay 6 2026

I have around 44 million rows in the source Oracle database, and I need to load them into the target Oracle database.

Currently, I am using:

LKM: SQL to Oracle
IKM: IKM Oracle Control Append
CKM: CKM Oracle

The load process is taking a long time.

How can I improve the loading performance or configure commits every 20,000 rows?

Added on May 6 2026

#odi

1 comment

172 views