My Oracle Support Banner

Distributed Query Returns Different Results on Consecutive Runs when no Changes Exist in the Base Tables. (Doc ID 561471.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 to 11.1.0.6 [Release 8.1.5 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Distributed Queries can sometimes return different results in consecutive runs, even when the base tables have not changed during the query executions.
The problem can appear in normal queries, when using views, materialized views refresh or any other operations using distributed queries. They are all the result of the same cause.
This can appear as a bug at first look, but is actually the expected behavior.

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.