Oracle Exadata Storage Server V2 Overview Seminar (for Sun DB Machine)

Course Description

This course introduces students to Oracle Exadata Storage Server Version 2 (Exadata). Students learn about the architecture and key capabilities of Exadata along with how to configure, monitor and optimize it. Students are introduced to various options for migrating to Exadata and learn how to select the best approach.The course focuses on the features and capabilities of the Sun Oracle Exadata Storage Server. The Sun Oracle Database Machine is also introduced. Although this course does not have hands-on labs, scripted demonstrations help students understand the concepts behind Exadata Storage Server.This course is based on Exadata Storage Version 2 on the Sun DB Machine.Learn To:Compare traditional storage solutions with Exadata storageThe key capabilities and features of ExadataConfigure and monitor ExadataMigrate to ExadataA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Skills Gained

• Identify the benefits of using Exadata for different application classes
• Describe the architecture of Exadata and its integration with Oracle Database
• Complete the initial configuration of Exadata
• Describe various recommended approaches for migrating to Exadata
• Configure Exadata I/O Resource Management
• Monitor Exadata health and optimize performance
• Adopt Exadata with greater confidence
• Describe the key capabilities of Exadata

Who Can Benefit

• Data Warehouse Administrator
• Database Administrators
• Database Designers
• Technical Administrator
• Technical Consultant

Prerequisites

• Generic Storage Administration

Syllabus

Introduction

Oracle Exadata Storage Server Overview

• Comparing Exadata with traditional storage servers
• Exadata capabilities and features including version 2 new features
• Exadata storage hardware overview (inc DB Machine overview)

Oracle Exadata Storage Server Architecture

• Exadata Process Architecture Details
• IORM Architecture Details
• Exadata Metrics and Alerts Overview
• Exadata Storage Realms Overview
• Exadata Storage Realms Implementation
• Storage Grid Entities and Relationships
• Disk Group Configuration

Oracle Exadata Storage Server Configuration and Administration

• Exadata installation and configuration overview
• Exadata administration
• Exadata maintenance

Oracle Exadata Storage Server and I/O Resource Management

• I/O Resource Manager Scenarios
• Database Users, Consumer Groups, Categories
• Managing I/O Resources
• Intradatabase/Interdatabase I/O Resource Management
• Enabling Intradatabase Resource Management
• Intradatabase Plan Example
• Enabling Multiple Databases’ I/O Management
• DB Plan Example Category Plan Example

Oracle Exadata Storage Server Performance Monitoring

• Performance Tuning and Monitoring Overview
• Monitoring Exadata Cells with Metrics
• Monitoring Exadata Cells with Alerts
• Monitoring Exadata Cells with Active Requests
• Monitoring through execution plans
• Monitoring Exadata Cells with Wait Events
• Monitoring Exadata Cells with Enterprise Manager

Oracle Exadata Storage Server Migration Overview

• Migration Process Overview
• Logical migration approaches
• Physical migration approaches