Oracle EXadata

Oracle EXadata


    Oracle Exadata Course Contents :


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

    Exadata Database Machine Overview

    • Introducing Database Machine
    • Introducing Exadata Storage Server
    • Exadata Storage Server Architecture: Overview
    • Exadata Storage Server Features: Overview
    • Database Machine Capacity
    • Exadata Storage Expansion Racks
    • InfiniBand Network
    • Database Machine Support: Overview

    Exadata Database Machine Architecture

    • Database Machine Architecture: Overview
    • Database Machine Network Architecture
    • InfiniBand Network Architecture
    • X2-2 Full Rack Leaf Switch Topology
    • Spine and Leaf Topology
    • Scale Performance and Capacity
    • Database Machine Software Architecture: Overview
    • Disk Storage Entities and Relationships

    Key Capabilities of Exadata Database Machine

    • Classic Database I/O and SQL Processing Model
    • Exadata Smart Scan Model
    • Exadata Smart Storage Capabilities
    • Exadata Hybrid Columnar Compression Data Organization
    • Exadata Smart Flash Cache Intelligent Caching
    • Storage Index with Partitions
    • Database File System
    • I/O Resource Management: Overview

    Exadata Database Machine Initial Configuration

    • Database Machine Implementation: Overview
    • General Configuration
    • Choosing the Right Protection Level
    • Oracle Enterprise Manager Grid Control Configuration
    • Database Machine Hardware Installation: Overview
    • Configuring Oracle Exadata Database Machine: Overview
    • Selecting the Database Server Operating System
    • Deploying Solaris on the Database Servers

    Exadata Storage Server Configuration

    • Exadata Storage Server Administration: Overview
    • Testing Storage Server Performance Using CALIBRATE
    • Configuring the Exadata Cell Server Software
    • Creating Flash-Based Grid Disks
    • Creating Smart Flash Log
    • Configuring ASM and Database Instances to Access Exadata Cells
    • Exadata Storage Security: Overview
    • Exadata Storage Security Implementation

    I/O Resource Management

    • I/O Resource Management: Overview
    • 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

    Recommendations for Optimizing Database Performance

    • Optimizing Performance
    • Flash Memory Usage
    • Compression Usage
    • Index Usage
    • ASM Allocation Unit Size
    • Minimum Extent Size
    • Optimizing Database Performance with Exadata

    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
    • Using Smart Scan

    Consolidation Options and Recommendations

    • 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 Databases Machine Using Transportable

    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
    • Bulk Data Loading Using Oracle DBFS

    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 Grid Control
    • Enterprise Manager Database Control

    Configuring Enterprise Manager Grid Control 11g to Monitor Exadata Database Machine

    • Enterprise Manager Grid Control Architecture: Overview
    • Grid Control Monitoring Architecture for Exadata Database Machine
    • Configuring Grid Control to Monitor Exadata Database Machine
    • Deploying the Oracle Management Agent
    • Configuring ASM and Oracle Database Targets
    • Deployment Overview for System Monitoring Plug-ins
    • Recommended Plug-in Deployment Strategy
    • Switch

    Monitoring Exadata Storage Servers

    • Exadata Metrics and Alerts Architecture
    • Monitoring Exadata Storage Server with Metrics
    • Monitoring Exadata Storage Server with Alerts
    • Monitoring Exadata with Active Requests
    • Monitoring Exadata Storage Server with Grid Control: Overview
    • Monitoring Hardware Failure and Sensor State
    • Monitoring Exadata Storage Server Availability
    • Comparing Metrics Across Multiple Storage Servers

    Monitoring Exadata Database Machine Database Servers

    • Monitoring Database Servers: Overview
    • Monitoring Hardware
    • Monitoring the Operating System
    • Monitoring Oracle Grid Infrastructure
    • Monitoring Oracle Database
    • Monitoring Oracle Management Agent

    Monitoring the InfiniBand Network

    • InfiniBand Network Monitoring: Overview
    • Manually Monitoring the InfiniBand Switches
    • Monitoring the InfiniBand Switches with Grid Control
    • Monitoring the InfiniBand Switch Ports
    • Monitoring the InfiniBand Ports on Database Machine Servers
    • Monitoring the InfiniBand Fabric: Subnet Manager Master Location
    • Monitoring the InfiniBand Fabric: Network Topology and Link Status

    Monitoring Other Exadata Database Machine Components

    • Monitoring the Cisco Catalyst Ethernet Switch
    • Monitoring the Sun Power Distribution Units
    • Monitoring the Avocent MergePoint Unity KVM Switch

    Other Useful Monitoring Tools

    • Exachk: Overview
    • Running Exachk
    • Exachk Output
    • DiagTools: Overview
    • Using ADRCI on Exadata Storage Servers
    • Imageinfo: Overview
    • Imagehistory: Overview
    • OSWatcher: Overview

    Backup and Recovery

    • Using RMAN with Database Machine
    • General Recommendations for RMAN
    • Disk-Based Backup Strategy
    • Disk-Based Backup Recommendations
    • Tape-Based Backup Strategy
    • Tape-Based Backup Architecture
    • Connecting the Media Server Using Ethernet
    • 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

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 week, 3 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies