Module 1: Introduction

• Terminology
• Introducing the Laboratory Environment
• Additional Resources
• Course Objectives
• Course Contents
• Audience and Prerequisites

Module 2: Exadata Database Machine Overview

• InfiniBand Network
• Introducing Exadata Storage Server
• Introducing Database Machine
• Exadata Storage Expansion Racks
• Exadata Storage Server Features: Overview
• Database Machine Support: Overview
• Exadata Storage Server Architecture: Overview

Module 3: Exadata Database Machine Architecture

• InfiniBand Network Architecture
• Disk Storage Entities and Relationships
• Interconnecting Multiple Racks
• InfiniBand Network Topology
• Database Machine Architecture: Overview
• Database Machine Network Architecture
• Database Machine Software Architecture: Overview

Module 4: Key Capabilities of Exadata Database Machine

• Exadata Smart Scan Model
• Exadata Hybrid Columnar Compression
• Exadata Smart Flash Cache
• I/O Resource Management
• Exadata Smart Storage Capabilities
• Database File System
• Exadata Storage Index
• Classic Database I/O and SQL Processing Model

Module 5: Exadata Database Machine Initial Configuration

• Choosing the Right Disk Redundancy Setting
• Configuring Oracle Exadata Database Machine
• Supported Additional Configuration Activities
• The Result After Installation and Configuration
• Using Oracle Exadata Deployment Assistant
• Database Machine Site Preparation
• Database Machine Implementation: Overview

Module 6: Exadata Storage Server Configuration

• Reconfiguring Exadata Storage
• Testing Storage Server Performance Using CALIBRATE
• Configuring the Exadata Cell Server Software
• Exadata Storage Server Administration: Overview
• Starting and Stopping Exadata Cell Server Software
• Configuring ASM and Database Instances to Access Exadata Cells
• Exadata Storage Security Implementation
• Configuring Cell Disks and Grid Disks

Module 7: I/O Resource Management

• Enabling Intradatabase Resource Management
• Interdatabase Plans and Database Roles
• Using Database I/O Metrics
• IORM and Exadata Storage Server Flash Memory
• IORM Architecture
• I/O Resource Management Concepts
• Setting Database I/O Utilization Limits
• Getting Started with IORM

Module 8: Recommendations for Optimizing Database Performance

• Index Usage
• ASM Allocation Unit Size
• Compression Usage
• Exadata Specific System Statistics
• Influencing Caching Priorities
• Choosing the Flash Cache Mode
• Minimum Extent Size
• Flash Memory Usage

Module 9: Using Smart Scan

• Exadata Smart Scan: Overview
• Smart Scan Join Processing with Bloom Filters
• Monitoring Smart Scan in SQL Execution Plans
• Exadata Storage Server Wait Events: Overview
• Smart Scan Requirements
• Other Situations Affecting Smart Scan
• Exadata Storage Server Statistics: Overview

Module 10: Consolidation Options and Recommendation

• Different Consolidation Types
• Alternative Storage Configurations
• Recommended Storage Configuration for Consolidation
• Isolating Management Roles
• Consolidation: Overview
• Schema Consolidation Recommendations
• Maintenance Considerations
• Cluster Configuration Options

Module 11: Migrating Databases to Exadata Database Machine

• Logical Migration Approaches
• Physical Migration Approaches
• Database Machine Migration Considerations
• Choosing the Right Migration Path
• Performing Capacity Planning
• Migration Best Practices: Overview
• Migrating to Database Machine Using Transportable Tablespaces
• Post-Migration Best Practices

Module 12: Bulk Data Loading using Oracle DBFS

• Configuring the Staging Area
• Configuring the Target Database
• Loading the Target Database
• Bulk Data Loading Using Oracle DBFS: Overview
• Preparing the Data Files
• Staging the Data Files

Module 13: Exadata Database Machine Platform Monitoring Introduction

• Simple Network Management Protocol (SNMP)
• Intelligent Platform Management Interface (IPMI)
• Exadata Storage Server Metrics, Thresholds, and Alerts
• Enterprise Manager Cloud Control 12c
• Integrated Lights Out Manager (ILOM)
• Automatic Diagnostic Repository (ADR)
• Monitoring Technologies and Standards
• Enterprise Manager Database Control

Module 14: Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine

• Discovering Exadata Database Machine
• Discovering Additional Targets
• Enterprise Manager Cloud Control 12c Architecture: Overview
• Configuring Cloud Control to Monitor Exadata Database Machine
• Post-discovery Configuration and Verification
• Cloud Control Monitoring Architecture for Exadata Database Machine
• Pre-discovery Configuration and Verification
• Deploying the Oracle Management Agent

Module 15: Monitoring Exadata Storage Servers

• Isolating Faults with
• Monitoring Exadata Storage Server Availability
• Comparing Metrics Across Multiple Storage Servers
• Monitoring Exadata Storage Server with Metrics and Alerts
• Monitoring Exadata Storage Server with Enterprise Manager: Overview
• Monitoring Hardware Failure and Sensor State
• Exadata Metrics and Alerts Architecture

Module 16: Monitoring Exadata Database Machine Database Servers

• Monitoring Hardware
• Monitoring the Operating System
• Monitoring Oracle Grid Infrastructure
• Monitoring Oracle Management Agent
• Monitoring Database Servers: Overview
• Monitoring Oracle Database
• Database Monitoring with Enterprise Manager Cloud Control 12c

Module 17: Monitoring the InfiniBand Network

• InfiniBand Network Monitoring with
• Monitoring the InfiniBand Switches
• Monitoring the InfiniBand Fabric:
• Monitoring the InfiniBand Switch Ports
• InfiniBand Network Monitoring: Overview
• Monitoring the InfiniBand Ports

Module 18: Monitoring Other Exadata Database Machine Components

• Monitoring the Cisco Ethernet Switch
• Monitoring the KVM Switch
• Monitoring the Sun Power Distribution Units

Module 19: Other Useful Monitoring Tools

• Running Exachk
• OSWatcher: Overview
• DiagTools: Overview
• Exachk Daemon
• Imagehistory: Overview
• Exachk: Overview
• Imageinfo: Overview
• Using ADRCI on Exadata Storage Servers

Module 20: Backup and Recovery

• Using RMAN with Database Machine
• General Recommendations for RMAN
• Tape-Based Backup Strategy
• Tape-Based Backup Architecture and Recommendations
• Disk-Based Backup Strategy
• Disk-Based Backup Recommendations
• Disk-Based Backup on
• Backup and Recovery of Database Machine Software

Module 21: Exadata Database Machine Maintenance Tasks

• Powering Database Machine Off and On
• Replacing a Damaged Flash Card
• Safely Shutting Down a Single Exadata Storage Server
• Moving All Disks from One Cell to Another
• Using the Exadata Cell Software Rescue Procedure
• Replacing a Damaged Physical Disk
• Database Machine Maintenance: Overview

Module 22: Exadata Database Machine: Patching, Automated Support Ecosystem & Cloud Service Overview

• Service Architecture & Availability
• Introducing Exadata Cloud Service
• Simple Web-Based Provisioning & Management
• Migrating to Exadata Cloud Service
• Service Configuration Options & Service Connection Options
• REST APIs
• Storage Configuration & Management Details
• Management Responsibilities