Wrong Results From a Parallel Query And Star_transformation_enabled=True (Doc ID 784540.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.4

Symptoms

The result set multiplied by the number of parallel degree that was set on the table.
For instance, the table is parallel (degree 4), results are multiplied by 4.When noparallel, results are correct.

Cause

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 hundreds of Community platforms