Oracle Database - PARALLEL_SERVERS_TARGET parameter

Card Puncher Data Processing

About

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.

Default value

4 * CPU COUNT * PARALLEL THREADS PER CPU * ACTIVE INSTANCE COUNT
Where:

Range of values: 0 to PARALLEL_MAX_SERVERS

Definition

When the parameter PARALLEL_DEGREE_POLICY is set to AUTO, Oracle will queue SQL statements that require parallel execution, if the necessary parallel server processes are not available. Statement queuing will begin once the number of parallel server processes active on the system is equal to or greater than PARALLEL_SERVER_TARGET.

By default, PARALLEL_SERVER_TARGET is set lower than the maximum number of parallel server processes allowed on the system (PARALLEL_MAX_SERVERS) to ensure each parallel statement will get all of the parallel server resources required and to prevent overloading the system with parallel server processes.

Note that all serial (non-parallel) statements will execute immediately even if statement queuing has been activated.

Documentation / Reference







Share this page:
Follow us:
Task Runner