Расписание курсов


Parallel Processing in Oracle Database 11g

  • Код курса: 11gPP
  • Длительность: 1 д.
  • Цена: 22 350 Р

What you will learn:

After completing this seminar, students should understand the benefits of parallelizing requests in an Oracle 11g
database, and should be able to use features of parallel processing in Oracle 11g Release 1 and 2. Using lecture and
recorded demonstrations, students learn why and when parallel processing is relevant and effective. The seminar shows
how to use, control and manage parallelization. Some specific configurations such as RAC database and Database
Machine are also reviewed in the seminar.

Learn To:

  • Optimize SQL statement execution using parallel processing
  • Use parallel processing appropriately to derive a benefit over serial processing
  • Control the use of parallel processing
  • Use a variety of features for parallelizing statements
  • Read execution plans of parallelized statements
  • Troubleshoot different issues associated with parallel processing
  • A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any
  • time. Registered students must view the class from the country listed in the registration form. Unauthorized recording,
  • copying, or transmission of LVC content may not be made.


  • Application Developers
  • Data Warehouse Administrator
  • Database Administrators
  • Developer


  • Required Prerequisites
  • Knowledge of database administration
  • Suggested Prerequisites
  • Oracle Database 11g: SQL Tuning Workshop Release 2
  • Oracle Database 11g: Administration Workshop I DBA Release 2

Course Objectives

  • Use new Oracle 11g, Release 2 parallel processing features including Auto DOP, statement-queuing, and in-memory parallel execution
  • List the SQL statements and data loading utilities that can benefit from parallel processing
  • Explain the basic concepts and theory associated with parallel execution
  • Use a variety of parallel execution features with different SQL statements
  • Read and evaluate execution plans for parallelized statements
  • Examine specific configurations such as RAC database to and Database Machine with parallel execution
  • Troubleshoot parallel processing issues such as no parallel execution, unexpected DOP, or performance decrease
  • Trace parallel execution to provide information to Oracle customer support
  • Use Database Resource Manager to complement the control of parallel processing usage
  • Define why and when to use parallel processing

Course Topics

Parallel execution concepts

  • Benefits of parallel processing
  • When to use parallel processing?
  • Query Coordinator and parallel execution (PX) servers
  • Parallel execution communication
  • The producer / consumer model
  • Execution plan basics

Using Manual DOP

  • Statements that can be parallelized
  • SELECT with single parallel table scan and the explain plan
  • SELECT with parallel hash join and the explain plan
  • Parallelized SELECT with partition wise join and the advantages
  • Parallelized DML operations

Using Auto DOP

  • Auto DOP versus manual DOP
  • Auto DOP parameters
  • Auto DOP behavior
  • Impact of Auto DOP on other parameters
  • SELECT explain plan with Auto DOP
  • Auto DOP in RAC environment

Using Statement Queuing

  • Comparing statement queuing to minimal DOP guarantee
  • Setting parameters
  • When to choose statement queuing
  • Using Database Resource Manager with statement queuing
  • Viewing queued statements

In-Memory Parallel Execution

  • The goal of In-Memory Parallel Execution
  • How SELECT works with and without in-memory parallel execution
  • Set parameters to use In-Memory parallel execution
  • In-memory PX examples

Parallel Execution and Data Loading

  • DataPump export / import
  • SQL*Loader
  • External tables: applying parallel execution as best practice

Troubleshoot situations when parallel processing does not proceed as desired

  • When parallel processing does not proceed as desired
  • When no parallel processing occurs
  • When Auto DOP computes unexpected DOP
  • When Statement Queuing starts unexpectedly
  • When performance decreases due to parallel execution
  • Tracing parallel execution

Managing a Mixed Workload with DBRM

  • Take advantage of DBRM to manage concurrent parallel executions with mixed workloads
  • Use plan directives to manage concurrent parallel executions
  • How to reject queries
  • Using dynamic switching
  • Understanding how directives interact


Записаться на курс: Parallel Processing in Oracle Database 11g

Отправьте другу или начальнику ссылку на почту
Заявка на обучение

Заявка на обучение

Записаться на курс:



Добавить в корзину