+91 88606 33966            edu_sales@siriam.in                   Job Opening : On-site Functional Trainer/Instructor | Supply Chain Management (SCM)

Siriam

Making Intellectuals Meet Excellence!

Oracle Exadata Database Machine: Implementation and Administration
Placeholder
Oracle

Oracle Exadata Database Machine: Implementation and Administration

Richa Arora Richa Arora
Overview
Curriculum
  • 20 Sections
  • 138 Lessons
  • 40h Duration
Collapse All
Exadata Database Machine Overview
7 Lessons
  1. Introducing Database Machine
  2. Introducing Exadata Storage Server
  3. Exadata Storage Server Architecture: Overview
  4. Exadata Storage Server Features: Overview
  5. Exadata Storage Expansion Racks
  6. InfiniBand Network
  7. Database Machine Support: Overview
Exadata Database Machine Architecture
7 Lessons
  1. Database Machine Architecture: Overview
  2. Database Machine Network Architecture
  3. InfiniBand Network Architecture
  4. InfiniBand Network Topology
  5. Interconnecting Multiple Racks
  6. Database Machine Software Architecture: Overview
  7. Disk Storage Entities and Relationships
Key Capabilities of Exadata Database Machine
8 Lessons
  1. Classic Database I/O and SQL Processing Model
  2. Exadata Smart Scan Model
  3. Exadata Smart Storage Capabilities
  4. Exadata Hybrid Columnar Compression
  5. Exadata Smart Flash Cache
  6. Exadata Storage Index
  7. Database File System
  8. I/O Resource Management
Exadata Database Machine Initial Configuration
7 Lessons
  1. Database Machine Implementation: Overview
  2. Database Machine Site Preparation
  3. Using Oracle Exadata Deployment Assistant
  4. Choosing the Right Disk Redundancy Setting
  5. Configuring Oracle Exadata Database Machine
  6. The Result After Installation and Configuration
  7. Supported Additional Configuration Activities
Exadata Storage Server Configuration
8 Lessons
  1. Exadata Storage Server Administration: Overview
  2. Testing Storage Server Performance Using CALIBRATE
  3. Configuring the Exadata Cell Server Software
  4. Starting and Stopping Exadata Cell Server Software
  5. Configuring Cell Disks and Grid Disks
  6. Configuring ASM and Database Instances to Access Exadata Cells
  7. Reconfiguring Exadata Storage
  8. Exadata Storage Security Implementation
I/O Resource Management
8 Lessons
  1. I/O Resource Management Concepts
  2. IORM Architecture
  3. Getting Started with IORM
  4. Enabling Intradatabase Resource Management
  5. Setting Database I/O Utilization Limits
  6. Interdatabase Plans and Database Roles
  7. Using Database I/O Metrics
  8. IORM and Exadata Storage Server Flash Memory
Recommendations for Optimizing DatabasePerformance
8 Lessons
  1. Flash Memory Usage
  2. Influencing Caching Priorities
  3. Choosing the Flash Cache Mode
  4. Compression Usage
  5. Index Usage
  6. ASM Allocation Unit Size
  7. Minimum Extent Size
  8. Exadata Specific System Statistics
Using Smart Scan
7 Lessons
  1. Exadata Smart Scan: Overview
  2. Smart Scan Requirements
  3. Monitoring Smart Scan in SQL Execution Plans
  4. Smart Scan Join Processing with Bloom Filters
  5. Other Situations Affecting Smart Scan
  6. Exadata Storage Server Statistics: Overview
  7. Exadata Storage Server Wait Events: Overview
Consolidation Options and Recommendation
7 Lessons
  1. Consolidation: Overview
  2. Different Consolidation Types
  3. Recommended Storage Configuration for Consolidation
  4. Alternative Storage Configurations
  5. Cluster Configuration Options
  6. Isolating Management Roles
  7. Schema Consolidation Recommendations
Migrating Databases to Exadata Database Machine
8 Lessons
  1. Migration Best Practices: Overview
  2. Performing Capacity Planning
  3. Database Machine Migration Considerations
  4. Choosing the Right Migration Path
  5. Logical Migration Approaches
  6. Physical Migration Approaches
  7. Post-Migration Best Practices
  8. Migrating to Database Machine Using Transportable Tablespaces
Bulk Data Loading using Oracle DBFS
6 Lessons
  1. Bulk Data Loading Using Oracle DBFS: Overview
  2. Preparing the Data Files
  3. Staging the Data Files
  4. Configuring the Staging Area
  5. Configuring the Target Database
  6. Loading the Target Database
Exadata Database Machine Platform Monitoring Introduction
8 Lessons
  1. Enterprise Manager Cloud Control 12c Architecture: Overview
  2. Cloud Control Monitoring Architecture for Exadata Database Machine
  3. Configuring Cloud Control to Monitor Exadata Database Machine
  4. Pre-discovery Configuration and Verification
  5. Deploying the Oracle Management Agent
  6. Discovering Exadata Database Machine
  7. Discovering Additional Targets
  8. Post-discovery Configuration and Verification
Monitoring Exadata Storage Servers
6 Lessons
  1. Exadata Metrics and Alerts Architecture
  2. Monitoring Exadata Storage Server with Metrics and Alerts
  3. Isolating Faults
  4. Monitoring Exadata Storage Server with Enterprise Manager: Overview
  5. Monitoring Hardware Failure and Sensor State
  6. Monitoring Exadata Storage Server Availability
Monitoring Exadata Database Machine Database Servers
7 Lessons
  1. Monitoring Database Servers: Overview
  2. Monitoring Hardware
  3. Monitoring the Operating System
  4. Monitoring Oracle Grid Infrastructure
  5. Monitoring Oracle Database
  6. Monitoring Oracle Management Agent
  7. Database Monitoring with Enterprise Manager Cloud Control 12c
Monitoring the InfiniBand Network
5 Lessons
  1. InfiniBand Network Monitoring: Overview
  2. Monitoring the InfiniBand Switches
  3. Monitoring the InfiniBand Switch Ports
  4. Monitoring the InfiniBand Ports
  5. Monitoring the InfiniBand Fabric:
Monitoring Other Exadata Database Machine Components
3 Lessons
  1. Monitoring the Cisco Ethernet Switch
  2. Monitoring the Sun Power Distribution Units
  3. Monitoring the KVM Switch
Other Useful Monitoring Tools
7 Lessons
  1. Exachk: Overview
  2. Exachk Daemon
  3. DiagTools: Overview
  4. Using ADRCI on Exadata Storage Servers
  5. Imageinfo: Overview
  6. Imagehistory: Overview
  7. OSWatcher: Overview
Backup and Recovery
7 Lessons
  1. Using RMAN with Database Machine
  2. General Recommendations for RMAN
  3. Disk-Based Backup Strategy
  4. Disk-Based Backup Recommendations
  5. Disk-Based Backup on
  6. Tape-Based Backup Strategy
  7. Tape-Based Backup Architecture and Recommendations
Exadata Database Machine Maintenance Tasks
7 Lessons
  1. Database Machine Maintenance: Overview
  2. Powering Database Machine Off and On
  3. Safely Shutting Down a Single Exadata Storage Server
  4. Replacing a Damaged Physical Disk
  5. Replacing a Damaged Flash Card
  6. Moving All Disks from One Cell to Another
  7. Using the Exadata Cell Software Rescue Procedure
Patching Exadata Database Machine
7 Lessons
  1. Patching and Updating: Overview
  2. Maintaining Exadata Storage Server Software
  3. Assisted Patching Using OPlan
  4. Assisted Patching Using
  5. Maintaining Other Software
  6. Recommended Patching Process
  7. Test System Recommendations

Course Description

The Oracle Exadata Database Machine: Implementation and Administration certification is a credential for IT professionals demonstrating expertise in managing and implementing Exadata Database Machines. This certification reflects an individual's proficiency in managing database assets, workload management, disaster recovery, and troubleshooting. It also covers Exadata Storage Server features for optimized database performance and high availability. Industries use individuals with this certification to effectively manage and develop Oracle's engineered systems, which contributes to improved data management and operational efficiency. It's highly valued in sectors such as finance, healthcare, retail, and telecommunication, as it supports creating robust database solutions, promoting data security, and efficient handling of large data volumes.

Course Prerequisites:

 Sound knowledge of Oracle Database 11g
- Proficiency in Oracle Database Administration
- Understanding of Oracle Exadata Storage Server architecture
- Understanding of Linux operating system
- Familiarity with SQL
- Experience in managing Oracle workloads.
- Ability to manage Oracle Exadata Database Machine features and configurations.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Scroll to top