Abraham, I would recommend reading Wolfgang's paper "What's New in the 9i CBO" at www.centrexcc.com. I would also not say this is a problem with the optimizer. Without seeing the stats and/or a 10053 trace...oops, I mean a Wolfgang, it is hard to say the optimizer is having a problem. For the most part, I find that it makes good decisions in 9i. Of course, from what I hear, when you add in Peoplesoft, the universe spins, up becomes down, right becomes left and good sql goes bad. Daniel Guerra, Abraham J wrote: >Hello all, > >Thanks to all that replied. I'm in the process of moving our PeopleSoft >Financials from SUN (8i) to HP-UX (9i). The optimizer seems to have a >mind of its own in 9i. By PeopleSoft suggestion, I have added the >following init.ora parameters that seem to have done the trick: > >_complex_view_merging=3DFALSE >_unnest_subquery=3DFALSE > >Thanks. > >Abraham Guerra >Oracle DBA >American Family Insurance > > ---------------------------------------------------------------- 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 -----------------------------------------------------------------