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

Course Objective

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 Learn

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

  • Administrator
  • Architect
  • Database Administrator

Prerequisite

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

1. Introduction

  • 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

3. Exadata Database Machine Architecture

  • 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

5. Exadata Database Machine Initial Configuration

  • Installation and configuration process for Exadata
  • Default configuration for Exadata
  • Supported and unsupported customizations for Exadata

7. I/O Resource Management

  • 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

9. Using Smart Scan

  • 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

11. Migrating Databases to Exadata Database Machine

  • 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

13. Exadata Database Machine Platform Monitoring: Introduction

  • Describe the key monitoring infrastructure technologies associated with Exadata Database Machine

15. Monitoring Exadata Storage Servers

  • 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

17. Monitoring the InfiniBand Network

  • Describe the InfiniBand network monitoring capabilities provided by Enterprise Manager Cloud Control
  • Explain how to monitor the Exadata InfiniBand network without Enterprise Manager

19. Other Useful Exadata Monitoring Tools

Describe the following tools:

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

21. Exadata Database Machine Maintenance Tasks

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

23. Exadata Database Machine Automated Support Ecosystem

  • 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

2. Exadata Database Machine: Overview

  • 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

4. Key Capabilities of 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

6. Exadata Storage Server Configuration

  • Configure Exadata Storage Server software
  • Create and configure ASM disk groups using Exadata storage

8. Recommendations for Optimizing Database Performance

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

10. Consolidation Options and Recommendations

  • Describe the options for consolidating multiple databases on Exadata
  • Explain the benefits and costs associated with the different options

12. Bulk Data Loading

  • 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

14. Configuring Enterprise Manager Cloud Control to Monitor Exadata Database Machine

  • 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

16. Monitoring Exadata Database Machine Database Servers

  • Describe the monitoring recommendations for Exadata database servers

18. Monitoring Other Exadata Database Machine Components

Monitor the following additional Exadata components:

  • Cisco Ethernet Switch
  • Sun Power Distribution Units
  • KVM Switch

20. Backup and Recovery

  • 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

22. Patching Exadata Database Machine

  • 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

Who are the trainers?

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

How do I join the live sessions?

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.

What if I miss a class?

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.

How will I execute the practical?

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

Will you help us in building our own Lab Setup in our local Desktop/Laptop?

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

What is the difference between live online and pre-recorded video training?

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.

What if I have queries after completion of the class?

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

Is the course material accessible after completion of the course?

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

Any offer/discount that I can avail?

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.

Will I get the refund if I cancel my enrollment?

* 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.