• Understand Oracle Exadata architecture and key capabilities.
• Configure Exadata Database Machine and Storage Servers.
• Manage I/O Resource Management and storage resources.
• Optimize database performance using Exadata capabilities.
• Use Smart Scan, Smart Flash Cache, and Storage Indexes.
• Migrate databases and perform bulk data loading.
• Monitor Exadata components and database servers.
• Perform backup, recovery, maintenance, and patching.
• Configure Exadata for automated support and diagnostics.

Module 1: Introduction

• Course objectives
• Course overview
• Audience and prerequisites
• Exadata terminology
• Course resources
• Introduction to the laboratory environment

Module 2: Exadata Database Machine: Overview

• Exadata Database Machine overview
• Exadata Storage Server
• Storage Server architecture
• Storage Server features
• Exadata Expansion Racks
• InfiniBand network
• Database Machine support

Module 3: Exadata Database Machine Architecture

• Database Machine architecture
• Database Machine network architecture
• InfiniBand network architecture
• InfiniBand topology
• Interconnecting multiple racks
• Database Machine software architecture
• Disk storage entities and relationships
• Integration with Oracle Database, ASM, and Clusterware

Module 4: Key Capabilities of Exadata Database Machine

• Traditional database I/O and SQL processing
• Exadata Smart Scan
• Exadata Smart Storage
• Hybrid Columnar Compression
• Smart Flash Cache
• Storage Index
• Database File System
• I/O Resource Management

Module 5: Exadata Database Machine Initial Configuration

• Database Machine implementation
• Site preparation
• Oracle Exadata Deployment Assistant
• Disk redundancy options
• Database Machine configuration
• Post-installation configuration
• Supported additional configuration activities

Module 6: Exadata Storage Server Configuration

• Storage Server administration
• Storage Server performance testing
• CALIBRATE
• Exadata Cell Server software
• Starting and stopping Cell Server software
• Cell Disks
• Grid Disks
• Configuring ASM and database access
• Reconfiguring Exadata storage
• Exadata Storage Server security

Module 7: I/O Resource Management

• I/O Resource Management concepts
• IORM architecture
• Getting started with IORM
• Intradatabase resource management
• Database I/O utilization limits
• Interdatabase plans
• Database roles
• Database I/O metrics
• IORM and Exadata Flash Memory

Module 8: Recommendations for Optimizing Database Performance

• Flash memory usage
• Caching priorities
• Flash Cache modes
• Compression
• Index usage
• ASM allocation unit size
• Minimum extent size
• Exadata-specific system statistics

Module 9: Using Smart Scan

• Smart Scan overview
• Smart Scan requirements
• Smart Scan in SQL execution plans
• Bloom filters and Smart Scan join processing
• Factors affecting Smart Scan
• Exadata Storage Server statistics
• Exadata Storage Server wait events

Module 10: Consolidation Options and Recommendations

• Database consolidation concepts
• Consolidation types
• Recommended storage configurations
• Alternative storage configurations
• Cluster configuration options
• Management role isolation
• Schema consolidation
• Maintenance considerations

Module 11: Migrating Databases to Exadata Database Machine

• Migration best practices
• Capacity planning
• Migration considerations
• Selecting migration paths
• Logical migration approaches
• Physical migration approaches
• Post-migration best practices
• Transportable Tablespaces migration

Module 12: Bulk Data Loading

• Bulk data loading with Oracle DBFS
• Preparing data files
• Staging data files
• Configuring the staging area
• Configuring the target database
• Loading the target database

Module 13: Exadata Database Machine Platform Monitoring: Introduction

• Monitoring technologies and standards
• SNMP
• IPMI
• ILOM
• Exadata Storage Server metrics
• Thresholds and alerts
• Automatic Diagnostic Repository
• Enterprise Manager Cloud Control
• Enterprise Manager Database Control

Module 14: Monitoring Exadata System Software Components

• Monitoring Exadata system software
• Exadata system metrics
• System health monitoring
• Software component monitoring
• Identifying system issues

Module 15: Configuring Enterprise Manager Cloud Control to Monitor Exadata Database Machine

• Enterprise Manager Cloud Control architecture
• Exadata monitoring architecture
• Cloud Control configuration
• Pre-discovery configuration
• Management Agent deployment
• Exadata Database Machine discovery
• Additional target discovery
• Post-discovery configuration and verification

Module 16: Monitoring Exadata Storage Servers

• Exadata metrics and alerts architecture
• Storage Server metrics
• Storage Server alerts
• Fault isolation
• Hardware failure monitoring
• Sensor-state monitoring
• Storage Server availability
• Comparing metrics across Storage Servers

Module 17: Monitoring Exadata Database Machine Database Servers

• Database Server monitoring
• Hardware monitoring
• Operating system monitoring
• Oracle Grid Infrastructure monitoring
• Oracle Database monitoring
• Oracle Management Agent monitoring
• Database monitoring through Enterprise Manager Cloud Control

Module 18: Monitoring Other Exadata Database Machine Components

• Monitoring Ethernet switches
• Monitoring Power Distribution Units
• Monitoring KVM switches
• Enterprise Manager monitoring of additional components

Module 19: Other Useful Exadata Monitoring Tools

• Exachk
• Running Exachk
• Exachk daemon
• DiagTools
• ADRCI on Exadata Storage Servers
• Image information
• Image history
• OSWatcher

Module 20: Backup and Recovery

• RMAN with Exadata Database Machine
• RMAN recommendations
• Disk-based backup strategy
• Disk-based backup recommendations
• Tape-based backup strategy
• Tape-based backup architecture
• Backup and recovery of Database Machine software

Module 21: Exadata Database Machine Maintenance Tasks

• Exadata maintenance overview
• Powering the Database Machine off and on
• Safely shutting down an Exadata Storage Server
• Replacing a damaged physical disk
• Replacing a damaged Flash Card
• Moving disks between cells
• Exadata Cell software rescue procedures

Module 22: Patching Exadata Database Machine

• Patching and updating overview
• Maintaining Exadata Storage Server software
• Maintaining database server software
• Assisted patching with OPlan
• Maintaining other software
• Recommended patching process
• Test-system recommendations

Module 23: Exadata Database Machine Automated Support Ecosystem

• Automated support capabilities
• Exadata support ecosystem
• Automated diagnostics
• Support and serviceability considerations

5 Days

• Become familiar with the Exadata laboratory environment.
• Use the Oracle Exadata Deployment Assistant.
• Explore Exadata processes and architecture.
• Examine Exadata high-availability features.
• Work with Exadata storage objects.
• Explore Smart Flash Cache.
• Test Exadata Smart Scan.
• Examine Hybrid Columnar Compression.
• Configure and analyze Smart Flash Cache.
• Examine Storage Index behavior.
• Configure Exadata Storage Servers.
• Work with Cell Disks and Grid Disks.
• Configure storage access for ASM and database instances.
• Configure I/O Resource Management.
• Create and manage IORM plans.
• Configure database I/O utilization limits.
• Analyze Exadata performance statistics.
• Examine SQL execution plans and Smart Scan statistics.
• Perform Exadata database migration activities.
• Perform bulk data loading using DBFS.
• Monitor Exadata system components.
• Configure Enterprise Manager Cloud Control for Exadata.
• Discover Exadata Database Machine targets.
• Monitor Exadata Storage Servers.
• Monitor Exadata database servers using DBMCLI.
• Monitor compute-node hardware with Enterprise Manager.
• Monitor Oracle databases through Enterprise Manager.
• Monitor Ethernet switches and PDUs.
• Run Exachk and review diagnostic information.
• Perform backup optimization.
• Perform recovery optimization.

• Certification: Oracle Exadata Database Machine X9M Implementation Essentials
• Exam Code: 1Z0-902
• Certification Type: Oracle Certified Implementation Specialist
• Exam Format: Multiple-choice
• Duration: 90 minutes
• Questions: 60

• Oracle Database Administrators
• Exadata Database Administrators
• Data Warehouse Administrators
• Database Architects
• System Administrators
• Technical Consultants
• IT professionals responsible for Exadata implementation and operations

• Experience with Oracle Database administration.
• Knowledge of Oracle Grid Infrastructure, ASM, and RAC.
• Familiarity with Linux system administration.
• Basic understanding of networking and storage concepts.