Siebel Application Response Measurement (SARM)
When an end user clicks a view tab to navigate to a new view, a chain of processes is invoked on different machines in order to handle the request. For example, the Siebel Web Server Extension must connect to the application object manager (AOM) on the Siebel server. The AOM will issue an SQL statement to the Siebel database and the Siebel Web Engine (SWE) will put the view layout and data together and render the view.
Siebel Server Component Event Logging
The Siebel Server and the server components it hosts are among the most frequently used processes in a typical Siebel CRM implementation. In the case of error situations or slow performance, we must be able to quickly pin-point the root cause of the problem. One way to do this is to direct the server processes to write more detailed information in their log files.
What is Account Planning?
Every member of a company is responsible for its success by enhancing its brand equity. Perhaps you are a brand manager responsible for a specific brand or portfolio of brands. Maybe you are the president of a company or a marketing director. Or maybe you are an account planner, or account manager, or even president of an advertising agency. Perhaps you are in charge of developing a hypothetical advertising campaign for an advertising or marketing class.
Implementing Total Productive Maintenance (TPM)
To calculate OEE, you need to perform the main calculation as well as the calculations that go into each of the three elements of availability, performance, and quality. As a reference to these calculations, consider the following example.
A computer chip manufacturer is implementing TPM and wants to get a one-week baseline measurement of OEE before the initiative is undertaken. The Six Sigma team collects the following data:
Shift Data
Guide to twitter - what you should know about twitter
Tweeting is becoming very common, do you know the techniques to effectively tweet. Here are some tips for you
Siebel Connection pooling
Connection pooling in Siebel is very important for performance. Siebel Bookshelf contains a section on “Database Connection Pooling Usage Guidelines” that provides general recommendations with regards to connection pooling. Several factors should be considered when determining whether to use connection pooling in an implementation. For example, number of users, type of connections etc.
An implementation with connection pooling is characterized by the following behavior:
Siebel Application Bind variable vs. literals in queries
Siebel uses statements with bind variables throughout the application. Bind variables are good for performance, as Oracle does not need to hard-parse the query every time it is executed. However, in some cases, bind variables lead to major performance problems. One of the more significant problems we faced was the issue of bind variables in SQL LIKE predicates. By default Siebel uses bind variables in passing query criteria values entered by users.
Siebel session hints
When creating the database session, the Siebel database connector makes the following session level changes
It is important to always remember these session hints when analyzing or tuning the performance of Siebel queries. For example, if you are executing a problematic SQL from SQLPlus, or reviewing an execution plan, and you did not set the above session hints, the plan that Oracle will use will most likely differ from the plan the optimizer uses for Siebel.
indexing Siebel custom columns
In most implementations, a high number of indexes already exist on some of the tables (such as, S_OPTY) and you must be careful not to add too many indexes. A new index can fix one query but may slow down another. Moreover, each new index adds some overhead to the system and slows down DML statements (such as, Insert, Delete, and Update).