Course Instructor

The course Instructor, Muralidhar Punyala, is an IT professional with 23 years of global IT experience. Murali worked with various global organizations in countries like USA, UK, Singapore, Hong Kong and India. Currently, Murali is the Director at Uclid IT School and previously worked as Practice Manager at Oracle India.

Course Curriculum

1. Introduction

• Course Objectives
• Prerequisites
• Course Contents
• Terminology
• Introducing the Laboratory Environment

2. Exadata Database Machine Overview

• What is Exadata?
• Exadata Storage Server Features: Overview
• Exadata Vs Traditional Storage Servers
• What is the Exadata Database Machine (DBM)?
• Components of Database Machine
• DBM Configurations
• DBM Versions/Generations
• DBM Hardware: Overview
• DBM Software: Overview
• DBM Scalability
• Exadata Storage Expansion Racks
• Exadata Elastic Configurations
• Why Database Machine?

3. Exadata Database Machine Architecture

• Database Machine Architecture: Overview
• Database Machine Software Architecture
• Exadata Storage Server Processes
• DB to Cell Communication
• Database Machine Network Architecture
• InfiniBand Network Architecture
• InfiniBand Network Topology
• InfiniBand Network External Connectivity
• Overview of iDB & RDS Protocols
• ILOM overview

4. Exadata Storage Server (Cell) Concepts

• Cell User Accounts
• Cell Processes
• Cell Log Files
• Cell Utilities – CellCLI, DCLI
• Exadata Storage Overview
• Storage Objects in Exadata
• Disk Layout in Exadata Cell
• Disk Storage and Flash Storage
• Disk Storage Objects and their Relationships
• Flash Storage Objects and their Relationships
• Cell Disks, Grid Disks, ASM Disks, ASM Diskgroups
• ASM Mirroring and Failure groups

5. Exadata Storage Server (Cell) Administration

• Exadata Storage Server Administration: Overview
• Configuring DB Servers to access Exadata Cells
• Configuring ASM and Database Instances to Access Exadata Cells
• Configuring Cell Server to send E-mail notifications
• Starting/Stopping Cell Services
• Configuring DCLI utility on Cell nodes & DB nodes
• Adding Physical Disks & Flash Disks to the Cell Server
• Creating Hard Disk & Flash Disk-based Cell Disks
• Creating Grid Disks based on Hard Disks & Flash Disks
• Creating ASM Diskgroups using Grid Disks based on Hard Disks & Flash Disks
• Reconfiguring Flash Storage
• Dropping Flash Cache & Flash Log
• Recreating Flash Cache & Flash Log
• Online Reconfiguration of Exadata Storage
• Recommended Storage Configuration for Consolidation
• Alternative Storage Configurations
• Auto Disk Management Concepts in Exadata
• Testing Automatic Exadata Storage Management Features

6. Exadata Smart Flash Cache & Flash Log

• Use of Flash Storage in Exadata
• Overview of Exadata Smart Flash Cache & Flash Log
• Overview of Intelligent Caching
• Influencing the Caching decisions
• Write-Through Flash Cache mode
• Write-Back Flash Cache mode
• Observing the Cached Objects

7. Exadata Smart Scan / Offloading

• Overview of Exadata Smart Scan feature
• Traditional I/O and SQL Processing
• Exadata Smart Scan processing
• Smart Scan Requirements
• Smart Scan disablers
• Observing Smart Scan operations in Query Execution Plans
• Statistics & Wait Events related to Smart Scan
• Other Smart Scan Optimizations
• Compression/Decompression
• Encryption/Decryption
• Virtual Columns
• Other Non-Smart Scan Optimizations
• Smart/Fast File creation
• RMAN Incremental Backup
• RMAN Backup Restores

8. Exadata Hybrid Columnar Compression

• Compression Methods in Oracle
• Basic Compression, OLTP compression
• Exadata Hybrid Columnar Compression (EHCC)
• Data organization using EHCC
• Compression Unit
• EHCC Types
• Warehouse Compression
• Archival Compression
• Enabling EHCC
• DMLs on EHCC Tables
• Comparing different Compression Methods

9. Exadata Storage Indexes

• Overview of Exadata Storage Indexes
• Conceptual view of Storage Indexes
• Requirements for Storage Indexes
• Statistics related to Storage Indexes

10. Exadata I/O Resource Management (IORM)

• I/O Resource Management Concepts
• IORM Architecture
• Intradatabase Vs Interdatabase plans
• Setting IORM objective
• Implementing Intradatabase plans (DB Plans)
• Implementing Interdatabase Plans (IORM Plans)
• DB Plans, Category Plans
• Using Database I/O Metrics
• IORM and Exadata Storage Server Flash Memory

11. Monitoring Exadata Storage Servers

• Monitoring Exadata Storage Server with Metrics and Alerts
• Exadata Metrics and Alerts Architecture
• Listing Metric definition and current metrics
• Listing Alert history, Active Requests
• Listing & Setting thresholds

12. Other Useful Tools

• Exachk
• Running Exachk
• Exachk Daemon
• DiagTools
• Using ADRCI on Exadata Storage Servers
• Imageinfo & Image history
• OSWatcher
• ExaWatcher

13. Exadata Database Machine Backup and Recovery

• DBM Backup & Recovery Overview
• Managing Online Redo Log Files
• Backup of Software on DB nodes
• Recovering DB nodes using LVM snapshot based Backups
• Reimaging a DB node
• Overview Cell Backup
• Understanding Cell Disk Layout
• Cell System Volumes
• Creating Cell Rescue Image using External USB
• Recovering Storage Server
• Cell Rescue Procedure
• Reimaging Cell Server
• Using RMAN to perform Database backups on DBM
• Understanding Read I/O optimizations provided by Exadata for RMAN incremental backups
• Understanding Recovery Optimizations provided by Exadata for RMAN
• General Recommendations for RMAN
• Disk-Based Backup Strategy
• Disk-Based Backup Recommendations
• Disk-Based Backup on non-Exadata storage
• Tape-Based Backup Strategy
• Tape-Based Backup Architecture and Recommendations

14. Patching & Updating Exadata Database Machine

• Patching and Updating: Overview
• Rolling Vs Non-Rolling Methods
• Maintaining Database Server Software
• Bundle Patches, QDPE
• Maintaining Exadata Storage Server Software
• Understanding Internals of Storage Server Patching
• Maintaining Firmware/Software on Other Components of DBM
• Recommended Patching Process

15. Migrating Databases to Exadata Database Machine

• Migration Best Practices: Overview
• Database Machine Migration Considerations
• Choosing the Right Migration Path
• Logical Migration Approaches
• Physical Migration Approaches
• Post-Migration Best Practices

16. 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

17. Exadata Storage Security

• Overview of Exadata Storage Security
• Exadata Storage Open Security
• Overview of ASM Scoped Security
• Overview of Database-Scoped Security
• Implementing ASM Scoped Security
• Implementing Database-Scoped Security

18. Exadata Database Machine Maintenance Tasks

• Powering Database Machine On
• Powering Database Machine Off
• Shutting Down a Single Exadata Storage Server
• Starting a Single Exadata Storage Server
• Replacing damaged Physical Disk
• Replacing damaged Flash card

Requirements

• A Windows, Linux or Mac PC/Laptop with Internet Connection
• Working knowledge on Unix/Linux
• Oracle Database Administration
• Oracle Real Application Clusters
• Oracle ASM

Key Features

• High-quality training
• Hands-on practices for every lesson
• Access to session recordings
• Training by Real-time & Hands-on Exadata expert
• In-depth coverage and thorough explanation of all lessons

FAQ

1. What about Lab practice?

You can practice all the lab sessions on our pre-configured Exadata Lab.

2. How do I access Lab?

You can use our VPN based access to connect to the Lab and practice.

3. For how long Lab access is provided?

Lab access will be provided for 5 weeks from the start date of the Training. If required, you can further extend the lab access by paying additonal monthly access fee. Please contact us for more details.

4. What if I miss a session?

We provide recordings of each session you attend for future reference.

5. What if I discontinue the training in between?

You can attend any future training that suits your schedule.