1.245 PARALLEL_MIN_DEGREE

PARALLEL_MIN_DEGREE controls the minimum degree of parallelism computed by automatic degree of parallelism.

Property Description

Parameter type

String

Syntax

PARALLEL_MIN_DEGREE = [ n | CPU ]

Default value

1

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

A different value can be set on different instances.

The value of PARALLEL_MIN_DEGREE is either a number that corresponds to the lower bound on the degree of parallelism computed by automatic degree of parallelism, or the string value CPU, which is computed by the function CPU_COUNT * PARALLEL_THREADS_PER_CPU.

The default value of PARALLEL_MIN_DEGREE is 1.

Note:

PARALLEL_MIN_DEGREE has no impact in either of these cases:

  • When the value of PARALLEL_MIN_DEGREE is greater than the value of CPU_COUNT

  • When the object is Oracle-owned, such as a dictionary table or view created on a dictionary table

Note:

This parameter is available starting with Oracle Database 18c.

See Also: