Re: Analyzing queries

danielroy10junk_at_hotmail.com (Daniel Roy) wrote in message news:<3722db.0401070725.5ebb3c7a_at_posting.google.com>...
> I have to deal every day with such a ------ product (Siebel). What I
> found is that pretty much the only "tuning" option that these bastards
> agree to let us perform is to create new indices when that helps. They
> won't even allow us to remove the indices containing one single value,
> that the RBO thinks is useful! Post the query and the execution plan,
> and we might be able to give more advice.
>
> Daniel
>

Having attended the Siebel Core Consultants Course and worked closely with Siebel since Nov-2002, recent discussions with them have revealed there is an option that allows Siebel session to be MT on the Siebel server. If so this should reduce the number of sessions to the DB and hence reduce the amount of resources used on the DB server, as well as not having to resort to using dedicated sessions because MTS reaches the maximum number of connections that a dispatcher can handle (max sessions reached). Basically increasing DB performance.

www.DBtune.com
support_at_DBtune.com Received on Wed Jan 07 2004 - 22:46:17 CET