Exadata Training
Exadata Training in Bangalore
DSMINFOTECH is a software training institute located in Bangalore that offers training in Oracle Exadata. The training covers the basics of Exadata, as well as advanced topics, to help students become proficient in using the tool for database management.
Some of the topics covered in the Oracle Exadata course at DSMINFOTECH include:
- Introduction to Oracle Exadata
- Exadata Architecture and Components
- Exadata Storage Server Software
- Oracle Database on Exadata
- Exadata Storage Cell Software
- Exadata Smart Scan and Storage Indexes
- Oracle Real Application Clusters on Exadata
- Exadata Performance Tuning and Monitoring
DSMINFOTECH has experienced trainers who use a combination of lectures, hands-on labs, and real-world case studies to help students understand the concepts and apply them in practical scenarios. The course duration, fees, and other details may vary, so it is best to check with DSMINFOTECH directly for the latest information.
Get In Touch
Exadata Course 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
Interconnecting Quarter racks and Eight racks
- Infiniband Network External Connectivity
- Database Machine Software Architecture: Overview
- Disk Storage Entities and Relationships
- Flash Storage Entities and relationships
- Diskgroup configuration
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
- Using exadata Smart flash cache : Write-Through cache
- Using Exadata smart flash cache : Write – back cache
- Exadata smart Flash log
- Exadata Storage index :overview
- 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 Output
- DiagTools: Overview
- Using ADRCI on Exadata Storage Servers
- Imageinfo: Overview
- Imagehistory: Overview
- OSWatcher: Overview
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
- Battery replacement
- Fault processor replacement
Patching Exadata Database Machine
- Patching and Updating: Overview
- Maintaining Exadata Storage Server Software
- Maintaining Database Server Software
- Assisted Patching Using OPlan
- Maintaining Other Software
- Recommended Patching Process
- Test System Recommendations
Exadata database machine automated support Ecosystem
- Auto Service request :overview
- ASR process
- ASR requirement
- Configure to ASR manager
- Configuring Exadata database machine for ASR
- Activating ASR Assets
- Verifying the ASR Configuration
- Oracle configuration manager : overview
- Configuring oracle configuration Manager