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 220.127.116.11 to 18.104.22.168 [Release 12.2]
Information in this document applies to any platform.
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.
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