Oracle Exadata Training – Intro

Oracle Exadata is software and hardware engineered together to provide the highest-performing and most-available platform for running Oracle Database. Exadata is a modern architecture featuring scale-out industry-standard database servers, scale-out intelligent storage servers, state-of-the art PCI flash storage servers and an extremely high speed InfiniBand internal fabric that connects all servers and storage. Exadata runs all types of database workload including Online Transaction Processing (OLTP), Data Warehousing (DW), In-Memory Analytics and consolidation of mixed workload and is the ideal foundation for a consolidated database cloud.

Download Brochure

What you will learn in Oracle Exadata Training?

This Exadata Database Machine Administration Workshop training (in short Oracle Exadata Training) introduces you to Oracle Exadata Database Machine. You’ll learn about the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server.

Training Highlights

  • Training by hands-on, real time Exadata expert who has trained more than 450+ batches on various Oracle Technologies
  • In-depth coverage and thorough explanation of all the course topics
  • Hands-on sessions with real world examples and scenarios
  • 1:1 dedicated systems for lab practice
  • Oracle Exadata Training materials and online resources for additional reading
  • Guidance on Oracle certifications
  • Assistance on resume preparation
  • 100% Placement assistance by full-fledged in-house placement cell

Who can attend?

  • Database Administrators
  • Sales Consultants
  • System Administrator
  • Technical Administrator
  • Technical Consultant

Suggested Pre-requisites

  • Basic knowledge of Unix/Linux
  • Oracle DBA
  • Oracle ASM
1. Introduction

  • Course Objectives
  • Prerequisites
  • Course Contents
  • Terminology
  • Introducing the Laboratory Environment
2. Exadata Database Machine Overview

  • Introducing Database Machine
  • Introducing Exadata Storage Server
  • Exadata Storage Server Architecture: Overview
  • Exadata Storage Server Features: Overview
  • Exadata Storage Expansion Racks
  • InfiniBand Network
  • Database Machine Support: Overview
3. 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
4. Key Capabilities of Exadata Database Machine 

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

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

  • Exadata Storage Server Administration: Overview
  • Testing Storage Server Performance Using CALIBRATE
  • Configuring the Exadata Cell Server Software
  • Starting and Stopping Exadata Cell Server Software
  • Configuring Cell Disks and Grid Disks
  • Configuring ASM and Database Instances to Access Exadata Cells
  • Reconfiguring Exadata Storage
  • Exadata Storage Security Implementation
7. 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
8. 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
 9. 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
10. 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
11. 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 Table-spaces
12. Bulk Data Loading using Oracle DBFS

  • Bulk Data Loading Using Oracle DBFS: Overview
  • Preparing the Data Files
  • Staging the Data Files
  • Configuring the Staging Area
  • Configuring the Target Database
  • Loading the Target Database
13. Exadata Database Machine Platform Monitoring Introduction

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

  • Exadata Metrics and Alerts Architecture
  • Monitoring Exadata Storage Server with Metrics and Alerts
  • Listing Metric definition and current metrics
  • Listing Alert history
  • Listing & setting thresholds
15. Other Useful Monitoring Tools

  • Exachk: Overview
  • Running Exachk
  • Exachk Daemon
  • DiagTools: Overview
  • Using ADRCI on Exadata Storage Servers
  • Imageinfo: Overview
  • Imagehistory: Overview
  • OSWatcher: Overview
16. 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
17. 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
18. 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

UCLID IT School is the pioneer in Oracle Exadata Training.  At UCLID, you are assured to get pure and clean training on Oracle Exadata, handing by Mr. Muralidhar who is huge corporate experienced in Oracle Exadata. We have mastered the art of teaching Oracle DBA and changed many lives for good.  At UCLID, we follow an easy, simple and no-nonsense approach towards making you a master in Oracle DBA.

With it’s enviable & impeccable track record of training and placing thousands of students as Oracle DBAs in many IT organizations, Uclid has the following unique advantages:

  • Training by former employees of Oracle India and real time IT professionals from various top IT firms
  • Training on Real Time scenarios and case studies
  • Most in-depth and comprehensive training on every topic of the course
  • Well structured Training Material for future reference
  • Training on Latest Versions – Oracle 12c
  • Individual attention and group discussions for Interview preperation
  • Dedicated systems for Lab practice supported by qualified Lab Administrators and UPS for power backup
  • Unlimited Lab Access till you get job
  • 100% Placement Assistance backed by many top IT organizations (around 16 Top IT companies hire fresher DBAs from Uclid)
  • 100% Satisfaction guarenteed

The course Instructor, Muralidhar Punyala, was the practice manager for Oracle Exadata at Oracle India. He is an expert DBA with 20 years of extensive and in-depth experience in Database Planning, Design, Implementations, Performance Tuning, High Availability, Scalability, Database Security, Data Management, Upgrade/Migrations, Backup & Recovery, Disaster Recovery areas. Murali has worked with various Fortune 500 companies across the world in Singapore, Hong Kong, UK, Middle East & USA and rendered his DBA services for some of the world’s most complex and very large database projects. Murali holds the following credits:

  • Oracle Exadata 11gR2 Sales Specialist Assessment, from Oracle
  • Oracle Exadata 11gR2 Pre-Sales Specialist Assessment, from Oracle
  • Oracle Database 11gR2 Sales Specialist Assessment, from Oracle
  • Oracle Database 11gR2 Pre-Sales Specialist Assessment, from Oracle