Siebel - Optimization techniques in EIM

GeekInterview.com > Interview Questions > Siebel

Go To First | Previous Question | Next Question

Siebel | Question 14 of 80

Optimization techniques in EIM

Total Answers and Comments: 4

Last Update: September 24, 2008 Asked by: saravanabhavan

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 19, 2006 23:37:39

anilkumar

RE: Optimization techniques in EIM

1) Limit base tables and columns to be processed by using : only base Tables ignore base Tables only base Columns ignore base Columns.

2) Always delete batches from EIM tables upon completion. Leaving old batches in the EIM table wastes space and can adversely affect performance. For other suggestions on working with batches.

3) Run independent EIM jobs in parallel. Two or more EIM processes can be started simultaneously by using the Siebel Server Manager.

4) Trace Flag Settings using Synonyms primary key only Parameters

Limiting the Number of Records and Rows for Merge Processes.

like this many techniques are there which will optimize the EIM process

Is this answer useful? Yes | No

June 25, 2006 19:38:02

Lal

RE: Optimization techniques in EIM

Apart from that you can use index.

Even using batch ranges ( eg. 100 to 200 ) will also increase the performance as it reduces the startup overheads.

Is this answer useful? Yes | No

August 20, 2006 16:00:19

Pavan

RE: Optimization techniques in EIM

Hi Even removing ( drop index) the index keys is also a crucial phenomenon here because it reduces the additional work of EIM and also we have to take care the SQL trace flag is not set to 8 the job parameters of EIM srr job for fast processing or else it slows the processing as it saves a huge log file everytime thk u Pavan

Is this answer useful? Yes | No

September 24, 2008 12:13:41

pdmaheshpd

Member Since: June 2008 Contribution: 2

RE: Optimization techniques in EIM

1) Limit base tables and columns
2) Run independent EIM jobs in parallel.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank