19c: Duplicate PQ workers created at instance level
(Doc ID 2719466.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
This is a 6 node RAC on Exadata. There are many duplicated PQ worker processes with the same process name, the one with most processes is
$ ps -ef|grep <db_name> |grep p0|wc
258 2083 17560
$ ps -ef|grep ora_p00e_<instance_name1> |grep -v grep |wc
79 632 5293
Because of this PQ query keeps getting downgraded to serial on instance 1.
There are many duplicate PQ processes on node 1. Because of this a job with parallel hint of 64 kept downgraded to serial on inst 1 due to no available PQ process, but there isn't other SQL using PQ at that time.
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