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 220.127.116.11.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.
Determining if Wrong Results on a query running on Exadata is a SmartScan (cell_offload_processing) or General Database Issue
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:-
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!