Oracle Exadata Online Training By Hands-On Professionals

Oracle Exadata Training includes how to use RMAN with Database Machine, Exadata Cell Software Rescue Procedure, deploying Oracle Management Agent, creating Flash-Based Grid Disks and Smart Flash Log., etc.



FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in


Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

Oracle Exadata Course Outline

(the course content can be modified as per your requirements):


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 Outp

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