WhatsApp : +918121020333 / +919849510373

India: +91 40 6050 1418

USA: +1 516 8586 242

UK: +44 (0)203 371 0077

exadata

Getting Started

 

o        Objectives

o        Audience &  Prerequisites

o        Terminology

o        Introduction To Laboratory Environment

Overview  Of Exadata Database Machine

 

o        Introduction To Database Machine

o        Introduction  ExadataStorage Server

o        Architecture  Of ExadataStorage Server

o        Overview Exadata Storage Server Features

o        The Database Machine Capacity

o        The Exadata Storage Expansion Racks

o        Overview  Of DatabaseMachine Support

 

Introduction To ExadataDatabase Machine 

 

o        Architecture Database Machine Network 

o        Architecture  Of InfiniBand Network

o        Topology Of  X2-2Full Rack Leaf Switch

o        Spine &  Leaf Topology

o        Scale Performance &  Capacity

o        Disk Storage Entities & Relationships

Key Capabilities Of ExadataDatabase_ Machine

 

o        Classic Database I/O & SQL Processing Model

o        Exadata Smart Scan _Model

o        Capabilities Of Exadata Smart Storage

o        The Exadata Hybrid Columnar Compression Data Organization

o        The Exadata Smart Flash Cache Intelligent Caching

o        Storage Index Partitions

o        The Database File System

 

Basic Overview Of I/OResource Management
Exadata DatabaseMachine Initial Configuration

 

o        General _Configurations

o        Choosing Of  RightProtection Level

o        The Oracle Enterprise Manager Grid Control Configuration

o        Installation  Of DatabaseMachine Hardware

o        Configuring Oracle Exadata Database Machine

o        Selecting the Database Server Operating System

o        Deploying  The Solarison the Database Servers

Configuration Of ExadataStorage Server 

 

o        Exadata Storage Server Administration

o        Testing  the StorageServer Performance Using  the CALIBRATE

o        Configuring of  Exadata Cell Server Software

o        Creating  an Flash-BasedGrid Disks

o        Creating an Smart Flash Log

o        Configuring ASM &  Database Instances to Access Exadata Cells

o        Exadata Storage Security

o        Implementation Of  ExadataStorage Security 

I/O Resource_Management

 

o        I/O Resource Management

o        Architecture  Of IORM

o        Overview To  IORM

o        Enabling the Intradatabase Resource Management

o        Setting the Database I/O Utilization Limits

o        Interdatabase Plans &  Database Roles

o        Using Of Database I/O Metrics

o        IORM &  ExadataStorage Server Flash Memory

Recommendations forOptimizing Database Performance

 

o        Optimizing  The Performance

o        The Flash Memory Usage

o        Compression _Usage

o        Index_ Usage

o        Minimum Extent- Size

o        Optimizing Database Performance with  the Exadata

Using Smart Scan

 

o        Exadata Smart Scan

o        Requirements Of Smart Scan

o        Monitoring  the SmartScan in SQL Execution Plans

o        Smart Scan Join Processing with the Bloom Filters

o        Other Situations Affecting  the Smart Scan

o        Exadata Storage Server Statistics

o        Exadata Storage Server Wait Events

o        Using Of Smart Scan

Consolidation Options & Recommendations

 

o        Consolidation: Basic Overview

o        Types Of Different Consolidation 

o        Recommended Storage Configuration for Consolidation

o        Alternative -Storage Configurations

o        Options  of ClusterConfiguration

o        Isolating  Of ManagementRoles

o        The Schema Consolidation Recommendations

o        Maintenance Of  Considerations

Migrating The Databases to Exadata Database Machine

 

o        Migration Best Practices

o        Performing  the CapacityPlanning

o        Choosing Of  RightMigration Path

o        Logical Migration _Approaches

o        Physical Migration_ Approaches

o        The Post-Migration Best Practices

o        Migrating the  Databases Machine Using Transportable

Bulk Data LoadingUsing  the Oracle DBFS

 

o        Bulk Data Loading Using Oracle DBFS: Basic Overview

o        Preparing Of  DataFiles

o        Staging Of  Data Files

o        Configuring Of Staging Area

o        Configuring Of Target Database

o        Loading Of  TargetDatabase

o        Bulk Data Loading Using The  Oracle DBFS

Exadata DatabaseMachine Platform Monitoring

 

o        Monitoring Technologies & Standards

o        Simple Network Management Protocol

o        Intelligent Platform Management Interface

o        Integrated Lights Out Manager

o        Exadata Storage Server Metrics, Thresholds, &Alerts

o        Automatic Diagnostic Repository

o        The Enterprise Manager Grid Control

o        The Enterprise Manager Database Control

Configuring EnterpriseManager Grid Control 11g to Monitor Exadata Database Machine

 

o        Grid Control Monitoring Architecture for  The Exadata Database Machine

o        Configuring Grid Control to Monitor The  Exadata Database Machine

o        Deploying Of Oracle Management Agent

o        Configuring ASM &  Oracle Database Targets

o        Deployment Of System Monitoring Plug-ins

o        Recommended Plug-in  For Deployment Strategy

o        Switch

Monitoring Of ExadataStorage Servers

 

o        Exadata Metrics & Alerts Architecture

o        Monitoring Exadata Storage Server with the  Metrics

o        Monitoring Exadata Storage Server with the Alerts

o        Monitoring Exadata with the Active Requests

o        Monitoring Exadata Storage Server with Grid Control

o        Monitoring Hardware Failure & Sensor State

o        Monitoring Exadata Storage Server Availability

Exadata DatabaseMachine Maintenance Tasks-Overview

 

o        Powering Database Machine Off /On

o        Safely Shutting Down an Single Exadata Storage Server

o        Replacing an Damaged Physical Disk

o        Replacing an Damaged Flash Card

o        Moving  Of All Disksfrom One Cell to Another

o        Using Of  ExadataCell Software Rescue Procedure

Patching Of ExadataDatabase Machine

 

o        Patching & Updating

o        Maintaining  The ExadataStorage Server Software

o        Maintaining The Database Server Software

o        Assisted Patching Using OPlan

o        Maintaining  Of OtherSoftware

o        Recommended Patching _Process

 

 

Monitoring the Exadata Database Machine Database Servers

 

o        Monitoring Of  Hardware

o        Monitoring Of  Operating System

o        Monitoring TheOracle Grid Infrastructure

o        Monitoring Of Oracle Database

o        Monitoring The Oracle Management Agent

Monitoring InfiniBandNetwork

 

o        Manually Monitoring Of  InfiniBand Switches

o        Monitoring the InfiniBand Switches with the Grid Control

o        Monitoring InfiniBand Switch Ports

o        Monitoring the InfiniBand Ports on The Database MachineServers

o        Monitoring the InfiniBand Fabric: Network Topology &Link Status

The Other UsefulMonitoring Tools

 

o        Exachk

o        Running The  Exachk

o        Exachk Output

o        DiagTools

o        Using Of ADRCI on Exadata Storage Servers

o        Imageinfo

o        Imagehistory

o        OSWatcher

Monitoring Of OtherExadata Database Machine Components

 

o        Monitoring Cisco Catalyst Ethernet Switch

o        Monitoring Sun Power Distribution Units

o        Monitoring  Avocent MergePoint Unity KVM Switch

Backup &  Recovery

 

o        Using RMAN with The Database Machine

o        The General Recommendations for RMAN

o        The Disk-Based Backup Strategy

o        Disk-Based Backup Recommendations

o        Tape-Based Backup Strategy

o        Connecting Media Server Using the Ethernet

o        Backup &  Recovery of Database Machine Software