Oracle Exadata Training Course Online

Mindmajix Technologies

Online

₹ 14400 18000

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study, Virtual Classroom	Mode of Delivery Video and Text Based	Frequency of Classes Weekdays, Weekends

Course and certificate fees

Fees information

₹ 14,400 ₹18,000

certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

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
Database Machine Site Preparation
Using Oracle Exadata Deployment Assistant
Choosing the Right Disk Redundancy Setting
Configuring Oracle Exadata Database Machine
The Result After Installation and Configuration
Supported Additional Configuration Activities

Exadata Storage Server Configuration

Exadata Storage Server Administration: Overview
Testing Storage Server Performance Using CALIBRATE
Configuring the Exadata Cell Server Software
Starting and Stopping Exadata Cell Server Software
Configuring Cell Disks and Grid Disks
Configuring ASM and Database Instances to Access Exadata Cells
Reconfiguring Exadata Storage
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
Inter database 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 Cloud Control 12c to Monitor Exadata Database Machine

Enterprise Manager Cloud Control 12c Architecture: Overview
Cloud Control Monitoring Architecture for Exadata Database Machine
Configuring Cloud Control to Monitor Exadata Database Machine
Pre-discovery Configuration and Verification
Deploying the Oracle Management Agent
Discovering Exadata Database Machine
Discovering Additional Targets
Post-discovery Configuration and Verification

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
Database Monitoring with Enterprise Manager Cloud Control 12c

Monitoring The InfiniBand Network

InfiniBand Network Monitoring: Overview
InfiniBand Network Monitoring with
Monitoring the InfiniBand Switches
Monitoring the InfiniBand Switch Ports
Monitoring the InfiniBand Ports
Monitoring the InfiniBand Fabric:
Monitoring the InfiniBand Fabric:

Monitoring Other Exadata Database Machine Components

Monitoring the Cisco Ethernet Switch
Monitoring the Sun Power Distribution Units
Monitoring the 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

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

Patching Exadata Database Machine

Patching and Updating: Overview
Maintaining Exadata Storage Server Software
Maintaining Database Server Software
Assisted Patching Using OPlan
Assisted Patching Using
Maintaining Other Software
Recommended Patching Process
Test System Recommendations

Practice Test & Interview Questions

Instructors

Mr Varun
Instructor
Freelancer

Articles

Trending Courses

Popular Courses

General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Programming Courses Cyber Security Courses Law Courses Digital Marketing Courses Mechanical Engineering Courses Explore all courses

Popular Platforms

upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

Learn more about the Courses

10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management

Open in App

Get the Careers360 App today!

And never miss an important update

Download Careers360 App

All this at the convenience of your phone

Regular Exam Updates
Best College Recommendations
College & Rank predictors
Detailed Books and Sample Papers
Question and Answers

Popular Searches