• Presencial

Exadata Database Machine: 12c Administration Workshop


This course introduces students to Oracle Exadata Database Machine.

Students learn about the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server. The installation and initial configuration process is covered so that students are equipped to make appropriate up-front configuration decisions. Students are introduced to various options for migrating to Database Machine and learn how to select the best approach. They also learn how to maintain, monitor and optimize Database Machine after initial configuration. Students learn about monitoring Exadata Database Machine with a focus on best practices for what and how to monitor. Students learn about the monitoring infrastructure inherently within Exadata Database Machine, along with the monitoring capabilities exposed through Enterprise Manager Grid Control and associated plugins.

Best-practice recommendations are highlighted throughout and, where possible, the topics are reinforced through the student participation in structured hands-on lab exercises. There is also a series of recorded demonstrations included with the course.

Programa

  • Introduction
  • Exadata Database Machine Overview
  • Exadata Database Machine Architecture
  • Key Capabilities of Exadata Database Machine
  • Exadata Database Machine Initial Configuration
  • Exadata Storage Server Configuration
  • I/O Resource Management
  • Recommendations for Optimizing Database Performance
  • Using Smart Scan
  • Consolidation Options and Recommendations
  • Migrating Databases to Exadata Database Machine
  • Bulk Data Loading Using Oracle DBFS
  • Exadata Database Machine Platform Monitoring Introduction
  • Configuring Enterprise Manager Grid Control 11g to Monitor Exadata Database Machine
  • Monitoring Exadata Storage Servers
  • Monitoring Exadata Database Machine Database Servers
  • Monitoring the InfiniBand Network
  • Monitoring Other Exadata Database Machine Components
  • Other Useful Monitoring Tools
  • Backup and Recovery
  • Exadata Database Machine Maintenance Tasks
  • Patching Exadata Database Machine

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
  • General Configuration
  • Choosing the Right Protection Level
  • Oracle Enterprise Manager Grid Control Configuration
  • Database Machine Hardware Installation: Overview
  • Configuring Oracle Exadata Database Machine: Overview
  • Selecting the Database Server Operating System
  • Deploying Solaris on the Database Servers

Exadata Storage Server Configuration

  • Exadata Storage Server Administration: Overview
  • Testing Storage Server Performance Using CALIBRATE
  • Configuring the Exadata Cell Server Software
  • Creating Flash-Based Grid Disks
  • Creating Smart Flash Log
  • Configuring ASM and Database Instances to Access Exadata Cells
  • Exadata Storage Security: Overview
  • 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
  • Interdatabase 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 Grid Control 11g to Monitor Exadata Database Machine

  • Enterprise Manager Grid Control Architecture: Overview
  • Grid Control Monitoring Architecture for Exadata Database Machine
  • Configuring Grid Control to Monitor Exadata Database Machine
  • Deploying the Oracle Management Agent
  • Configuring ASM and Oracle Database Targets
  • Deployment Overview for System Monitoring Plug-ins
  • Recommended Plug-in Deployment Strategy
  • Switch

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

Monitoring the InfiniBand Network

  • InfiniBand Network Monitoring: Overview
  • Manually Monitoring the InfiniBand Switches
  • Monitoring the InfiniBand Switches with Grid Control
  • Monitoring the InfiniBand Switch Ports
  • Monitoring the InfiniBand Ports on Database Machine Servers
  • Monitoring the InfiniBand Fabric: Subnet Manager Master Location
  • Monitoring the InfiniBand Fabric: Network Topology and Link Status

Monitoring Other Exadata Database Machine Components

  • Monitoring the Cisco Catalyst Ethernet Switch
  • Monitoring the Sun Power Distribution Units
  • Monitoring the Avocent MergePoint Unity 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
  • Maintaining Other Software
  • Recommended Patching Process
  • Test System Recommendations

Outras Edições

Inscreva-se

Dados Pessoais

Dados para faturação

Condições Gerais e Autorizações
  • Se a inscrição for cancelada com antecedência superior a 5 dias úteis da data de início do curso, a Rumos não efectuará qualquer facturação ao cliente.
  • Se a inscrição for cancelada com antecedência igual ou inferior a 5 dias, a Rumos procederá à facturação do valor da inscrição, dando no entanto ao cliente a possibilidade de transferir a sua inscrição para uma nova data. Esta garantia é válida por 6 meses, não se responsabilizando a Rumos se o curso não se repetir nesse período.
  • Pela não comparência do participante no curso sem cancelamento da inscrição a Rumos facturará o valor da inscrição, perdendo o formando o direito à participação no curso.
  • A viabilidade de realização de um curso depende de um número mínimo de inscrições. A Rumos reserva o direito de cancelar um curso por falta de viabilidade deste, notificando esse facto aos inscritos com o mínimo de 2 dias úteis de antecedência.

Os seus dados pessoais são recolhidos em conformidade com o Regulamento Geral de Proteção de Dados (RGPD).
Consente que os seus dados sejam utilizados, nos termos da nossa Politica de Privacidade, para o contacto/envio de:

Ações de informação, de marketing de produtos e serviços, como campanhas e eventos?

Para mais informações, consulte a Política de Privacidade do Grupo Rumos.
pode retirar o seu consentimento a qualquer momento através do botão Cancelar subscrição ou Unsubscribe que estão presentes em cada comunicação enviada, bem como exercer os direitos descritos na politica de privacidade

Para a subscrição da newsletter deverá desativar o bloqueio de pop-ups do seu browser.

Exadata Database Machine: 12c Administration Workshop

  • Datas
    16 Set a 20 Set 2019
    Lisboa
  • Horário
    Laboral
    das 09h30 às 17h30
  • Nº Horas
    30
  • Preço
    3765€

Exadata Database Machine: 12c Administration Workshop

Área

Dados

Como chegou até nós

Os seus dados pessoais são recolhidos em conformidade com o Regulamento Geral de Proteção de Dados (RGPD).
Consente que os seus dados sejam utilizados, nos termos da nossa Politica de Privacidade, para o contacto/envio de:

Ações de informação, de marketing de produtos e serviços, como campanhas e eventos?

Para mais informações, consulte a Política de Privacidade do Grupo Rumos.
pode retirar o seu consentimento a qualquer momento através do botão Cancelar subscrição ou Unsubscribe que estão presentes em cada comunicação enviada, bem como exercer os direitos descritos na politica de privacidade

Para a subscrição da newsletter deverá desativar o bloqueio de pop-ups do seu browser.