• admin@thetechmaster.in
  • |
  • +919676516545

admin@thetechmaster.in

+919676516545

Oracle Exadata

Faculity Name : Raj

Experience : 9 Years

Course Duration : 25 days

Price : 35000 INR

Course Details

  • About Course
  • About Instructor
  • Course Content
  • Videos

Exadata, one of the powerful machines of Oracle through which we attain all the requirements for a database like high availability, disaster recovery solution etc in a single shot. Very very demandful in the market and learn it upfront and grab wonderful chance as DMA in your dream companies.

Pre-requisite: Oracle DBA, Oracle RAC

Training highlights:

VMware dump for practice purpose

In-depth details about Exadata machine

Discussion on latest version boxes

Monitoring tools for Exadata

Patching Exadata machine

Raj

Experience : 9 Years

Raj  is having 7 years experience as Oracle RAC & EXADATA  DBA and currently working in MNC as DMA.

He has been into training industry for more than 3 years now and handled  corporate and personal training batches. 50+ of his trained professionals were placed into MNC's in  India .

His training is purely real time oriented with lot of exposure to the internals as well as real time issues. His expertise helps a layman candidate to understand about Oracle Database Administration to the core.

Oracle Exadata Course Content

Oracle Exadata Course Content

 

Introduction

  • 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
  • Interconnecting Quarter racks and Eight racks
  • Infiniband Network External Connectivity
  • Database Machine Software Architecture: Overview
  • Disk Storage Entities and Relationships
  • Flash Storage Entities and relationships
  • Diskgroup configuration

 

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
  • Using exadata Smart flash cache : Write-Through cache
  • Using Exadata smart flash cache : Write – back cache
  • Exadata smart Flash log
  • Exadata Storage index :overview
  • 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

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
  • Battery replacement
  • Fault processor replacement

 

Patching Exadata Database Machine

  • Patching and Updating: Overview
  • Maintaining Exadata Storage Server Software
  • Maintaining Database Server Software
  • Assisted Patching Using OPlan
  • Maintaining Other Software
  • Recommended Patching Process
  • Test System Recommendations

Exadata database machine automated support Ecosystem

  • Auto Service request :overview
  • ASR process
  • ASR requirement
  • Configure to ASR manager
  • Configuring Exadata database machine for ASR
  • Activating ASR Assets
  • Verifying the ASR Configuration
  • Oracle configuration manager : overview
  • Configuring oracle configuration Manager 

For Quick Contact Please Call Us : +919676516545

Batch Timings

Course Features

  • Live Instructor Led Course
  • Real Time oriented training
  • Guidance on Resume preparation
  • Mock Interviews
  • Training on latest version
  • Guidance on certification
  • Coverage of extended topics
  • Lower price