Parallel Processing in Oracle Database 12c 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

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

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
  • 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
  • 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
  • Comparing statement queuing to minimal DOP guarantee
  • Setting parameters
  • When to choose statement queuing
  • Using Database Resource Manager with statement queuing
  • Viewing queued statements
  • 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
  • DataPump export / import
  • SQL*Loader
  • External tables: applying parallel execution as best practice
  • 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
  • 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
Live Online Training (Duration : 8 Hours) Fee On Request
Group Training Incl. Official Courseware
20 Jun GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too long. We can offer Comfort Track for 8 hours

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

Request More Information

Add Name and Email Address of participant (If different from you)