Saturday, 28 May 2011

Siebel database (OLTP) blocking


A few days back, I was working on a Siebel application which had the issue of a lot of database blockings and the running tasks frequently reached max tasks.
We took the below steps to pin the problem

Siebel architecture high level overview



Siebel has many components and the one which is extensively used is ecommunications_enu.
The following is a good view of the general architecture of Siebel