IQSOFT - John Brice Oktatóközpont
IT Leadership Development Program - ITLDP

Exadata Database Machine Administration Workshop NEW

Tanfolyam célja

This course introduces you to the Oracle Exadata Database Machine. You'll learn about the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server.

Learn To:

  • List the key capabilities and features of Exadata Database Machine and Exadata Storage Server.
  • Initially configure Exadata Database Machine.
  • Implement Exadata Storage Server security.
  • Use query execution plans, statistics and wait events to examine Exadata Smart Scan.
  • Describe various options and best-practice recommendations for consolidation on Exadata Database Machine.
  • Describe what Exadata is and how it's different from traditional database storage.
  • Maintain, monitor and optimize Database Machine after initial configuration.

Benefits To You:

  • After taking this course, you will have a deeper understanding of how to use the Exadata Database machine to run your largest and most important database application¬¬ up to ten times faster. You'll be equipped to make appropriate up-front configuration decisions and will learn how to use Infiniband connectivity and redundant power distribution units (PDU) to increase high availability.

Course objectives:

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

Recommended Related Training Courses:

  • Parallel Processing in Oracle Database 11g - Seminar

This Parallel Processing in Database 11g training teaches you the benefits of parallelizing requests in an 11g database & use features of parallel processing. View recorded demos of parallel processing in various database server configurations.

  • Oracle Database 11g: Implement Partitioning Release 2

This course covers in depth the management of partitioning using the Oracle Database 11g Release 2. This includes purpose, administration, and syntax of commands. Design and performance issues are mentioned.This course is based on Oracle Database 11g Release 2 Patch Set 1.

  • Oracle Database 11g: Data Mining Techniques

In this course, students review the basic concepts of data mining and learn how leverage the predictive analytical power of the Oracle Database Data Mining option by using Oracle Data Miner 11g Release 2. The Data Miner GUI provides intuitive tools that help you to explore the data graphically, build and evaluate multiple data mining models, apply Oracle Data Mining models to new data, and deploy Oracle Data Mining's predictions and insights throughout the enterprise.

  • Oracle Database 11g: Administer a Data Warehouse

This Oracle Database 11g training will help you understand the basic concepts of a data warehouse. You'll learn to use various Oracle Database features to improve performance and manageability in a data warehouse.

  • Oracle Database 11g: Data Warehousing Fundamentals

This Database 11G Data Warehousing training teaches data warehousing concepts and technologies, while examining Oracle's approach to data warehouse implementation. Review partitioning, parallel operations, materialized views and more.

Tematika
  • 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
Előfeltételek

Kötelező előfeltételek:

  • General storage and systems administration

Ajánlott előfeltételek:

  • Oracle RAC/ASM DBA
  • Oracle Enterprise Linux: System Administration
  • Relevant Hardware Training
  • Networking (inc. Infiniband)
  • Oracle Enterprise Manager 11g: Grid Control Essentials
  • Oracle 11g: RAC and Grid Infrastructure Overview Seminar Release 2
  • Oracle Database 11g: Administration Workshop II Release 2
  • Oracle Database 11g: Administration Workshop I Release 2

Kapcsolódó tanfolyamok