Degree of Parallelism

The number of parallel execution servers associated with a single operation is known as the degree of parallelism (DOP). Parallel execution is designed to effectively use multiple CPUs. Oracle Database parallel execution framework enables you to either explicitly choose a specific degree of parallelism or to rely on Oracle Database to automatically control it.

This section contains the following topics:

• Manually Specifying the Degree of Parallelism

• Automatic Degree of Parallelism

• Controlling Automatic Degree of Parallelism

• In-Memory Parallel Execution

• Adaptive Parallelism

• Controlling Automatic DOP_ Parallel Statement Queuing_ and In-Memory Parallel Execution