Advertisement

Parallel Execution

  • Steve Shaw
  • Martin Bach

Abstract

Parallel Execution is a feature of the Oracle Database that enables the division of certain database operations into multiple subtasks that operate simultaneously. The goal of this approach is to complete these tasks more quickly than if they were executed serially as a single task. Parallel Execution has the potential to improve performance and response times by harnessing more of a system's hardware resources (see Chapter 4 for more information on hardware resources) to complete the task at hand. Parallel Execution enables singe-instance environments by utilize more of a system's CPU cores, memory, and I/O in a single operation. However, Parallel Execution is particularly relevant to RAC because it enables operations to be processed beyond the resource capabilities of a single node, letting you leverage the CPU, memory, and I/O capability of the entire cluster (if desired) to complete a single operation.

Keywords

Parallel Execution Bloom Filter Execution Plan Statement Queuing Block Range 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Steve Shaw, Martin Bach 2010

Authors and Affiliations

  • Steve Shaw
  • Martin Bach

There are no affiliations available

Personalised recommendations