My Oracle Support Banner

Number of Preallocated Parallel Workers Are More Than Parallel_min_servers (Doc ID 2654231.1)

Last updated on JULY 15, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On database version 12.2, even after setting parallel_min_servers to a non-zero value, the number of preallocated workers are more than that value.

In other words, parallel_min_servers value seems not to be limiting the number of default parallel processes available on the database.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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