My Oracle Support Banner

XOCS DataLoder Performance Decrease Required Data Guide (Doc ID 3071258.1)

Last updated on FEBRUARY 10, 2025

Applies to:

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

Goal

ENVIRONMENT:
Oracle Retail Xstore Office Cloud Service - v24.0.201.0

REPORTED ISSUE:
It can be seen that for a specific day there was a processing decrease for "big" files provided to DataLoader.
Within the XOCS STG1 DataLoader queue of .MNT files on this day a check on an example "big" file shows that the performance has decreased since July. For example

File 06_XR_APAC_12_MO3910_181_20240618_041142_4.MNT = Processed on 2024-07-22 and contained 869,710 lines. Was processed in 1395 seconds.
File 06_XR_APAC_12_1543_27105_20241212_071858.MNT = Processed on 2024-12-13 containing 678,177 lines was processed within 1862 seconds.

Whilst both files above completed successfully, this shows that a "big" file with the same row type, for the same brand and via the same XOCS DataLoader instance is 28% smaller but was processed 33% slower.
 

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


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