My Oracle Support Banner

Why OOM (Out-Of-Memory) Is Raised When Executing Query On HeatWave; How To Avoid OOM; MY-011071; "RAPID Server out of memory during query execution" (Doc ID 3004401.1)

Last updated on JULY 22, 2024

Applies to:

HeatWave - Version N/A and later
Information in this document applies to any platform.

Symptoms

When you execute a very complex query on HeatWave, it may fail with the following error:

The error can be retrieved from the error_log performance schema table.

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
 Estimate number of HeatWave nodes properly
 Monitor memory usage
 Unload unnecessary tables
 Rewrite a query
 Add more HeatWave nodes
References


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