Number of Preallocated Parallel Workers Are More Than Parallel_min_servers
(Doc ID 2654231.1)
Last updated on MAY 19, 2022
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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