Name
PARALLEL_MAX_SERVERS
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
