Oracle Exadata Training Course Online

BY
Mindmajix Technologies

Mode

Online

Fees

₹ 14400 18000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course and certificate fees

Fees information
₹ 14,400  ₹18,000
certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

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
  • 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
  • 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

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

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
  • Inter database 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 Cloud Control 12c to Monitor Exadata Database Machine

  • Enterprise Manager Cloud Control 12c Architecture: Overview
  • Cloud Control Monitoring Architecture for Exadata Database Machine
  • Configuring Cloud Control to Monitor Exadata Database Machine
  • Pre-discovery Configuration and Verification
  • Deploying the Oracle Management Agent
  • Discovering Exadata Database Machine
  • Discovering Additional Targets
  • Post-discovery Configuration and Verification

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
  • Database Monitoring with Enterprise Manager Cloud Control 12c

Monitoring The InfiniBand Network

  • InfiniBand Network Monitoring: Overview
  • InfiniBand Network Monitoring with
  • Monitoring the InfiniBand Switches
  • Monitoring the InfiniBand Switch Ports
  • Monitoring the InfiniBand Ports
  • Monitoring the InfiniBand Fabric:
  • Monitoring the InfiniBand Fabric:

Monitoring Other Exadata Database Machine Components

  • Monitoring the Cisco Ethernet Switch
  • Monitoring the Sun Power Distribution Units
  • Monitoring the 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

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

Practice Test & Interview Questions

Instructors

Mr Varun
Instructor
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books