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 22.214.171.124 [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