My Oracle Support Banner

How to Determine if Wrong Results on Exadata is a SmartScan (cell _offload_processing) or General Database Issue (Doc ID 2681169.1)

Last updated on JUNE 16, 2020

Applies to:

Oracle Exadata Storage Server Software - Version 11.2.1.2.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

Determining if Wrong Results on a query running on Exadata is a SmartScan (cell_offload_processing) or General Database Issue

PLEASE NOTE:


1. "Wrong Result" is generally defined as a statement which should return a particular set of rows but does not.
Receiving an error from a SQL statement may not be the desirable result, but it is not "Wrong Results".
The error indicates that the statement has not completed successfully as opposed to it completing and not returning the desired rows.

2. The actual order in which data is presented is NOT "Wrong Results' .
Oracle conforms to the SQL STANDARD which states that only columns which have an explicit ORDER BY instruction are guaranteed to be correctly and consistently ordered.
This is also documented in the SQL Reference Manual:-

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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