Exadata Online Training

Prathima InfoTech Oracle Exadata Course Content

Course Objective

What are objectives and learning outcomes of Oracle Exadata 12c course?

Oracle Exadata Training provides you with the complete list of courses needed to

understand the fundamentals of SQL, Database 11g Administration, RAC and Grid

infrastructure and Exadata and Database Machine administration. With this course, you will

attain knowledge on hosting oracle database and improve its performance to the best

available levels.

Here are the course objectives of Oracle Exadata:

ï‚· Understanding of various Exadata database machine features and

configurations

ï‚· Learn the unique capabilities delivered by exadata storage server

ï‚· Get the knowledge on migration of database to exadata database machines

ï‚· Recommended practices for enhancing database performance

ï‚· You should execute a real-time project based on the comprehensive course

curriculum

ï‚· You will get to know the related jobs and job trends in the industry

Who should opt for Oracle Exadata online course?

Oracle Exadata Certified Professionals are earning very high salaries when compared with

other technologies. As such, there are no prerequisites for learning Exadata. With a number

of job opportunities in Exadata, the following job roles will get benefited from this course

ï‚· People having knowledge in Unix basics

ï‚· People having knowledge in SQL fundamentals

ï‚· People having knowledge in Oracle Core DBA

ï‚· People having knowledge in Oracle RAC DBA

ï‚· People having DBA experience in any OLTP/OLAP environments is an added

advantage

Course content

Session 1 Introduction

Course Objectives

Audience and Prerequisites

Course Contents

Terminology

Additional Resources

Introducing the Laboratory Environment

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

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

Session 4 Key capabilities of Exadata DB 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

Session 5 Exadata DB 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

Session 6 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

Session 7 I/O Resource management

I/O Resource Management: Overview

IORM Architecture

Getting Started with IORM

Enabling Intra 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

Session 8 Recommendations for Optimizing DB performance

Optimizing Performance

Flash Memory Usage

Compression Usage

Index Usage

ASM Allocation Unit Size

Minimum Extent Size

Optimizing Database Performance with Exadata

Session 9 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

Smart Scan real time usage

Session 10 Consolidations 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

Session 11 Migrating Databases to Exadata DB 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

Session 12 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

Session 13 Exadata DB 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

Session 14 Configuring Enterprise Manager Grid Control

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

Session 15 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

Session 16 Monitoring Exadata DB Machine DB servers

Monitoring Database Servers: Overview

Monitoring Hardware

Monitoring the Operating System

Monitoring Oracle Grid Infrastructure

Monitoring Oracle Database

Monitoring Oracle Management Agent

Session 17 Monitoring InfiniBand N/W

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

Session 18 Monitoring Other Exadata DB components

Monitoring the Cisco Catalyst Ethernet Switch

Monitoring the Sun Power Distribution Units

Monitoring the Avocent MergePoint Unity KVM Switch

Session 19 Other Monitoring Tools

Exachk: Overview

Running Exachk

Exachk Output

DiagTools: Overview

Using ADRCI on Exadata Storage Servers

Imageinfo: Overview

Imagehistory: Overview

OSWatcher: Overview

Session 20 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

Session 21 Exadata DB 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

Session 22Practice sessions & Interview tips

Brief on all sessions

Interview tips

Resume correction