My Oracle Support Banner

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: to
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!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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