Exadata and Database Machine Administration Workshop NEW: Duration
Exadata and Database Machine Administration Workshop NEW: Duration
Exadata and Database Machine Administration Workshop NEW: Duration
Duration: 3 Days
The second section introduces students to Oracle Exadata Database Machine. Students learn about the various
Database Machine configurations. The installation and configuration process is covered so that students are equipped to
make appropriate up-front configuration decisions. They also learn how to maintain, monitor and optimize Database
Machine after initial configuration. Students are introduced to various options for migrating to Database Machine and
learn how to select the best approach. Where possible, the topics are reinforced through the students participation in
structured hands-on lab exercises. There will also be some demonstrations included with the course.
Learn To:
Describe what is Exadata and how is it different from traditional database storage
List the key capabilities and features of Exadata and DBM
Configure DBM
Implement Exadata security
Maintain DBM and perform various maintenance tasks
Monitor DBM using alerts, thresholds, metrics, current activities, SQL plans, V$ views and database statistics
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification.
Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on
Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
Audience
Data Warehouse Administrator
Database Administrators
Database Designers
Technical Administrator
Prerequisites
Required Prerequisites
System and Storage Administration Concepts
Suggested Prerequisites
Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2
Oracle Database 11g: Administration Workshop I DBA Release 2
Oracle Database 11g: Administration Workshop II DBA Release 2
Oracle 11g: RAC and Grid Infrastructure Overview Seminar Release 2
Course Objectives
Describe the key capabilities of Exadata and Database Machine
Identify the benefits of using Database Machine for different application classes
Describe the architecture of Database Machine and its integration with Oracle Database, Clusterware and ASM
Complete the initial configuration of Database Machine
Describe various recommended approaches for migrating to Database Machine
Configure Exadata I/O Resource Management
Monitor Database Machine health and optimize performance
Course Topics
Introduction
Course Objectives
Audience and Prerequisites
Course Scope
Course Contents
Terminology
Additional Resources
Exadata Overview
Traditional Enterprise Database Storage Deployment
Exadata Storage Deployment & Exadata Implementation Architecture Overview
Introducing Exadata
Exadata Hardware Details (Sun Fire X4270 M2) & Exadata Specifications
InfiniBand Network
Classic Database I/O and SQL Processing Model
Exadata Smart Scan Model & Exadata Smart Storage Capabilities
Exadata Hybrid Columnar Compression Architecture Overview, Exadata Smart Flash Cache & Exadata Storage Index
Exadata Architecture
Exadata Software Architecture Overview
Exadata Software Architecture Details
Exadata Smart Flash Cache Architecture
Exadata Monitoring Architecture
Disk Storage Entities and Relationships
Interleaved Grid Disks
Flash Storage Entities and Relationships
Disk Group Configuration
Exadata Configuration
Exadata Installation and Configuration Overview
Initial Network Preparation
Configuration of New Exadata Servers