New System Maintenance Process for Consistent Data Load Performance

To address inconsistent data load times, Data Integration can now leverage a new feature in Oracle Autonomous Database to classify a table as STAGING, and introduces tables partitioning to isolate each data load process in a table partition.

In Data Integration, you run the Integration Maintenance Script Partition Data Load Staging Tables process to enable this feature.

In Data Management, you run the System Maintenance Task Partition Data Load Staging Tables process to enable this feature.

Business Benefit: Using the Partition Data Load Staging Tables feature provides you with consistent data load performance.

Tips And Considerations

Run the Partition Data Load Staging Tables process only when no other data load processes are running.

Key Resources