DirecTutor.com

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

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

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.

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).

Siebel

Benefit of recognizing difficult people

Difficult people cause all kinds of problems in the workplace and make life miserable for their coworkers. For example, a person who misses deadlines can cause coworkers who are forced to pick up the slack to become resentful. A person who constantly complains can lower morale in the workplace. Being able to deal with a difficult person is a skill that can serve you well in the workplace and can help you avoid or overcome awkward situations.

Self Improvement

Siebel XML Web Interface

The XML Web Interface can be used against any Siebel eBusiness Application. Requests to generate XML from Siebel eBusiness Applications can be submitted through a Siebel Web Server using a query string or an XML command block.
Example:
Code Snippet to open HTTP connection to SWE get data from account list applet – using XML command:
###################################################################
<% @LANGUAGE="VBScript" %>
<%

Siebel EAI

Trouble shooting NEON Siebel Adaptor

Q1. MW has pushed a message but it is not showing up on the Siebel UI or in the database. What should I do?
You can check for any one of the below or all of the below
a. Check if the Adapters are up and running.
b. Check if the Adapters are using the right srf
c. Look for the errors generated in the folder \Sybase39\Siebel-3_9\bin. The log file names are usually
similar to the Adapter dat file names

Siebel EAI

Verifying NEON COM Data Server Log

NEON Delivery adapter uses COM Data Server to connect and get access to the object layer of Siebel.

The Log files that are generated by Siebel Data Server can be seen in the following path

  • \sea752\client\LOG\

If you want to increase the log level to get a detail trace of the sql’s generated, you can do so by completing the below steps:

Siebel EAI

NEON Adapter for Siebel

The NEON adapter for Siebel provides the capability to automate data transfers to and from Siebel 6 (2000) and Siebel 7 Enterprise Applications by leveraging current New Era of Networks (NEON) and Seibel Integration Objects.

Siebel EAI
Recent content