• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1725
  • 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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

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