Oracle Exadata Database Machine (DBM) is software and hardware engineered together to provide the highest-performing and most-available platform for running Oracle Database. Exadata DBM 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?

Exadata Boot Camp Trainingintroduces you to thecore concepts of Exadata with emphasis on Exadata Storage and the Key Features of Exadata like Flash Cache, Flash Log, Smart Scan, Hybrid Columnar Compression, Storage Indexes, and IO Resource Management. The training methodology consists of both theory sessionsand hands-on practices with 24×7 online lab access.

After completing this training, you should be able to manage and work on Exadata environments.

Training Highlights

  • Training by real time&hands-on Exadata expert
  • In-depth coverage and thorough explanation of all topics
  • Hands-on sessions with 24×7 online Lab Access
  • Session PPTs, Hands-on Lab Guide and online resources for additional reading
  • Who can attend?
  • Database Administrators
  • Sales Consultants
  • System Administrator
  • Technical Administrator
  • Technical Consultant

Suggested Pre-requisites

  • Unix/Linux
  • Oracle DBA
  • Oracle ASM
  • Oracle RAC

Introduction

  • Course Objectives
  • Prerequisites
  • Course Contents
  • Terminology
  • Introducing the Laboratory Environment

Exadata Database Machine Overview

  • What is Exadata?
  • Exadata Storage Server Features: Overview
  • Exadata Vs Traditional Storage Servers
  • What is Exadata Database Machine (DBM)?
  • Components of Database Machine
  • DBM Configurations
  • DBM Versions/Generations
  • DBM Hardware: Overview
  • DBM Software: Overview
  • DBM Scalability
  • Exadata Storage Expansion Racks
  • Exadata Elastic Configurations
  • Why Database Machine?

Exadata Database Machine Architecture

  • Database Machine Architecture: Overview
  • Database Machine Software Architecture
  • Exadata Storage Server Processes
  • DB to Cell Communication
  • Database Machine Network Architecture
  • InfiniBand Network Architecture
  • InfiniBand Network Topology
  • InfiniBand Network External Connectivity
  • Overview of iDB & RDS Protocols

Exadata Storage Server (Cell) Concepts

  • Cell User Accounts
  • Cell Processes
  • Cell Log Files
  • Cell Utilities – CellCLI, DCLI
  • Exadata Storage Overview
  • Storage Objects in Exadata
  • Disk Layout in Exadata Cell
  • Disk Storage and Flash Storage
  • Disk Storage Objects and their Relationships
  • Flash Storage Objects and their Relationships
  • Cell Disks, Grid Disks, ASM Disks, ASM Diskgroups
  • ASM Mirroring and Failure groups
  • Auto Disk Management Concepts in Exadata

Exadata Storage Server (Cell) Administration

  • Exadata Storage Server Administration: Overview
  • Configuring DB Servers to access Exadata Cells
  • Configuring ASM and Database Instances to Access Exadata Cells
  • Configuring Cell Server to send E-mail notifications
  • Starting/Stopping Cell Services
  • Configuring DCLI utility on Cell nodes& DB nodes
  • Adding Physical Disks& Flash Disks to the Cell Server
  • Creating Hard Disk & Flash Disk basedCell Disks
  • Creating Grid Disks based on Hard Disks & Flash Disks
  • Creating ASM Diskgroups using Grid Disks based on Hard Disks & Flash Disks
  • Testing Automatic Exadata Storage Management Features
  • Reconfiguring Flash Storage
  • Dropping Flash Cache & Flash Log
  • Recreating Flash Cache & Flash Log
  • Online Reconfiguration of Exadata Storage
  • Recommended Storage Configuration for Consolidation
  • Alternative Storage Configurations

Exadata Smart Flash Cache& Flash Log

  • Use of Flash Storage in Exadata
  • Overview of Exadata Smart Flash Cache& Flash Log
  • Overview of Intelligent Caching
  • Influencing the Caching decisions
  • Write-Through Flash Cache mode
  • Write-Back Flash Cache mode
  • Observing the Cached Objects

Exadata Smart Scan / Offloading

  • Overview of Exadata Smart Scan feature
  • Traditional I/O and SQL Processing
  • Exadata Smart Scan processing
  • Smart Scan Requirements
  • Smart Scan disablers
  • Observing Smart Scan operations in Query Execution Plans
  • Statistics & Wait Events related to Smart Scan
  • Other Smart Scan Optimizations
  • Compression/Decompression
  • Encryption/Decryption
  • Virtual Columns
  • Other Non-Smart Scan Optimizations
  • Smart/Fast File creation
  • RMAN Incremental Backup
  • RMAN Backup Restores

Exadata Hybrid Columnar Compression

  • Compression Methods in Oracle
  • Basic Compression, OLTP compression
  • Exadata Hybrid Columnar Compression (EHCC)
  • Data organization using EHCC
  • Compression Unit
  • EHCC Types
  • Warehouse Compression
  • Archival Compression
  • Enabling EHCC
  • DMLs on EHCC Tables
  • Comparing different Compression Methods

Exadata Storage Indexes

  • Overview of Exadata Storage Indexes
  • Conceptual view of Storage Indexes
  • Requirements for Storage Indexes
  • Statistics related to Storage Indexes

Exadata I/O Resource Management (IORM)

  • I/O Resource Management Concepts
  • IORM Architecture
  • Intradatabase Vs Interdatabase plans
  • Setting IORM objective
  • Implementing Intradatabase plans (DB Plans)
  • Implementing Interdatabase Plans (IORM Plans)
  • DB Plans, Category Plans
  • Using Database I/O Metrics
  • IORM and Exadata Storage Server Flash Memory

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