Preview unavailable

Course Materials (Downloadable)

• Slides

• Lab Guide

Basics of Oracle Exadata Database Machine

• What is Exadata?

• Exadata Architecture

• Exadata Network Architecture

• About RDMA

• About ILOM

• Exadata Versions

• Exadata Configurations

Installing and Configuring VPN to Access Exadata Lab Servers

• Instructions to Install and Setup VPN Access

Working with Exadata Lab

• ***Lab Practice: How to connect to Exadata Lab?

• ***Lab Practice: Becoming Familiar with Exadata Lab Environment

Exadata Storage Server

• About Exadata Storage Server

• About Exadata System Software

• About Celladmin and Cellmonitor Accounts

• About Exadata System Software Utilities

• Overview of CellCLI Utility

• ***Lab Practices: Cell Accounts and CellCLI Utility

• Overview of DCLI Utility

• ***Lab Practice: Configuring DCLI on Cell nodes

• ***Lab Practice: Using DCLI on Cell nodes

• ***Lab Practices: Configuring and Using DCLI on DB Nodes

Exadata Storage Management

• Overview of Exadata Storage Objects

• ***Lab Practices: Exadata Storage Objects

• Overview of Initial Storage Configuration on Exadata

• Overview of creating Cell Disks, Grid Disks, and ASM Disk Groups

• ***Lab Practice: Creating Cell Disks, Grid Disks and ASM Diskgroups

• Overview of Exadata Storage Reconfiguration

• *** Lab : Part 1 of 3 - Performing Online Storage Reconfiguration

• *** Lab : Part 2 of 3 - Performing Online Storage Reconfiguration

• *** Lab: Part 3 of 3 - Performing Online Storage Reconfiguration

Exadata Storage Security

• Overview of Exadata Storage Security

• *** Lab : Implementing ASM Scoped Storage Security

• *** Lab : Implementing Database Scoped Storage Security

Flash Cache and Flash Log

• Overview of Flash Cache and Flash Log

• ***Lab Practices: Flash Cache and Flash Log

• Flash Cache Modes - Writethrough and Writeback

• ***Lab Practices: Configuring Write-back and Write-through Flash Cache modes

Hybrid Columnar Compression

• Overview of Hybrid Columnar Compression

• ***Lab Practice: Implementing Hybrid Columnar Compression

Smart Scan

• Overview of Smart Scan

• ***Lab Practices: Smart Scan

Storage Indexes

• Overview of Storage Index

• ***Lab Practice: Storage Index

Exadata I/O Resource Management (IORM)

• Overview of IORM

• ***Lab Practices: IORM

Updating Software on Exadata Database Machine (Exadata Patching)

• Overview of Updating Software on Exadata Database Machine

• Overview of Updating GI & DB Software

• ***Lab Practice: Updating Oracle GI & DB Software

• Overview of Updating Exadata System Software

• Updating Exadata Software on Database Servers

• Updating Exadata Software on Storage Servers

• Updating Firmware on RoCE Switches

Monitoring Exadata Performance

• Using Database Statistics and Wait Events

• Using AWR

• Using Exadata Metrics, Alerts and Active Requests

• Using ExaWatcher

• ***Lab Practice: Monitoring Exadata Performance

Other useful Tools/Utilities

• DBMCLI

• ExaCLI

• ExaDCLI

• EXAchk

Exadata Maintenance Tasks

• Exadata Maintenance Tasks