Parallel execution is the ability to apply multiple CPU and I/O resources to the execution of a single SQL statement by using multiple processes.

This chapter explains how parallel execution works, and how to control, manage, and monitor parallel execution in the Oracle Database.

This chapter contains the following sections:

• Parallel Execution Concepts

• Setting the Degree of Parallelism

• In-Memory Parallel Execution

• Parallel Statement Queuing

• Types of Parallelism

• About Initializing and Tuning Parameters for Parallel Execution

• Monitoring Parallel Execution Performance

• Tips for Tuning Parallel Execution