Courses | SVS Online Training
Untitled Document

svsonlinetrainings@gmail.com

+91 8125490399

EXA DATA Course Contents

Exadata Database Machine Overview


  • Introducing Database Machine
  • 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

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

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
  • Moving All Disks from One Cell to Another
  • Using the Exadata Cell Software Rescue Procedure

Untitled Document

Our Happy clients

Follow Us

Contact Us

Head Office

Hyderabad,Telangana,India

Phone:+91 8125490399,

Email:svsonlinetrainings@gmail.com