Oracle Database 11g: Parallel Execution Fundamentals

Course:  ORAPX11
Duration:  3 Days
Level:  II
Course Summary

This course will provide the Oracle DBA the skills and knowledge and a step-by-step guide to properly configure their Oracle 11g databases for Oracle SQL Parallel execution. Parallel execution is one of the fundamental database technologies that enable enterprises to manage and process terabytes of data in minutes or even less, not hours or days.

This course discusses the parallel execution architecture of Oracle Database 11g and shows its superiority over alternative architectures for real-world applications. It also gives insight into upgrading from earlier versions of Oracle. Plus while the focus is on Oracle11g, the fundamental concepts are still applicable to earlier versions of Oracle.

« Hide The Details
Topics Covered In This Course

Introduction

  • Fundamental Concepts of Parallel Processing
  • Best Practices Around Parallel Processing
  • Monitoring the Parallel Environment
  • Upgrade Considerations from Earlier Releases of Oracle

Why Parallel Execution

  • Oracle 11g Architecture Overview
  • The Ultimate Goal: Scalability
  • The Oracle Advantage
  • Lesson summary

Fundamental Concepts of Oracle Parallel Execution

  • Processing Parallel SQL Statements
  • Query Coordinator and Parallel Servers
  • Producer/Consumer Model
  • Granules
  • Data Redistribution
  • The ?Magic of Two?
  • Lesson Summary

Enabling Parallel Execution in Oracle11g

  • Controlling SQL Parallel Execution in Oracle
  • Understand Your Target Workload
  • Controlling the Degree of Parallelism
  • Controlling the Usage of Parallelism
  • Lesson Summary

Oracle SQL Parallel Execution Best Practices

  • Start With a Balanced System
  • Calibrate Your configuration
  • Stripe and Mirror Everything (SAME)
  • Set Database Init parameters for Good Performance
  • Memory Allocation
  • Controlling Parallel Servers
  • Enabling Efficient I/O Throughput
  • Use Parallel Execution with common Sense
  • Lesson Summary

Monitoring SQL Parallel Execution

  • Dynamic Views for Monitoring Parallel Performance
  • Enterprise Manager for Parallel Execution Monitoring
  • Interpreting Parallel SQL Execution Plans
  • Parallel Plan W/O Partitioning
  • Parallel Plans with Partitioning and Partition_Wise Join
  • Parallel Wait Events and I?O Monitoring
  • SQL Monitoring
  • Lesson Summary

Upgrade Considerations

  • More Parallel Operations
  • Upgrades from Oracle9i
  • Execution Plan Changes
  • Changes in Database Defaults
  • Oracle Resource Manager

Oracle Data Warehousing Tips

  • What Does a Data Warehouse Need
  • Why Use Oracle for the Data Warehouse
  • AWR and the Data Warehouse
  • Lesson Summary
Who Should Take This Course

Both database administrators and developers.

Recommended Prerequisites

Students should be experienced Oracle DBAs, with good knowledge of Oracle SQL.

« Hide The Details
Related Courses
Code Course Title Duration Level
OR11A1
Oracle Database 11g Administration I
5 Days
I
Details
OR11A2
Oracle Database 11g Administration II
5 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com