December 2002
Intermediate to advanced
928 pages
85h 29m
English
PARALLEL_MAX_SERVERS
Value: 0-3599
Default: derived
Specifies the maximum number of parallel query servers or parallel recovery processes for an instance. Oracle will increase the number of query servers to this value, as demand requires, from the number created at instance startup. If the value is too low, some queries may not have a query server available during query processing. If it is too high, memory resource shortages may occur during peak periods. Multiple instances must have the same value.