18c Exadata Administration – X7

Oracle Exadata Database Machine is engineered to be the highest performing and most available platform for running Oracle Database.

Oracle Exadata Database Machine and Oracle Exadata Storage Expansion Rack are hardware systems that consist of multiple components. This chapter provides an overview of Exadata systems, and usage information.

Course Overview

What will you learn?

  • Describe the key capabilities of Exadata Database Machine
  • Identify the benefits of using Exadata Database Machine for different application classes
  • Describe the architecture of Exadata Database Machine and its integration with Oracle Database, Clusterware, and ASM
  • Configure I/O Resource Management
  • Complete the initial configuration of Exadata Database Machine
  • Describe various recommended approaches for migrating to Exadata Database Machine
  • Gain an understanding of the Oracle Database Exadata Cloud Service
  • Monitor Exadata Database Machine health and optimize performance

Who should go for this training?
The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

  • Oracle Database 12c: Backup and Recovery Workshop Ed 2
  • UNIX and Linux Essentials Ed 1
  • Prior knowledge of Oracle Database 11g R2 or 12c RAC

Course Content

  • Describe the key capabilities of Exadata Database Machine
  • Identify the benefits of using Exadata Database Machine for different application classes
  • Describe the architecture of Exadata Database Machine and it integrates with Oracle Database, Clusterware, and ASM
  • Complete the initial configuration of Exadata Database Machine
  • Describe various recommended approaches for migrating to Exadata Database Machine
  • Configure I/O Resource Management
  • Monitor Exadata Database Machine health and optimize performance
  • Describe the Exadata network architecture
  • Describe the Exadata software architecture
  • Describe the Exadata Storage Server storage entities and their relationships
  • Describe how multiple Exadata racks can be interconnected
  • Installation and configuration process for Exadata
  • Default configuration for Exadata
  • Supported and unsupported customizations for Exadata
  • I/O Resource Management: Overview
  • I/O Resource Management Plans
  • IORM Architecture
  • I/O Resource Management for Flash
  • Using Exadata I/O Resource Management
  • with Oracle Database 12c
  • Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
  • Describe the requirements for Smart Scan
  • Describe the circumstances that prevent using Smart Scan
  • Identify Smart Scan in SQL execution plans
  • Use database statistics and wait for events to confirm how queries are processed
  • Describe the general steps to migrate your database to Exadata
  • List the main approaches for migrating your database to Exadata
  • Identify the most appropriate approach for different circumstances
  • Describe the key monitoring infrastructure technologies associated with Exadata Database Machine
  • Describe Exadata Storage Server metrics, alerts, and active requests
  • Identify the recommended focus areas for Exadata Storage Server monitoring
  • Describe how to monitor the recommended Exadata Storage Server focus areas
  • Describe the InfiniBand network monitoring capabilities provided by Enterprise Manager Cloud Control
  • Explain how to monitor the Exadata InfiniBand network without Enterprise Manager

Describe the following tools:

  • Exachk
  • ExaWatcher
  • TFA Collector
  • Imageinfo and Imagehistory
  • ILOM

Perform the following Exadata maintenance tasks:

  • Powering Exadata on and off
  • Safely shutting down a single Exadata Storage Server
  • Replacing a damaged physical disk on a cell
  • Replacing a damaged flash card on a cell
  • Moving all disks from one cell to another
  • Using the Exadata cell software rescue procedure
  • Describe the Auto Service Request (ASR) function and how it relates to Exadata
  • Explain the implementation requirements for ASR
  • Explain the ASR configuration process
  • Describe Oracle Configuration Manager (OCM) and how it relates to Exadata
  • Provide an overview-level description of Exadata Storage Server and the different Exadata Database Machine configurations
  • Outline the key capacity and performance specifications for Exadata Database Machine
  • Exadata Smart Scan Model
  • Exadata Smart Storage Capabilities
  • Hybrid Columnar Compression: Overview
  • Exadata Smart Flash Cache: Overview
  • Columnar Flash Caching
  • Exadata Smart Flash Log: Overview
  • Exadata Storage Index: Overview
  • Exafusion Direct-to-Wire Protocol
  • Exadata Network Resource Management
  • I/O Resource Management: Overview
  • Exadata Benefits for Data Warehousing and Analytics
  • Exadata Benefits for OLTP
  • Configure Exadata Storage Server software
  • Create and configure ASM disk groups using Exadata storage

Areas for special consideration:

  • Flash memory usage
  • Compression usage
  • Index usage
  • ASM allocation unit size
  • Extent size
  • Exadata specific system statistics
  • Setting the I/O timeout threshold
  • Describe the options for consolidating multiple databases on Exadata
  • Explain the benefits and costs associated with the different options
  • Describe alternative architectures for bulk data loading into Exadata
  • Configure the Database File System (DBFS) feature for staging input data files
  • Use external tables to perform high-performance data loads
  • Describe Enterprise Manager Cloud Control architecture as it specifically applies to Exadata
  • Explain how to configure Enterprise Manager Cloud Control to monitor Exadata
  • Explain the guided discovery process for Exadata
  • Describe how to configure a dashboard for Exadata
  • Describe the monitoring recommendations for Exadata database servers

Monitor the following additional Exadata components:

  • Cisco Ethernet Switch
  • Sun Power Distribution Units
  • KVM Switch
  • Explain how Recovery Manager (RMAN) backups are optimized using Exadata Storage Server
  • Describe the recommended approaches for disk- and tape-based backups of databases on Exadata
  • List the recommended best practices for backup and recovery on Exadata
  • Describe how software is maintained on different Exadata components
  • Locate the recommended patches for Exadata
  • Describe the recommended patching process for Exadata
  • Describe the characteristics of an effective test system

Modes of Training

Classroom Training

Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over the internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts at your own pace and timing.

Frequently Asked Questions

Our trainer is an OCP & OCM certified consultant and has a significant amount of experience in working with the technology, having 18yrs of experience.

Once you get registered, our back-end team will share you the details to join the session live over an online portal which can be accessed through a browser.

Each of our live sessions is recorded. In case if you miss any, you can request us to share the link to that particular session.

For practical execution, our trainer/technical team will provide server access details to the student

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Live-Online training is where you can have a live session with the trainer and clarify queries parallelly.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen, and learn anytime at ur feasible place. For doubts in the videos, you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to help@sarinfotechindia.com with your queries.

The course material and recorded videos which are provided during the course period. You can download it anytime.

Visit our website regularly to check discounts offers from time to time. However, we provide a discount for single participants & special discounts for 2 or more participants.

* If the request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If the request made after 2 days, then Refund is made after deduction of the administration fee.