ORACLE EXADATA TRAINING

1. Exadata Machine Overview & Architecture

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

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

3. Resource Management

• I/O Resource Management: Overview
• IORM Architecture
• Getting Started with IORM
• Enabling Inter database Resource Management
• Setting Database I/O Utilization Limits
• Inter database Plans and Database Roles
• Using Database I/O Metrics
• IORM and Exadata Storage Server Flash Memory

4. Optimizing Database Performance

• Optimizing Performance
• Flash Memory Usage
• Compression Usage
• ASM Allocation Unit Size
• Minimum Extent Size
• Optimizing Database Performance with Exadata

5. Smart Scan Overview

• 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
• Other Situations Affecting Smart Scan
• Exadata Storage Server Wait Events: Overview
• Using Smart Scan

6. Migrating Database to ExaData

• Migration Best Practices: Overview
• Performing Capacity Planning Overview
• 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

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

8. Configuring EMGC11G To Monitor Exadata 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

9. Monitoring Exadata Storage Server

• 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

10. Monitoring DB Server

• Monitoring Database Servers: Overview
• Monitoring Hardware
• Monitoring the Operating System
• Monitoring Oracle Grid Infrastructure
• Monitoring Oracle Database
• Monitoring Oracle Management Agent

11. Monitoring Infiniband

• 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

12. Important Maintenance Tasks

• Database Machine Maintenance: Overview
• Powering Database Machine Off and On
• Safely Shutting Down a Single Exadata Storage Server
• Moving All Disks from One Cell to Another
• Using the Exadata Cell Software Rescue Procedure

13. Other Monitoring Components

• Exachk: Overview
• Running Exachk
• Exachk Output
• DiagTools: Overview
• Using ADRCI on Exadata Storage Servers
• Image info: Overview
• Image history: Overview
• OSWatcher: Overview

14. Backup & Recovery

• Using RMAN with Database Machine
• General Recommendations for RMAN
• Disk-Based Backup Strategy
• Disk-Based Backup Recommendations
• Tape-Based Backup Strategy
• Connecting the Media Server Using Ethernet
• Backup and Recovery of Database Machine Software