FOR FREE DEMO contact :
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
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
