Re: 10g ORDER BY Performance

We already have that set for another problem and still
have the unordered sort issue.  

This is really a coding issue but we dno't have time
to fix it.

--- Ghassan Salem <salem.ghassan@xxxxxxxxx> wrote:

> It's not the new sort that doing this, it's the
> 'hash group by'
> try disabling it using
> alter ... set "_gby_hash_aggregation_enabled"=false;
> 
> 
> On 8/24/07, goran bogdanovic <goran00@xxxxxxxxx>
> wrote:
> >
> >
>
http://jonathanlewis.wordpress.com/2007/06/03/sorting/
> >
> > you may set it for a session too:
> >
> > alter session set "_newsort_enabled"=false;
> >
> 


Pete Barnett


       
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search 
that gives answers, not web links. 
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
--
http://www.freelists.org/webpage/oracle-l


Other related posts: