Oracle Exadata Administrator
Course Duration: 30 Hours
Required Prerequisites
- Basic Knowledge of Oracle SQL
- Basic Knowledge of Oracle DBA
Target Audience
- SQL Developers, PL/SQL Developers and Oracle DBAs who want to gain an in-depth understanding of Oracle SQL Tuning.
Students Enquiry Form
Course Highlights
- Introduction to SQL Tuning
- Setting Up Oracle DB 19c For Practice
- Query Optimizer & Execution Plans
- Indexes
- Oracle Hints
- Optimizer Statistics
- Adaptive Query Optimization
- Cursor Sharing
- Monitoring and Tracing SQL
- SQL Tuning Sets
- SQL Tuning Advisor
- SQL Plan Management
- SQL Access Advisor
- Server Result Cache
- More SQL Tuning Tools
- Partitioning in Oracle Database
Course Content
Section 1: Introduction to Oracle Exadata
- Introduction to Exadata Database Machine
- Why Exadata?
- Evolution of Exadata
- Exadata vs Traditional Oracle Database Infrastructure
- Key Exadata capabilities and benefits
- Exadata use cases
- Exadata terminology and core concepts
- Exadata deployment models
Section 2: Exadata Architecture & Components
- Exadata Database Machine Architecture
- Exadata building blocks
- Database Servers
- Storage Servers / Cell Nodes
- InfiniBand / RoCE Network
- Management Network
- Client Network
- Storage Network
- Exadata software components
- Grid Infrastructure and RAC integration
- ASM and Exadata integration
- High-level request flow in Exadata
Section 3: Exadata Versions & Generations
- Evolution of Oracle Exadata
- Exadata X2, X3, X4, X5, X6, X7
- Exadata X8 and X8M
- Exadata X9M
- Exadata X10M
- Exadata Cloud@Customer overview
- Exadata Database Machine vs Exadata Cloud Infrastructure
- Major architectural and performance improvements across generations
- Version compatibility and upgrade considerations
Section 4: Exadata Machine Types & Sizing
- Exadata Machine types
- Quarter Rack, Half Rack and Full Rack concepts
- Compute capacity
- Storage capacity
- CPU and memory sizing
- Database Server sizing
- Storage Server sizing
- Flash capacity
- Network bandwidth
- Workload-based Exadata sizing
- OLTP vs Data Warehouse sizing
- Capacity and performance considerations
Section 5: Exadata Machine Comparison
- Exadata generation comparison
- X8 vs X8M vs X9M vs X10M
- Compute node comparison
- Storage cell comparison
- CPU and memory comparison
- Flash and persistent storage comparison
- Network architecture comparison
- Performance improvements
- Choosing the appropriate Exadata platform
Section 6: Exadata Hardware Architecture
- Database Server hardware
- Storage Server hardware
- CPU and memory architecture
- Local disks
- Flash devices
- Persistent Memory
- PCIe architecture
- Hardware redundancy
- Power and cooling considerations
- Hardware monitoring
- Hardware failure scenarios
Section 7: Exadata Storage Architecture
- Exadata Storage Cell architecture
- Cell disks
- Grid disks
- ASM disks
- Physical disks and logical storage
- Disk groups
- ASM redundancy
- Normal, High and External redundancy
- Storage Cell services
- Storage server I/O architecture
- Storage expansion
- Storage failure and recovery
Section 8 : OECA & OEDA
- Overview of Exadata Configuration Assistant (OECA)
- Oracle Exadata Deployment Assistant (OEDA)
- OEDA configuration process
- Network configuration
- Database server configuration
- Storage cell configuration
- Grid Infrastructure configuration
- Database configuration
- Configuration files generated by OEDA
- Exadata deployment workflow
- Common OEDA issues and troubleshooting
Section 9 : – Exadata Networking Architecture
- Exadata network architecture
- Client Network
- Management Network
- Storage Network
- InfiniBand architecture
- RoCE architecture
- Private interconnect
- SCAN and SCAN listeners
- VIPs
- Bonding and network redundancy
- DNS configuration
- Hostname resolution
- Network troubleshooting
- Network communication flow
Section 10 : Exadata Database Server Architecture
- Database Server components
- Oracle RAC architecture
- Grid Infrastructure
- ASM
- Database instances
- CRS and cluster resources
- Private interconnect
- Database connectivity
- SCAN listener architecture
- Database server processes
- Exadata-specific database configuration
Section 11: ExaScale Architecture
- Introduction to ExaScale
- ExaScale architecture
- Compute and storage architecture
- Scale-out capabilities
- Storage expansion
- Performance and capacity scaling
- Exadata infrastructure growth considerations
- ExaScale use case
Section 12: Exadata Available Platforms
- Exadata Database Machine
- Exadata X8M / X9M / X10M platforms
- Exadata Cloud@Customer
- Exadata Cloud Infrastructure
- On-premises vs Cloud deployment
- Platform selection
- Migration considerations
Exadata Administration & Practical Modules Module 13 – Exadata Installation & Configuration – Hands-on Practical 1 – Linux Installation
- Linux installation for Exadata environment
- Operating system configuration
- Network configuration
- Hostname and DNS configuration
- User and group configuration
- SSH configuration
- OS prerequisites
- Kernel and system parameter configuration
- Time synchronization
- Verification and validation
Section 14: SQL Plan Management
- SQL Plan Baselines
- Using SQL Outlines and Migrating them to SQL Plan Baselines
- SQL Management Base (SMB)
Section 15: SQL Access Advisor
- What is SQL Access Advisor
- How to User it.
- Difference between SQL Access Advisor and SQL Tuning Advisor
Section 16: Server Result Cache
- Using Server Result Cache
- Memory Configuration
Section 17: More SQL Tuning Tools
- SQL Performance Analyzer
- SQL Tuning Health – Check scripts (SQLHC)
Section 18: Partitioning in Oracle Database
- What is Partitioning and why it improves SQL performance
- Partition Pruning (Static vs Dynamic)
- Local vs Global Indexes
- Impact of partitioning on execution plans
- Types of Partitioning
- Range Partitioning
- List Partitioning
- Hash Partitioning
- Composite Partitioning
- Range-Hash
- Range-List
- List-Hash
- Interval Partitioning
- Partitioning Enhancements in 19c
- Automatic interval partition maintenance
- Improved partition pruning