My Oracle Support Banner

Detail Client Data Loader Slow Performance in Replacement Mode (Doc ID 434150.1)

Last updated on MARCH 22, 2019

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.


When attempting run the Detail Client Data Loader program to load data between FEM_DATAx_T into
FEM_DATAx, the replacement mode takes a lot longer than snapshot. Snapshot took around 1 minute
but the replacement mode took around 3 hours. There are only 8000 rows to load.

Expect the process to take less than 2 hours when running on replacement mode.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Run Detail Client Data Loader for FEM_DATAx in Snapshot mode and took 1 minute.
2. Launched Gather Schema statistic on the FEM schema before to load data
3. Input new records  to load.
4. Run Detail Cleint Data Loader in replacement mode and took a long time to complete.


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

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