8 Using Parallel Execution

Parallel execution is the ability to apply multiple CPU and I/O resources to the execution of a single database operation. This chapter discusses tuning an Oracle Database in a parallel execution environment.

This chapter contains the following sections:

• Introduction to Parallel Execution

• How Parallel Execution Works

• Types of Parallelism

• Initializing and Tuning Parameters for Parallel Execution

• Tuning General Parameters for Parallel Execution

• Monitoring Parallel Execution Performance

• Miscellaneous Parallel Execution Tuning Tips