Parallel Query Runs in Serial ON RAC when parallel_instance_group is set to a Group that does not exist (Doc ID 2901017.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On RAC Database, Parallel queries are running in serial.


From PX trace file:

kkfdPaPrm: use table level hint DOP(4) on table
kkfdPaPrm:- The table : 18
kkfdPaPrm:DOP = 4 (computed from hint/dictionary/autodop)
kkfdiPaPrm: dop:4 serial(serial - DOP = 1 (PX not allowed): parallel_max_servers == 0 on all instances: current process is slave or: current process is background process or: single process or: PX not installed or: running in serializable mode
) flags: 1
kkfdtsc
       serial - DOP = 1 (from kkfdPaPrm()) or 10383 level 1 not set

Changes

Cause

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