Detail Client Data Loader Slow Performance in Replacement Mode
Last updated on NOVEMBER 06, 2008
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
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.
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