My Oracle Support Banner

Troubleshoot Heatwave Query (Doc ID 2771816.1)

Last updated on APRIL 26, 2021

Applies to:

MySQL Database Service - Version N/A to N/A
Information in this document applies to any platform.

Purpose

 Troubleshoot Heatwave queries

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Common Reasons queries are not offloaded
 Check if involved tables are loaded into Heatwave
 Check for Heatwave Offload Errors
 Check EXPLAIN on query
 Check query execution with use_secondary_engine set
 Diagnostic Data to collect for support

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