News

Table Fragmentation And Siebel EIM

9 February 2025
Prior to running EIM it is important to clean up fragmented objects, especially those that will be used during the EIM processing. The following SQL statement can be used to identify objects with greater than 10 extents:

Purging An EIM Table

9 February 2025
When purging data from the EIM table, use the TRUNCATE command as opposed to DELETE.

Caching Tables For EIM

9 February 2025
One other measure that can help performance is to pin small tables that are frequently accessed in cache.

Siebel Database Layout Guidelines

9 February 2025
As with most client-server applications, the overall performance of Siebel eBusiness applications is largely dependent on the I/O performance on the database server.

What Is FREELIST Parameter

9 February 2025
Multiple EIM processes can be executed against an EIM table provided they all use different batches or batch ranges. The concern is that contention for locks on common objects may be experienced.