Oracle Database - PARALLEL_MAX_SERVERS parameter

> Database > Oracle Database

1 - 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:

Advertising

3 - 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.

4 - Documentation / Reference

db/oracle/parallel_max_servers.txt · Last modified: 2017/10/27 15:54 by gerardnico