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

Last updated on NOVEMBER 06, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
FEM

Symptoms

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.


EXPECTED BEHAVIOR
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms