“Exadata Performance Optimization”
Course Abstract
This three-day course focuses on optimizing the performance of the Oracle Exadata platform. Students will gain an understanding of the physical characteristics of the Exadata machine and what makes it different from a traditional Oracle environment. Key features of the Exadata machine will be illustrated via many hands-on labs. Students will learn how to monitor the database to determine if key Exadata specific optimizations are being utilized and how to encourage the database to use them when necessary. To ensure that students experience production-like activity, this course will be delivered using Enkitec’s in-house Exadata X2-2 environment with multi-terabyte databases.
What Students will Learn
- Exadata configurations and components
- How to find SQL statements which require optimization
- How to read SQL Execution Plans
- How to determine which Exadata features are being used (or not)
- How to reduce data volumes using Hybrid Columnar Compression
- How to use Exadata Smart Scan features
- How to use parallelism effectively
- How to use Exadata’s Smart Flash Cache
Course Prerequisites
Basic knowledge of Oracle SQL
Course Overview
- What is Exadata / Why is it different?
- Smart Scan feature overview
- Reading SQL execution plans
- Using Hybrid Columnar Compression
- Partitioning on Exadata
- Using parallelism effectively on Exadata
- Using Exadata Smart Flash Cache
- Staging and loading data
Exadata Course Differentiators
The key differentiators between Enkitec’s Exadata Course and other curriculums:
- Our course provides a deep view of Exadata, applying first-hand experience using the platform. The curriculum and courseware are packed with relevant, applicable client success stories. We’ve based the course on multiple implementations as opposed to listing a feature set.
- We’re hands-on experts in Exadata. The collective experience of Enkitec’s 60+ Exadata implementations is condensed into an educational offering that can’t be matched by other curriculums.
- The Enkitec Exadata course goes beyond just providing scripts to run. We teach the fundamentals of how to build Exadata-specific code, thus substantially increasing retention of the concepts.
- Other teaching models offer mostly lectures and PowerPoint presentations supplemented with minimal lab time using a simulation. Enkitec offers an intensive, collaborative hands-on experience using a real Exadata machine that is dedicated to the class. Through our collaborative process, students will come away knowing how to trouble-shoot SQL performance issues, whether on Exadata or not.
- Why do we focus on writing and trouble-shooting SQL code? The main features of the Exadata platform are enabled and disabled based on SQL code. Using the Exadata without training, you’ll see a 2X to 4X improvement rate – a fraction of Exadata’s power – without knowing how to fully exploit its unique features. As a result, you’ll forego the tremendous performance improvement potential. During the course, you’ll learn to fully utilize Exadata’s features and see how you can achieve a 10X – 100X performance improvement.
Price for 3-Day Course: $2,400 Per Student
Schedule for 2012 Q1 and Q2
All Classes are held at Enkitec Corporate Headquarters in Irving, Texas.
- February 27 – 29
- March 19 – 21
- April 23 – 25
- May 21 – 23
- June 18 – 20
For More Information & Registration
Mandy Mahand
mandy.mahand@enkitec.com
Office (972) 793-0562
Main (972) 607-3751
General questions? E-mail education@enkitec.com
