Oracle Exadata Database Machine: Implementation and Administration

COURSE OUTLINE

MODULE 01 Introduction

• Introduction
• Practice 1-1: Lab Environment:

MODULE 02 Exadata Database Machine: Overview

• Exadata Database Machine: Overview
• Exadata X8M Hardware
• Oracle Exadata Virtual Machines

MODULE 03 Exadata Database Machine Architecture

• Exadata Database Machine Architecture
• Exadata Software Architecture
• High Capacity Storage Server: Disk Storage Entities and Relationships
• Practice 3-1: Process Familiarization
• Practice 3-2: Exadata High Availability
• Practice 3-3: Storage Object Familiarization
• Practice 3-4: Exadata Smart Flash Cache Familiarization
• Practice 3-5: Exadata Smart PMEM Cache Familiarization

MODULE 04 Key Capabilities of Exadata Database Machine

• Key Capabilities of Exadata Database Machine
• Exadata Smart Flash Cache: Overview
• Exa fusion Direct-to-Wire Protocol
• Practice 4-1: Smart Scan Practice 4-2: Storage Index
• Practice 4-3: Exadata Hybrid Columnar Compression
• Practice 4-4: Exadata Smart Flash Cache and Smart PMEM Cache

MODULE 05 Exadata Database Machine Initial Configuration

• Exadata Database Machine Initial Configuration
• Exadata Hardware Installation: Overview
• Oracle Exadata Deployment Assistant (OEDA) CLI
• Practice 5-1: Using the Browser- Based Exadata Configuration Tool
• Practice 5-2: Using the OEDACLI Command to Add a Database Home

MODULE 06 Exadata Storage Server Configuration

• Exadata Storage Server Configuration
• Configuring Cell Disks
• Practice 6-1: Cell Configuration
• Practice 6-2: Storage Reconfiguration
• Practice 6-3: Consuming Grid Disks Using ASM
• Practice 6-4: Configuring Exadata Storage Security
• Practice 6-5: Exercising the Privileges Associated with Cell User Accounts
• Practice 6-6: Using the Distributed Command-Line Utility (dcli)

MODULE 07 1/0 Resource Management

• I/O Resource Management
• Flash Cache and Flash Log Resource Control

MODULE 08 Recommendations for Optimizing Database Performance

• Recommendations for Optimizing Database Performance
• Practice 8-1: Configuring Write Back Flash Cache
• Practice 8-2: Using Exadata Hybrid Columnar Compression
• Practice 8-3: Testing Index Elimination

MODULE 09 Using Smart Scan

• Using Smart Scan
• Practice 9-1: Monitoring Exadata Smart Scan
• Practice 9-2: Monitoring Cell Wait Events for Parallel Query

MODULE 10 Consolidation Options and Recommendations

• Consolidation Options and Recommendations

MODULE 11 Migrating Databases to Exadata Database Machine

• Migrating Databases to Exadata Database Machine
• Practice 11-1: Migrating to Exadata Using Transportable Tablespace

MODULE 12 Bulk Data Loading

• Bulk Data Loading
• Practice 12-1: Bulk Data Loading with Database Machine

MODULE 13 Exadata Database Machine Platform Monitoring: Introduction

• Exadata Database Machine Platform Monitoring: Introduction

MODULE 14 Monitoring Exadata System Software Components

• Monitoring Exadata System Software Components
• Monitoring PMEM Cache

MODULE 15 Configuring Enterprise Manager Cloud Control to Monitor Exadata Database Machine

• Configuring Enterprise Manager Cloud Control to Monitor Exadata Database Machine
• Practice 15-1: Deploying the Oracle Management Agent to Exadata Database Servers
• Practice 15-2: Preparing the Agent Hosts for Exadata Target Discovery
• Practice 15-3: Discovering the Database Machine System Components
• Practice 15-4: Discovering Oracle Grid Infrastructure and Oracle Database Software Components
• Practice 15-5: Configuring a Database Machine Services Dashboard
• Practice 15-6: Post-Discovery Configuration and Verification

MODULE 16 Monitoring Exadata Storage Servers

• Monitoring Exadata Storage Servers
• Monitoring Exadata Storage Server with Enterprise Manager: Overview
• Practice 16-1: Metrics, Alerts, and Active Requests
• Practice 16-2: Using Enterprise Manager to Monitor Exadata Storage Server
• Practice 16-3: Using Enterprise Manager Metrics and Monitoring Templates for Exadata Storage Server
• Practice 16-4: Using Enterprise Manager Thresholds, Alerts, and Incidents for Exadata Storage Server
• Practice 16-5: Using Enterprise Manager Configuration Management for Exadata Storage Server Server

MODULE 17 Monitoring Exadata Database Machine Database Servers

• Monitoring Exadata Database Machine Database Servers
• Practice 17-1: Monitoring Database Servers Using DBMCLI
• Practice 17-2: Exadata Compute Node Hardware Monitoring with Enterprise Manager
• Practice 17-3: Exadata Database Monitoring with Enterprise Manager

MODULE 18 Monitoring Other Exadata Database Machine Components

• Monitoring Other Exadata Database Machine Components
• Practice 18-1: Monitoring Ethernet Switches and PDUs by Using Enterprise Manager

MODULE 19 Other Useful Exadata Monitoring Tools

• Other Useful Exadata Monitoring Tools

MODULE 20 Backup and Recovery

• Backup and Recovery
• Practice 20-1: Backup Optimization
• Practice 20-2: Recovery Optimization

MODULE 21 Exadata Database Machine Maintenance Tasks

• Exadata Database Machine Maintenance Tasks

MODULE 22 Patching Exadata Database Machine

• Patching Exadata Database Machine

MODULE 23 Exadata Database Machine Automated Support Ecosystem

• Exadata Database Machine Automated Support Ecosystem