Re: 10g ORDER BY Performance
- From: Peter Barnett <regdba@xxxxxxxxx>
- To: Oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Aug 2007 10:48:38 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
