This course introduces you to the Oracle Exadata Database Machine. You'll learn about the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server.
Data Warehouse Administrator
List the key capabilities and features of Exadata Database Machine and Exadata Storage Server.
Initially configure Exadata Database Machine.
Implement Exadata Storage Server security.
Use query execution plans, statistics and wait events to examine Exadata Smart Scan.
Describe various options and best-practice recommendations for consolidation on Exadata Database Machine.
Describe what Exadata is and how it's different from traditional database storage.
Maintain, monitor and optimize Database Machine after initial configuration.
Installation & Configuration Process
The installation and initial configuration process is covered so you're equipped to make appropriate up-front configuration decisions. You'll be introduced to various options for migrating to Database Machine; you'll then learn how to select the best approach.
Monitoring Exadata Database Machine
This course will also teach you about monitoring the Exadata Database Machine. Learn about the monitoring infrastructure inherently within Exadata Database Machine, along with the monitoring capabilities exposed through Enterprise Manager Grid Control and associated plugins.
Best Practice Recommendations
Best-practice recommendations are highlighted throughout this course. Where possible, topics are reinforced through participation in structured, hands-on lab exercises. Exadata monitoring topics are covered using demos, along with a series of recorded demonstrations.
Data Warehouse Administrator
Describe the architecture of Database Machine and its integration with Oracle Database, Clusterware and ASM
Complete the initial configuration of Database Machine
Describe the key capabilities of Exadata and Database Machine
Describe various recommended approaches for migrating to Database Machine
Identify the benefits of using Database Machine for different application classes
Monitor Database Machine health and optimize performance
Configure Exadata I/O Resource Management
Oracle Database Administrator
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II Release 2
Oracle Database 11g: Introduction to SQL
Audience and Prerequisites
Introducing the Laboratory Environment
Exadata Database Machine Overview
Introducing Database Machine
Introducing Exadata Storage Server
Exadata Storage Server Architecture: Overview
Exadata Storage Server Features: Overview
Database Machine Capacity
Exadata Storage Expansion Racks
Database Machine Support: Overview
Exadata Database Machine Architecture
Database Machine Architecture: Overview
Database Machine Network Architecture
InfiniBand Network Architecture
X2-2 Full Rack Leaf Switch Topology
Spine and Leaf Topology
Scale Performance and Capacity
Database Machine Software Architecture: Overview
Disk Storage Entities and Relationships
Key Capabilities of Exadata Database Machine
Classic Database I/O and SQL Processing Model
Exadata Smart Scan Model
Exadata Smart Storage Capabilities
Exadata Hybrid Columnar Compression Data Organization
Exadata Smart Flash Cache Intelligent Caching
Storage Index with Partitions
Database File System
I/O Resource Management: Overview
Exadata Database Machine Initial Configuration
Database Machine Implementation: Overview
Choosing the Right Protection Level
Oracle Enterprise Manager Grid Control Configuration
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.