Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Eliminating cartesian merge

Re: Eliminating cartesian merge

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 29 Sep 2005 01:16:12 +1000
Message-ID: <433ab3bd$0$6524$5a62ac22@per-qv1-newsreader-01.iinet.net.au>


Jonathan Lewis apparently said,on my timestamp of 29/09/2005 12:50 AM:
>
> As an experiment, you could try:
> alter session set "_complex_view_merging" = false;
>
> You could also try putting a no_merge hint into
> the query, perhaps using a global hints to reference
> objects inside the view.
>
>

I do believe that's one of the settings recommended for the pfile by Peoplesoft support.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam
Received on Wed Sep 28 2005 - 10:16:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US