1000+ Unique Technologies Projects Delivered | 500+ Corporate Customers Worldwide | 50000+ Professionals Trained on 40+ Domains in Over 30 Countries | Just Launched B2I Offerings | Live, Instructor-led.

Exadata Database

This web-based training course on Exadata Database functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.

Exadata Database Machine Administration Course introduces trainees to Oracle’s Exadata Database Machine 12c Administration online, providing knowledge about the features and configurations included in this framework. It also emphasizes the unique features availed by Exadata Storage Server. The participants learn how they can configure, implement and maintain these tools for a variety of purposes.

Reviews , Learners(390)



Course Details

Exadata Administration online training is designed to deliver the maximum efficiency and efficacy to your organization’s Exadata database machines through understanding and implementation of the best practices. Prerequisites for this course are basic knowledge of Unix/Linux, networking, system administration and storage.


Overview

  • Database Machine
  • Storage Server
  • Capacity
  • Storage-expansion racks
  • Support

Framework

  • Architecture
  • Infiniband Network
  • X2-2 Full Rack Leaf Switch
  • Spine and Leaf
  • Scale performance/capacity
  • Software architecture
  • Entities/Relationships in Disk Storage

Capabilities

  • Classic Database I/O
  • SQL Processing Model
  • Smart Scan
  • Smart Storage
  • Hybrid Columnar Compression Data Organization
  • Smart Flash Cache
  • Storage index/partitions
  • Database file system
  • Managing I/O resources

Initial Configuration

  • Implementation
  • General Configuration
  • Protection
  • Grid Control
  • Hardware
  • Database server OS
  • Database serversSolaris deployment

Storage Server Configuration

  • Administration
  • CALIBRATE
  • Cell Server Software
  • Flash-based grid disk
  • Smart Flash log
  • ASM, Database Instances Cell Access
  • Storage Security

I/O Resources

  • Managing I/O
  • IORM
  • Intra-database Resource Management
  • Database I/O Usage
  • Inter-database plans, Database roles
  • Database I/O Metrics
  • IORM, Storage Server Flash Memory

Performance Optimization

  • Flash Memory
  • Compression
  • Index
  • ASM Allocation Unit
  • Minimum extent size
  • Exadata Database Optimization

Smart Scan

  • Monitoring in SQL Execution Plans
  • Join Processing with Bloom Filters
  • Other situations
  • Storage Server Statistics
  • Storage Server Wait Events
  • Use

Consolidation

  • Types
  • Recommended/alternative configuration
  • Cluster configuration
  • Management role isolation
  • Recommended schema consolidation
  • Maintenance

Oracle DBFS Bulk Data Loading

  • Data files preparation
  • Staging data files
  • Staging area
  • Target database
  • Bulk Data Loading

Platform Monitoring

  • SNMP
  • IPMI
  • ILOM
  • Storage server metrics, thresholds, alerts
  • ADR
  • Grid Control
  • Database Control

Grid Control 11g Configuration

  • Architecture
  • Oracle Management Agent
  • ASM, Oracle Database Targets
  • System monitoring plugins
  • Plugin deployment
  • Switch

Monitoring Storage Servers

  • Metrics/alerts
  • Active requests
  • Grid Control
  • Hardware Failure, Sensor State
  • Storage Server Availability
  • Metrics in multiple servers

Monitoring Database Servers

  • Hardware
  • OS
  • Grid Infrastructure
  • Oracle Database
  • Management Agent

InfiniBand Network Monitoring

  • Manual switch monitoring
  • Grid Control
  • Switch Ports
  • Subnet manager master location
  • Network topology, link status

Other Components

  • Cisco Catalyst Ethernet
  • Sun Power Distribution Units
  • Avocent MergePoint Unity KVM

Other Tools

  • Exachk
  • DiagTools
  • ADRCI
  • Imageinfo
  • Imagehistory
  • OSWatcher

Backup/Recovery

  • RMAN
  • Disk-based
  • Tape-based
  • Media Server Ethernet connection
  • Software backup/recovery

Maintenance

  • On/Off
  • Shutdown on a single storage server
  • Physical Disk/flash card replacement
  • Disk movement between cells
  • Cell Software Rescue

Patching

  • Patching/Updating
  • Software Maintenance
  • OPlan

Our Clients

B2B Technical Trainings Projects Delivered


Read More