ORA-00600 [kghGetHpSz1] When Submitting A Select Statement
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.
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
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