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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!