Re: Peoplesoft Question

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Sat, 21 Jul 2012 15:40:59 +1000
Message-ID: <500A40EB.5040903_at_iinet.net.au>

Jeremy Schneider wrote,on my timestamp of 21/07/2012 6:38 AM:

> statements which are only usable if the database acts like we're still
> living in the mid-90s. Thus, buried in the recommendations, Oracle
> Support recommended to set the underscore parameters for disabling
> subquery unnesting and hash-based group-by aggregations.
>
> As soon as we disabled subquery unnesting, the parse time for this SQL
> statement went from 2 seconds to nearly instant. (It was easy to test

That disable seems to be a constant of all the Peoplesoft releases I've seen, for whatever level of the database. About time whatever causes/requires it got fixed...

-- 
Cheers
Nuno Souto
in wet Sydney, Australia
dbvision_at_iinet.net.au


--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 21 2012 - 00:40:59 CDT