Finding the cause of a slow Siebel Repository File (SRF) compile with Siebel Tools

A full SRF compile usually completes in under an hour for the standard Horizontal and Industry repositories. Many times developers report that a full SRF compile is very slow and is taking a significantly longer time. The following suggestions can help narrow down what is causing the slow performance when compiling a new SRF file.

1. Set up Dedicated Web Client logging for Siebel Tools.


Disable ST eScript engine

To disable ST eScript engine by setting the Enable ST Script Engine system preference. To do this: Log into Siebel Tools: 

  1. Navigate to Screen menu option, then choose System Administration > System Preferences option.

 

  1. Select Enable ST Script Engine system preference and set the value to FALSE.

 Or log into Siebel application: 


How Should Client Side Logging Be Set?

Using the SIEBEL_LOG_EVENTS environment variable, you can set what kind of information is collected. You should set this environment variable temporarily while troubleshooting any behaviors. When running the Siebel client in a production environment, you should not set this environment variable because it will affect performance and disk space.

Troubleshooting – Common Workflow Errors

The following lists some commonly encountered errors for Workflow Process Manager.

1. Problem: You activated your workflow but it is not executing

Solution: Verify if <Reload Runtime Events> performed. In order to tell if a process has been triggered, Turn workflow logging (EngInv, DfnLoad, StpExec, PrcExec) on. See the Business Process Administration Guide in Siebel Bookshelf for procedures on how to do this.


Tracing Siebel server task with SQL Trace and TKPROF in Oracle

tkprof is one of the most useful utilities available to Admins for diagnosing performance issues. It essentially formats a trace file into a more readable format for performance analysis. The DBA can then identify and resolve performance issues such as poor SQL, indexing, and wait events.

Why, When tkprof?


Database Performance Considerations - Where indexes can improve performance and where not

In a nutshell a database index is an auxiliary data structure which allows for faster retrieval of data stored in the database. They are keyed off of a specific column so that queries like “Give me all people with a last name of ‘Sam’” are fast.


Pages

Subscribe to Universal Remote Codes TV RSS