Number of Preallocated Parallel Workers Are More Than Parallel_min_servers
(Doc ID 2654231.1)
Last updated on JULY 22, 2024
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 |