Siebel Business Process & Functionality (MOSC)

MOSC Banner

EIM Merge Slow for Contacts and Accounts

edited Jun 13, 2019 4:43AM in Siebel Business Process & Functionality (MOSC) 2 commentsAnswered

Hi,

We are running EIM Merge process for Contacts and Accounts. However, its performance is very slow. It takes 6-7 hours to process 17k records.

We have modified our Ifb with reference to Index hints and Using Synonyms. Log Transaction is TRUE and Set Based Logging is FALSE.

I have few questions:

1. Are there any other approach to be followed in order to improve performance of Merge Process.

2. Is it mandatory to keep Log Transaction TRUE and Set Based Logging FALSE for EIM Merge Process

3. What is optimum batch size for EIM Merge process. We are using 5000 records per batch

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center