Oracle Database - PARALLEL_MAX_SERVERS parameter

Card Puncher Data Processing

About

This parameter determines the maximum number of parallel servers that may be started for a database instance, should there be demand for them.

The default value on Oracle Database 10g and higher is:

<MATH> \text{PARALLEL MAX SERVERS} = 10 * \text{cpu count} * \text{parallels threads per cpu} </MATH>

where:

Rule of thumb

A good rule of thumb is to ensure parallel_max_servers is set to a number greater than : <MATH> \text{parallel_max_servers} > \text{maximum number of concurrent queries} * \text{maximum degree of parallelism need by a query} </MATH> where:

By doing this you will ensure every query gets the appropriate number of parallel servers.

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - PARALLEL_MIN_SERVERS parameter

This parameter determines the number of parallel servers that will be started during database startup. By default the value is 0. It is recommended that you set parallel_min_servers to: This will...
Card Puncher Data Processing
Oracle Database - PARALLEL_SERVERS_TARGET parameter

PARALLEL_SERVERS_TARGET is a initialization parameter that specifies the number of parallel server processes allowed to run parallel statements before statement queuing will be used. Where: ...
Card Puncher Data Processing
Oracle Database - PARALLEL_THREADS_PER_CPU Parameter

This parameter describes the number of parallel execution processes or threads that a CPU can handle during parallel execution. It is used to: calculate the default degree of parallelism for the...
Card Puncher Data Processing
Oracle Database - PGA_AGGREGATE_TARGET Parameter

PGA_AGGREGATE_TARGET is a database initialization parameter and controls the total amount of execution memory that can be allocated by Oracle for the Process global area (PGA) The Total Memory here refers...



Share this page:
Follow us:
Task Runner