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 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfgang Breitling Sent: Wednesday, August 11, 2004 1:49 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Query works fine in 8i and not in 9i Yes, I seem to get posts in a rather erratic order, often receiving the=20 answers before the question. I received the original post to this follow-up=20 queue by now, but still not Mark's. Although all posts seem to eventually make it. At 10:52 AM 8/11/2004, you wrote: >You must have missed Mark F's post where he said that doing a 10053 trace >could be called 'doing a Wolfgang'. We can add a Cary to the mix too. > >Ruth Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com=20 ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------