Oracle Exadata Administration X8

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

• Provide an overview-level description of Exadata Storage Server and the different Exadata Database Machine configurations
  
• Exadata X8M Hardware
• Exadata Database Machine X8M-2
• Exadata Database Machine X8M-8
• RDMA Over Converged Ethernet (RoCE): Overview
• Outline the key capacity and performance specifications for Exadata Database Machine

• The Exadata network architecture
  
• RDMA over Converged Ethernet (RoCE)
• How multiple Exadata racks can be interconnected
• The Exadata software architecture
• The Exadata Storage Server storage entities and their relationships
• Disk Group Configuration

• Exadata Smart Scan Model
  
• Exadata Storage Index: Overview
• Hybrid Columnar Compression: Overview
• Exadata Smart Flash Cache: Overview
• Persistent Memory (PMEM)
• In-Memory Columnar Caching on Storage Servers
• Exafusion Direct-to-Wire Protocol
• Exadata X8M RoCE: High Priority Networking
• I/O Resource Management: Overview
• Columnar Flash Caching
• Exadata Smart Flash Log: Overview
• Exadata Network Resource Management
• Exadata Benefits for Data Warehousing and 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 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 events to confirm how queries are processed

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

• 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 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 the key monitoring infrastructure technologies associated with 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

• 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 monitoring recommendations for Exadata database servers

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

Monitor the following additional Exadata components:

           -    Cisco Ethernet Switch

           -   Sun Power Distribution Units

           -    KVM Switch

Describe the following tools:

          -   Exachk

          -   ExaWatcher

          -   TFA Collector

          -   ADRCI

          -   Imageinfo and Imagehistory

          -    ILOM

• 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

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

• 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

• The installation and configuration process for Exadata
  
• Default configuration for Exadata
• Various Exadata life cycle management tasks using OEDACLI

• I/O Resource Management: Overview
  
• IORM Architecture
• Using Exadata IORM with CDB
• Enabling IORM for Multiple Databases
• Flash Cache and Flash Log Resource Control
• PMEM Cache and PMEM Log Resource Control
• Monitoring IORM Using AWR