Re: 10g have group by bug?

From: Havel Zhang <havel.zhang_at_gmail.com>
Date: 17 Apr 2007 23:29:09 -0700
Message-ID: <1176877749.133019.4010@n76g2000hsh.googlegroups.com>

On Apr 18, 10:16 am, K Gopalakrishnan <kaygo..._at_gmail.com> wrote:
> Hi,
>
> (If you are on 10g )I guess you are hitting bug:4604970. Try setting
> _gby_hash_aggregation_enabled to false to disable the hash aggregation
> or apply the patch..
>
> -Gopal

hi all:

        Thank you all mention my post.
        Thank you Gopal, as u said, it does a bug:4604970. and when i

issued ' alter system set "_gby_hash_aggregation_enabled" = false ;', then I noticed execution explain from :(hash) group by to (sort) group by , and this problem solved. I've ask my DBA to apply patch 10.2.0.3.

       Thank u David, it's a real problem on decode(...) expression on my aggregation query, thank for your advice about the way of my asking question, when i review my oracle / OS version, i notice my Oracle version is 64bit 10g 10.2.0.2 on 64bit windows 2003 server, and consult Gopal's advice, finally i found out where the problem is.

       Thank u all again!

Havel Zhang Received on Wed Apr 18 2007 - 01:29:09 CDT