Increased Limit and New Set Limit Option for SQL Batch Processing in Data Integration

Currently the load process uses batch processing to insert and delete rows when the number of records exceed 1 million. This limit has now been increased to 3 million.

In addition, a new Record Limit for Database Batch Processing option in System Settings is available so customer can adjust the limit setting when the number of records is slightly higher than the current limit, and this will allow the user to set the limit above the 3 million row default.

Business Benefit: The limit increase improves performance when loading data for more than 1 million records.

Key Resources

• In Administering Data Integration for Oracle Enterprise Performance Management Cloud, see:
  • System Settings