Oracle Exadata Database Machine Training

Oracle Exadata Database Machine Training

Make an Appointment
Description

Description

Oracle Exadata Database Machine Training at Massive Tech – This Course will give the knowledge on oracle Exadata database Machine which is easy to deploy solution for hosting the Oracle Database that delivers the highest levels of database performance available. It is composed of database servers, Oracle Exadata stroage Serves, an InfiniBand fabric for storage networking and all the other components required to host an Oracle Database.

It will run all types of database workloads including Online Transactions Processing (OLTP), Data Warehousing (DW) and consolidation of mixed workloads. Simple & fast to implement. It is designed to power and protect your most important database and an ideal foundation for a Database as a service.

Importance of Oracle Exadata Database Machine

  • Engineered System for Fast Deployment of all your database.
  • Extreme System Scalability and Growth.
  • Extreme performance by Offloading Data intensive Processing.
  • Ideally Suited for In-Memory Workloads.
  • Extreme Performance from Exadata Smart Flash Cache.
  • Enterprise-class Security with Extreme performance.
  • Mission Critical High availability.
  • Comprehensive System Management.
  • Ideal Platform for Database as a Service Private or Public Cloud.
  • Exadata Business Benefits.
Prerequisites

Prerequisites

  • Prior knowledge of Oracle Database 11g R2 or 12c
  • Knowledge on Unix / Linux Essentials Ed2.
  • Oracle Database 12c R2 : Backup and recovery workshop Ed3
    Recommended Audience
  • Business Intelligence professionals.
  • Project Managers and Database Professionals.
  • SQL Developers.
Key Features
line
  • LIVE Instructor-led Classes
  • 24x7 on-demand technical support for assignments, queries, quizzes, project, etc.
  • Flexibility to attend the class at your convenient time.
  • Server Access to Massive's Tech Management System until you get into your dream carrier.
  • A huge database of Interview Questions
  • Professional Resume Preparation
  • Earn a Skill Certificate
  • Enroll today and get the advantage.
Curriculum
line
  • Course Objectives.
  •  Audience and Prerequisites.
  •  Course Contents.
  •  Terminology.
  •  Additional Resources.
  •  Introducing the Laboratory Environment.
  • 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.
  • 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.
  • Classic Database I/O and SQL Processing Model.
  • Exadata 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.
  • 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 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 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
  • 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
  • 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
  • Consolidation: Overview
  • Different Consolidation Types
  • Recommended Storage Configuration for Consolidation
  • Alternative Storage Configurations
  • Cluster Configuration Options
  • Isolating Management Roles
  • Schema Consolidation Recommendations
  • Maintenance Considerations
  • 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 Tablespaces
  • 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
  • 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
  • Enterprise Manager Database Control
  • 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
  • Exadata Metrics and Alerts Architecture
  • Monitoring Exadata Storage Server with Metrics and Alerts
  • Isolating Faults with
  • Monitoring Exadata Storage Server with Enterprise Manager: Overview
  • Monitoring Hardware Failure and Sensor State
  • Monitoring Exadata Storage Server Availability
  • Comparing Metrics Across Multiple Storage 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
  • 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 the Cisco Ethernet Switch
  • Monitoring the Sun Power Distribution Units
  • Monitoring the KVM Switch
  • Exachk: Overview
  • Running Exachk
  • Exachk Daemon
  • DiagTools: Overview
  • Using ADRCI on Exadata Storage Servers
  • Imageinfo: Overview
  • Imagehistory: Overview
  • OSWatcher: Overview
  • 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
  • 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 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

Have Any Questions?

We are happy to answer any questions and we appreciate every feedback about our work!