ORA-00600 [kghGetHpSz1] When Submitting A Select Statement (Doc ID 804527.1)

Last updated on JUNE 16, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms


The error ORA-00600 [kghGetHpSz1] reported in alert log when

1. CTAS / select query contains cube operator in group by clause.
2. Total number of group by operands are more than 32.
3. Stack trace contains row source of qerep* functions

The call stack may look like this:


kghnerror kgh_heap_sizes kxsDump1 kxsDump kxsDumpCursor kxsDumpCursors
curdmp ksudps ksedmp ssexhd qesaSimpleAggNonDis
qergsRowP qerepRop qergsFetch qerepFetch qergsFetch rwsfcd
qerltFetch ctcdrv opiexe opiosq0 kpooprx kpoal8

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms