ORACLE EXADATA L3 Academic Traning

Course

Introduction

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

-

Exadata Database Machine Architecture

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

-

I/O Resource Management

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

-

Recommendations for Optimizing Database Performance

Flash Memory Usage
Influencing Caching Priorities
Choosing the Flash Cache Mode
Compression Usage
Index Usage
ASM Allocation Unit Size
Minimum Extent Size
Exadata Specific System Statistics
- - Labs on Flashdisk/HDD/Celldisk/Griddisk on real machine

-

Using Smart Scan

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

-

Consolidation Options and Recommendation

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

-

Migrating Databases to Exadata Database Machine

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

-

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

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

-

Monitoring Exadata Storage Servers

Exadata Metrics and Alerts Architecture
Monitoring Exadata Storage Server with Metrics and Alerts
Isolating Faults with
Monitoring Exadata Storage Server with Enterprise Manager: Overview
Monitoring Hardware Failure and Sensor State
Monitoring Exadata Storage Server Availability
Comparing Metrics Across Multiple Storage Servers
- - Labs on Monitoring Cell servers + Various Metrics etc

-

Backup and Recovery

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

-

Exadata Database Machine Maintenance Tasks

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

-

Patching Exadata Database Machine

Patching and Updating: Overview
Maintaining Exadata Storage Server Software
Maintaining Database Server Software
Assisted Patching Using OPlan
Assisted Patching Using
Maintaining Other Software
Recommended Patching Process
Test System Recommendations
Labs on Live Patch on-off/Rolling Patch+OPlan

-

ASR Installation and configuration