Parallel Processing in Oracle Database 12c

Parallel Processing in Oracle Database 12c Certification Training Course Overview

Parallel Processing in Oracle Database 12c training course enables the benefits of parallelizing requests in a 12c database & use features of parallel processing. Upon completion of this course, you will learn the benefits of parallelizing requests in an Oracle 12c database. You will also learn how to use features of parallel processing introduced in Oracle 11g Release 1 and 2.
 
Audience:
  • Database Administrator
  • Developer

Parallel Processing in Oracle Database 12c (8 Hours) Download Course Contents

Live Virtual Classroom
Group Training 600
18 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 700
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: 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
Module 2: 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
Module 3: 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
Module 4: 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
Module 5: 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
Module 6: Parallel Execution and Data Loading
  • DataPump export / import
  • SQL*Loader
  • External tables: applying parallel execution as best practice
Module 7: 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
Module 8: 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
Download Course Contents

Request More Information

Course Prerequisites
  • Oracle Database 12c: SQL Tuning for Developers Ed 1
  • Basic knowledge of database administration

After completion of this course; you will learn following:-

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