My Oracle Support Banner

19c: Duplicate PQ workers created at instance level (Doc ID 2719466.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 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

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