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 & Backup and Recovery Workshop	4 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 [email protected]