Re: Oracle, Siebel and rule-based optimization

[Ferenc Mantfeld]

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. ----- Original Message ----- From: Vergara, Michael (TEM) To: Multiple recipients of list ORACLE-L Sent: Friday, January 31, 2003 4:51 AM Subject: RE: Oracle, Siebel and rule-based optimization 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:[EMAIL PROTECTED]] 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!