Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–2147483647 |
Status |
Dynamic |
Display level |
Basic |
Required role |
System Administrator |
number of worker processes specifies the maximum number of worker processes that Adaptive Server can use at any one time for all simultaneously running parallel queries combined.
Adaptive Server issues a warning message at start-up if there is insufficient memory to create the specified number of worker processes. memory per worker process controls the memory allocated to each worker process.
