Re: Minimize Performance Hit on Sort...Help!

From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 2 Feb 2010 12:32:51 -0800
Message-ID: <a9c093441002021232u17d41cddpa00a5f791d0bbc28_at_mail.gmail.com>

Please, please, please to not make claims to bugs without including the bug number and the release you encountered it on. Make your information as useful as possible to others. Off the cuff remarks just spreads fear and uncertainty.

Second, suggesting to disable functionality (of which is unclear is even present or a problem in this particular issue as of yet) is not beneficial to anyone. Let's try and diagnose the problem first, then recommend options.

The next thing you know someone will find this via their favorite search engine and just blindly apply this suggestion hoping/wishing/praying it may fix a problem they may or may not have. Let's please not promote tuning/troubleshooting by guessing. It's 2010 and time to use systemic troubleshooting approaches.

(I'm off my soap box now and return you to your regularly scheduled programming)

> --- On Tue, 2/2/10, Pankaj Jain <pjain_at_ibasis.net> wrote:
>
> From: Pankaj Jain <pjain_at_ibasis.net>
> Subject: RE: Minimize Performance Hit on Sort...Help!
> To: kjped1313_at_yahoo.com, "oracle Freelists" <oracle-l_at_freelists.org>
> Date: Tuesday, February 2, 2010, 10:13 AM
>
> What Oracle environment r u using. If it is 11.1 then I would suggest to add
>
> *._gby_hash_aggregation_enabled=FALSE
>
> in your init.ora for the optimizer to work properly as this is one of the bug in 11.1

--
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 02 2010 - 14:32:51 CST