My Oracle Support Banner

DMU Extraction Performance Following Repeat Extraction Of Table (Doc ID 3027046.1)

Last updated on JUNE 06, 2024

Applies to:

Oracle Retail Xstore Office Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

On : 23.0 version, Data Migration Utility

Repeat DMU extraction against some tables is showing a significant increase in processing time, over what is seen initially. The extraction job is effectively the same and the output too but the time taken to complete the task differs.

Example:

1st file (TRN_RECEIPT_DATA-1714337453432-0.xload) was generated with extraction count of 30000 and file size - 91.8 MB.
2nd file (TRN_RECEIPT_DATA-1714359060246-0.xload) was generated after 5 hr duration with count of 30000 and file size - 92 MB.
3rd file (TRN_RECEIPT_DATA-1714362666548-0.xload) was generated after 1 hr duration with count of 30000 and file size - 101 MB.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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