Oracle Exadata
CloudLabs
Projects
Assignment
24x7 Support
Lifetime Access
.
Course Overview
Oracle Exadata is a database appliance with support for both OLTP (transactional) and OLAP (analytical) database systems. It was initially designed in collaboration between Oracle Corporation and Hewlett Packard. Oracle designed the database, operating system (based on the Oracle Linux distribution), and storage software whereas HP designed the hardware for it. After Oracle’s acquisition of Sun Microsystems, in 2010 Oracle announced the Exadata Version 2 with improved performance and Sun storage systems.
At the end of the training, participants will be able to:
Pre-requisite
- General storage and systems administration
- Oracle RAC/ASM DBA
- Oracle Enterprise Linux: System Administration
- Relevant Hardware Training
- Networking (inc. Infiniband)
- Oracle Enterprise Manager 11g: Grid Control Essentials
- Oracle 11g: RAC and Grid Infrastructure Overview Seminar Release 2
- Oracle Database 11g: Administration Workshop II Release 2
- Oracle Database 11g: Administration Workshop I Release 2
Duarion
5 days
Course Outline
- Course Objectives
- Audience and Prerequisites
- Course Contents
- Terminology
- Additional Resources
- Introducing the Laboratory Environment
- Introducing Database Machine
- Introducing Exadata Storage Server
- Exadata Storage Server Architecture: Overview
- Exadata Storage Server Features: Overview
- Database Machine Capacity
- Exadata Storage Expansion Racks
- InfiniBand Network
- Database Machine Support: Overview
- Database Machine Architecture: Overview
- Database Machine Network Architecture
- InfiniBand Network Architecture
- X2-2 Full Rack Leaf Switch Topology
- Spine and Leaf Topology
- Scale Performance and Capacity
- Database Machine Software Architecture: Overview
- Disk Storage Entities and Relationships
- Classic Database I/O and SQL Processing Model
- Exadata Smart Scan Model
- Exadata Smart Storage Capabilities
- Exadata Hybrid Columnar Compression Data Organization
- Exadata Smart Flash Cache Intelligent Caching
- Storage Index with Partitions
- Database File System
- I/O Resource Management: Overview
- Database Machine Implementation: Overview
- General Configuration
- Choosing the Right Protection Level
- Oracle Enterprise Manager Grid Control Configuration
- Database Machine Hardware Installation: Overview
- Configuring Oracle Exadata Database Machine: Overview
- Selecting the Database Server Operating System
- Deploying Solaris on the Database Servers
- Exadata Storage Server Administration: Overview
- Testing Storage Server Performance Using CALIBRATE
- Configuring the Exadata Cell Server Software
- Creating Flash-Based Grid Disks
- Creating Smart Flash Log
- Configuring ASM and Database Instances to Access Exadata Cells
- Exadata Storage Security: Overview
- Exadata Storage Security Implementation
- I/O Resource Management: Overview
- IORM Architecture
- Getting Started with IORM
- Enabling Intradatabase Resource Management
- Setting Database I/O Utilization Limits
- Interdatabase Plans and Database Roles
- Using Database I/O Metrics
- IORM and Exadata Storage Server Flash Memory
- Optimizing Performance
- Flash Memory Usage
- Compression Usage
- Index Usage
- ASM Allocation Unit Size
- Minimum Extent Size
- Optimizing Database Performance with Exadata
- Exadata Smart Scan: Overview
- Smart Scan Requirements
- Monitoring Smart Scan in SQL Execution Plans
- Smart Scan Join Processing with Bloom Filters
- Other Situations Affecting Smart Scan
- Exadata Storage Server Statistics: Overview
- Exadata Storage Server Wait Events: Overview
- Using Smart Scan
- Consolidation: Overview
- Different Consolidation Types
- Recommended Storage Configuration for Consolidation
- Alternative Storage Configurations
- Cluster Configuration Options
- Isolating Management Roles
- Schema Consolidation Recommendations
- Maintenance Considerations
- 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 Databases Machine Using Transportable
- 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
- Bulk Data Loading Using Oracle DBFS
- 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 Grid Control
- Enterprise Manager Database Control
- Enterprise Manager Grid Control Architecture: Overview
- Grid Control Monitoring Architecture for Exadata Database Machine
- Configuring Grid Control to Monitor Exadata Database Machine
- Deploying the Oracle Management Agent
- Configuring ASM and Oracle Database Targets
- Deployment Overview for System Monitoring Plug-ins
- Recommended Plug-in Deployment Strategy
- Switch
- Exadata Metrics and Alerts Architecture
- Monitoring Exadata Storage Server with Metrics
- Monitoring Exadata Storage Server with Alerts
- Monitoring Exadata with Active Requests
- Monitoring Exadata Storage Server with Grid Control: Overview
- Monitoring Hardware Failure and Sensor State
- Monitoring Exadata Storage Server Availability
- Comparing Metrics Across Multiple Storage Servers
- Monitoring Database Servers: Overview
- Monitoring Hardware
- Monitoring the Operating System
- Monitoring Oracle Grid Infrastructure
- Monitoring Oracle Database
- Monitoring Oracle Management Agent
- InfiniBand Network Monitoring: Overview
- Manually Monitoring the InfiniBand Switches
- Monitoring the InfiniBand Switches with Grid Control
- Monitoring the InfiniBand Switch Ports
- Monitoring the InfiniBand Ports on Database Machine Servers
- Monitoring the InfiniBand Fabric: Subnet Manager Master Location
- Monitoring the InfiniBand Fabric: Network Topology and Link Status
- Monitoring the Cisco Catalyst Ethernet Switch
- Monitoring the Sun Power Distribution Units
- Monitoring the Avocent MergePoint Unity KVM Switch
- Exachk: Overview
- Running Exachk
- Exachk Output
- DiagTools: Overview
- Using ADRCI on Exadata Storage Servers
- Imageinfo: Overview
- Imagehistory: Overview
- OSWatcher: Overview
- Using RMAN with Database Machine
- General Recommendations for RMAN
- Disk-Based Backup Strategy
- Disk-Based Backup Recommendations
- Tape-Based Backup Strategy
- Tape-Based Backup Architecture
- Connecting the Media Server Using Ethernet
- Backup and Recovery of Database Machine Software
- Database Machine Maintenance: Overview
- Powering Database Machine Off and On
- Safely Shutting Down a Single Exadata Storage Server
- Replacing a Damaged Physical Disk
- Replacing a Damaged Flash Card
- Moving All Disks from One Cell to Another
- Using the Exadata Cell Software Rescue Procedure
- Patching and Updating: Overview
- Maintaining Exadata Storage Server Software
- Maintaining Database Server Software
- Assisted Patching Using OPlan
- Maintaining Other Software
- Recommended Patching Process
- Test System Recommendations
Reviews
"The corporate training provided by Greater Insights was truly exceptional. The trainers were highly knowledgeable and engaging, making the sessions both informative and enjoyable. I gained valuable insights and practical skills that I immediately applied in my work. I highly recommend Greater Insights for their professionalism and expertise."
Rahul NiraniaSamsung 
"As a participant of the corporate training program organized by Greater Insights, I was thoroughly impressed with the level of customization they offered. They took the time to understand our specific needs and tailored the training accordingly. The trainers were fantastic, and the interactive sessions fostered an environment of active learning. I am grateful for the valuable knowledge and skills I acquired."
Bhawna TiwariSamsung 
"I cannot express enough gratitude to Greater Insights for the outstanding corporate training they provided. The trainers were not only experts in their respective fields but also incredible communicators. They created a dynamic and collaborative learning environment, which allowed us to learn from one another. The training surpassed my expectations, and I would eagerly participate in any future programs they offer."
Ashutosh SinghSamsung 
"Attending the corporate training sessions organized by Greater Insights was a game-changer for me. The trainers were not only experienced professionals but also inspiring mentors. They equipped me with practical tools and strategies that have significantly enhanced my productivity and efficiency at work. I wholeheartedly recommend Greater Insights to anyone looking to excel in their professional endeavors."
Somashekar MuniyappaInfogain 
"The corporate training program offered by Greater Insights was an enlightening experience. The trainers had a deep understanding of the subject matter and were able to break down complex concepts into easily digestible information. The interactive activities and case studies made the training engaging and relevant to our day-to-day work challenges. This training has undoubtedly boosted my confidence and competence."
Amresh DiwanInfogain 
"I had the privilege of participating in a corporate training program organized by Greater Insights, and I must say it was a transformative experience. The trainers' expertise and passion for their subjects were evident in every session. The training materials provided were comprehensive and well-structured, enabling us to grasp the content effectively. I am grateful for the valuable skills I acquired, which have greatly contributed to my professional growth."
Namratha BabuTorry Harris 
"The corporate training sessions conducted by Greater Insights were simply outstanding. The trainers went above and beyond to ensure that we understood the concepts thoroughly. The interactive nature of the sessions encouraged active participation and enhanced our learning experience. I am truly grateful for the practical strategies and techniques I learned, which have had a positive impact on my work performance."
Rahul BhashyamTorry Harris 
"Participating in the corporate training program organized by Greater Insights was an enlightening experience. The trainers were not only knowledgeable but also skilled at delivering the content in an engaging manner. The training materials were well-designed, and the real-life examples provided valuable insights. I am confident that the knowledge and skills I gained will significantly contribute to my professional growth."
Deepti JainTorry Harris 
"I can confidently say that the corporate training provided by Greater Insights was top-notch. The trainers were highly experienced and had a knack for simplifying complex concepts. The training sessions were interactive and encouraged open discussions, which fostered a collaborative learning environment. The practical skills I acquired during the training have proven to be invaluable in my day-to-day work."
HARSHAL TRIVEDIL&T TS 
"Greater Insights exceeded my expectations with their corporate training program. The trainers were not only experts in their fields but also exceptional communicators. They effortlessly connected with the participants and ensured everyone's active involvement. The training content was comprehensive and provided a solid foundation for professional growth. I am grateful for the opportunity to learn from such seasoned professionals."
Namrata PillayL&T TS
"The corporate training facilitated by Greater Insights was exceptional in every aspect. The trainers were engaging and created a positive and inclusive learning environment. The training materials were well-structured and easy to follow, making the learning process enjoyable. The practical exercises and case studies allowed me to apply the knowledge immediately, resulting in improved job performance. I highly recommend Greater Insights for their commitment to excellence."
Sandhya M SanuHoneywell
"I recently attended a corporate training program organized by Greater Insights, and I am incredibly impressed. The trainers were not only knowledgeable but also highly skilled at delivering the content in a relatable manner. The training sessions were interactive and encouraged open dialogue, which made the learning experience engaging and dynamic. The practical skills I gained have already made a significant impact on my professional growth."
Neha SahayHoneywell
"I had the privilege of participating in a corporate training program conducted by Greater Insights, and it was truly transformative. The trainers were passionate and dedicated professionals who took the time to address our individual needs. The training sessions were interactive and encouraged active participation, allowing us to learn from one another's experiences. I am grateful for the knowledge and skills I acquired, which have undoubtedly propelled my career forward."
Abishek KalliparambilAllianz 
"The corporate training program offered by Greater Insights was a remarkable experience. The trainers had a wealth of knowledge and were adept at imparting it effectively. The training materials were comprehensive and provided valuable resources for further exploration. The interactive activities and practical exercises helped me internalize the concepts and apply them in real-world scenarios. This training has been instrumental in my professional development."
Kishor KumarITC Infotech 
"I cannot thank Greater Insights enough for the incredible corporate training they provided. The trainers were not only subject matter experts but also skilled at creating a positive and inclusive learning environment. The training sessions were well-structured, and the trainers ensured that we understood the content thoroughly. I am grateful for the valuable insights and skills I gained, which have already made a noticeable difference in my professional life."
Anitha PrashanthIndegene 
Previous
Next
