Parallel Processing in Oracle Database 12c (D87438) – Outline

Detailed Course Outline

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