Re: Minimize Performance Hit on Sort...Help!
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: Pankaj Jain <pjain@xxxxxxxxxx>
- Date: Tue, 2 Feb 2010 12:32:51 -0800
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@xxxxxxxxxx> wrote:
>
> From: Pankaj Jain <pjain@xxxxxxxxxx>
> Subject: RE: Minimize Performance Hit on Sort...Help!
> To: kjped1313@xxxxxxxxx, "oracle Freelists" <oracle-l@xxxxxxxxxxxxx>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
