Noons wrote:
> 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.
>
>
Correct. We have _complex_view_merging set to false per Peoplesoft's
recommendation in the spfile.
--
To reply by email remove "_nospam"
Received on Wed Sep 28 2005 - 10:24:50 CDT
