Different parallel/serial plan choice with copies of the same database on different servers (Doc ID 1389664.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.5 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
PARAMETER:cpu_count
PARAMETER:parallel_threads_per_cpu

Symptoms

Two environments with identical objects, stats, and parameters (such as a UAT and production database where the former is cloned from the latter) are producing different plans, parallel in one environment and serial in another.  The environments differ in the number of CPUs installed on each server.

Changes

The number of CPUs installed/available in the servers are different.

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