My Oracle Support Banner

ORA-600[qxuag_get_md4] or [qxuag_find_udag] in 11g onwards when user-defined aggregates (UDAGs) (Doc ID 1376310.1)

Last updated on MARCH 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Your alert log shows ORA-00600 [qxuag_get_md4] or ORA-600 [qxuag_find_udag] errors.

ORA-00600: [qxuag_get_md4], [0], [], [], [], [], [], [], [], [], [], []


You may see some or all of the following conditions in your trace file. In our example the trace file analysis shows:

...
*** 2011-10-17 22:44:48.831
*** SESSION ID:(157.4639) 2011-10-17 22:44:48.831
*** CLIENT ID:() 2011-10-17 22:44:48.831
*** SERVICE NAME:(X01) 2011-10-17 22:44:48.831
*** MODULE NAME:(PL/SQL Developer) 2011-10-17 22:44:48.831          <===3rd party tool
*** ACTION NAME:(SQL Window - New) 2011-10-17 22:44:48.831
...

 

The Current SQL Statement in the same trace file shows a complex SELECT query involving user-definec aggregates (UDAGs).



----- Call Stack Trace -----

Stack Trace: ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE kgeadse kgerinv_internal kgerinv kgesinv ksesin qxuag_find_udag qxuageag evaopn2 qervwRow Procedure qerghFetch qervwFetch rwsfcd qerhjFetch qerjoFetch rwsfcd qerhjFetch rwsfcd qerhjFetch qerjoFetch qersoProcessULS qersoFetch opifch2 opifch opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main start

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.