Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1604
  • Last Modified:

ORA-12801 and ORA-00600

A select statement failed in DWH env with following eoors.

<ORA-12801: error signaled in parallel query server P000                                                     ORA-00600: internal error code, arguments: [32695], [hash aggregation can't be done], [], [], [], [], [], []


What is causing 0ra-12801?
0
ajaybelde
Asked:
ajaybelde
  • 3
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Ora 600 errors are next to impossible to diagnose outside Oracle Support.

I would open an SR with them for help with this.

That said, you can normally look around for what has helped others.

There is a bug reference on this site:
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=40806&DestinationA=RSS

Oracle Support reference:
document ID 6471770.8 “Bug 6471770 - ora-32690/OERI [32695] [hash aggregation can't be done] from Hash GROUP BY”
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
May i ask you to post the query here if that is ok with  you and also unless it has some sensitivie information?
0
 
ajaybeldeAuthor Commented:
We are re-executing sql with "_gby_hash_aggregation_enabled" = false parameter change at database level & will keep you posted.

Thanks.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
slightwv (䄆 Netminder) Commented:
>>We are re-executing sql with "_gby_hash_aggregation_enabled"

I should point out that you should only set the hidden parameters (the ones that start with an underscore) when told to do so by Oracle Support.

Even if your test now appears to work, you should confirm this is a valid 'fix' by contacting Oracle Support.
0
 
ajaybeldeAuthor Commented:
"_gby_hash_aggregation_enabled"  parameter fix is working fine for us & i will followup with oracle to make sure it is a valid fix.

Thank you.
0
 
slightwv (䄆 Netminder) Commented:
Can I ask why the penalty "B" grade?  What did you require before providing an "A" grade?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now