Siebel Admin

What is FREELIST Parameter

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.

Table Fragmentation and Siebel EIM

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:

What is sfsutl, How Should SFSUTL.EXE be Used?

sfsutl.exe can be found in Siebsrvr\bin directory, in siebel versions 6 and older SFSUTL.EXE used to delte the orphan and old versions of attachments.

Is it possible to kill a session at the Database layer? Will the Siebel session be terminated?

he session can be killed at the Database layer, however the Siebel object manager's DB Connector will automatically perform a session reconnect :

Here is the session from Oracle's v$session table :

Overcome Error while Checkout

A common error encountered while doing an object Checkout/Get is –
Siebel-ERR-1109: Unable to read value from export file (Data length (4) > Column definition (1));
Solution :

Determining the Siebel User id using the Oracle process id to find who is running the longrunning SQLs

This document will explain a procedure that may be used to associate a specific Oracle database session from the V$SESSION table with a specific Siebel user session.

Server Tables Cleanup component failing - deadlock trying to delete records from s_srm_request

"In Siebel version 7.7, the SRProc component has a new parameter called Enable Various Housekeeping Tasks (Parameter alias = EnableHouseKeeping).

Enabling Users to change Password for Siebel Application

To Enable the Users to change Password for Siebel Application follow below instructions. By Using this particular feature, user can change their password for Siebel Application which will be propagated to the Database as well.

Apply and Activate on Local Database causes Tools Application to Hang

Connected to the local database with the user id and password for the local user; while applying with the correct ODBC connection and the process initiates for a minute, and then Siebel tools automatically closes; In another machine, the process i


Subscribe to Siebel Admin