My Oracle Support Banner

Select With Hash Joins Fails With ORA-600 [733], [top uga heap] (Doc ID 800233.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

You may be running a SQL statement, and get an internal error similar to this:

ORA-00600: internal error code, arguments:[733], [268435104], [top uga heap]

The query will be using hash joins. If there is an explain plan in the trace file, this will contain rows with : HASH JOIN

You can make additional checks in the trace file if the stack contains qerhjFetch.
The call stack may look like the following:

ksmarfg kghgex kghfnd kghalo kghgex kghfnd kghalo kghgex kghfnd kghalo kghgex
kghfnd kghalo qerhjAllocHashTable qerhjBuildHashTable qerhjInnerProbeHashTable
kdstf0000101km kdsttgr qertbFetch qergiFetch rwsfcd qerhjFetch rwsfcd

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
  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.