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

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Thu, 30 Jan 2003 09:51:23 -0800
Message-ID: <F001.0053F162.20030130095123@fatcity.com>

Michael:

Would you please post a summary of findings here on the list? I too have a Siebel implementation going on, and we are experiencing performance issues, and have set all the Siebel-specified initSID.ora parameters.

I am in California, and the database is 'across the pond' in Europe, so I am doing this remotely, and about 8 hours out of phase with my users. Any knowledge transfer will be appreciated.

Thanks
Mike

-----Original Message-----
Sent: Thursday, January 30, 2003 7:41 AM To: Multiple recipients of list ORACLE-L

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: Vergara, Michael (TEM)
INET: mvergara_at_guidant.com

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 - 11:51:23 CST