Paul, I was using 8.1.7.4 with Siebel (v6.x or I think) a year or so ago. We used the CBO and it worked fine. However whenever any of the developers was using doing some major re-design / reconfigure or something similar we had to run the database in rule or else the operation took forever. (Sorry I can't remember exactly what this operation was but it don't happend when the system was being used in normal production mode.) An interesting aside: Siebel stated that Oracle must run in rule mode yet they had hand-crafted hints into some of the SQL. Cheers, Chris Quoting Paula Winkler <pw41972@xxxxxxxxx>: > Hi listers, > > I'm working on a project testing a Siebel 2000/v6 application with CBO on > Oracle 8.1.7.4. Preliminary testing showed positive results. Just wondering > if anyone on this list has any experiences to share with similar > Siebel/Oracle CBO configuration. > > Thank you in advance for your feedback! > > - Paula W. > > > > --------------------------------- > Do you Yahoo!? > Yahoo! Finance: Get your refund fast by filing online > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > Chris Dunscombe chris@xxxxxxxxxxxxxxxxxxxxx ------------------------------------------------- Everyone should have http://www.freedom2surf.net/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------