Oracle-L: Oracle, Siebel and rule-based optimization

From: Michael Fontana <mfontana_at_verio.net>
Date: Thu, 30 Jan 2003 07:40:47 -0800
Message-ID: <F001.0053EB60.20030130074047@fatcity.com>

I would like to ask a question of this esteemed and knowledgeable audience about running
SIEBEL applications on Oracle. Siebel insists that their CRM application will only run with
acceptable performance if rule-based optimization is chosen, yet, as we all know, there are
documented examples of poor performance, and strong recommendations to the contrary from Oracle.

At one point, I recall reading an article from a knowledgeable consultant describing what must be done
to get Siebel to run with optimizer_mode=choose. Any assistance in reaching this goal, or comments,
would be more than appreciated. We're still in the implementation phase, and are already receiving
poor performance on certain processes, even using the recommended rule based optimization. I
predict it will only get worse!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Michael Fontana
INET: mfontana_at_verio.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 30 2003 - 09:40:47 CST