Exadata Training Syllabus in Bangalore
Oracle Exadata Course Content
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
2
➢ Interconnecting Quarter racks and Eight racks
➢ Infiniband Network External Connectivity
➢ Database Machine Software Architecture: Overview
➢ Disk Storage Entities and Relationships
➢ Flash Storage Entities and relationships
➢ Diskgroup configuration
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
➢ Using exadata Smart flash cache : Write-Through cache
➢ Using Exadata smart flash cache : Write – back cache
➢ Exadata smart Flash log
➢ Exadata Storage index :overview
➢ 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
3
➢ 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
4
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)
5
➢ 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
6
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
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
➢ Battery replacement
➢ Fault processor replacement
7
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
Exadata database machine automated support Ecosystem
➢ Auto Service request :overview
➢ ASR process
➢ ASR requirement
➢ Configure to ASR manager
➢ Configuring Exadata database machine for ASR
➢ Activating ASR Assets
➢ Verifying the ASR Configuration
➢ Oracle configuration manager : overview
➢ Configuring oracle configuration Manager