Email Us :

CourseOracle Exadata
Time converter at
Cost Of The TrainingINR: 10,000
Total Duration2 Weeks
Each Session---
Start Date And Time---

Course Description

1. Exadata Database Machine Initial Configuration
   Database Machine Implementation: Overview
   Additional Configuration
   Post Installation
   Using Oracle Exadata Deployment Assistant (OEDA)
   DBM Hardware Installation: Overview
   OneCommand Process overview
   Supported Additional Configuration Activities
   Unsupported Configuration Activities
2. Powering Database Machine ON/OFF
   Powering Database Machine On
   Powering Database Machine Off
   Shutting Down a Single Exadata Storage Server
   Starting a Single Exadata Storage Server
3. 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
   Testing Automatic Exadata Storage Management Features
   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
4. 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
5. 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
   Virtual Columns
   Other Non-Smart Scan Optimizations
   Smart/Fast File creation
   RMAN Incremental Backup
   RMAN Backup Restores
6. 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
7. Exadata Storage Indexes
   Overview of Exadata Storage Indexes
   Conceptual view of Storage Indexes
   Requirements for Storage Indexes
   Statistics related to Storage Indexes
8. 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
9. 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 Cloud Control 12c
10. Monitoring Exadata Storage Servers
   Exadata Metrics and Alerts Architecture
   Monitoring Exadata Storage Server with Metrics and Alerts
   Listing Metric definition and current metrics
   Listing Alert history, Active Requests
   Listing & Setting thresholds
11. Other Useful Monitoring Tools
   Exachk: Overview
   Running Exachk
   Exachk Daemon
   DiagTools: Overview
   Using ADRCI on Exadata Storage Servers
   Imageinfo: Overview
   Image history: Overview
   OSWatcher: Overview
12. Exadata Database Machine Backup and Recovery
   DBM Backup & Recovery Overview
   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
13. Patching & Updating Exadata Database Machine
   Patching and Updating: Overview
   Rolling Vs Non-Rolling Methods
   Maintaining Database Server Software
   Bundle Patches, QDPE, QFSDP
   Assisted Patching Using OPlan
   Maintaining Exadata Storage Server Software
   Understanding Internals of Storage Server Patching
   Maintaining Firmware/Software on Other Components of DBM
   Recommended Patching Process
   Test System Recommendations
   Understanding Application Downtime requirements for various Patching activities on DBM
14. 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 Database Machine Using Transportable Tablespaces
15. 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
16. Exadata Database Machine Maintenance Tasks
   Database Machine Maintenance: Overview
   Replacing a Damaged Physical Disk
   Replacing a Damaged Flash Card
   Moving All Disks from One Cell to Another
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

Thank You