| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle, Siebel and rule-based optimization
Hi Guys
I worked in Siebel Engineering as a lead performance engineer and went around the world cleaning up performance problems. What exactly is your issue, I can probably help you.
Step 1: Do NOT turn on CBO, you WILL KILL the application after 5 - 10 users have logged on. Step 2. Read the Siebel bookshelf.
Please describe your problem to me (us on the list).
Regards:
Ferenc Mantfeld
Dreaming costs you nothing. Not dreaming costs you everything.
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-----
From: Michael Fontana [mailto:mfontana_at_verio.net]
Sent: Thursday, January 30, 2003 7:41 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle, Siebel and rule-based optimization
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: Ferenc Mantfeld
INET: mantfield_at_connexus.net.au
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 - 13:00:04 CST
 |
 |