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:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
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
serial - DOP = 1 (from kkfdPaPrm()) or 10383 level 1 not set
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