Oracle Exadata Administrator

• 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
•  

• 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
•  

• 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

• 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

• 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
•  

• 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
•  

• 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

• 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

• 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
•  

• 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
•  

• 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

• Exadata Database Machine
• Exadata X8M / X9M / X10M platforms
• Exadata Cloud@Customer
• Exadata Cloud Infrastructure
• On-premises vs Cloud deployment
• Platform selection
• Migration considerations

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

Practical 2 – Cell Installation & Creation

• Exadata Cell software overview
• Cell server configuration
• Cell initialization
• Cell services
• Cell creation
• CellCLI introduction
• Cell configuration verification
• Cell health checks

Practical 3 – Cell Disk Configuration

• Physical disks
• Cell disks
• Grid disks
• Flash disks
• Disk configuration
• ASM disk discovery
• CellCLI disk commands
• Disk status and monitoring
• Disk failure scenarios

• Introduction to Smart Scan
• How Smart Scan works
• Traditional Oracle I/O vs Smart Scan
• Offloading SQL processing to Storage Cells
• Predicate filtering
• Column projection
• Storage Index interaction
• Smart Scan and Full Table Scans
• Smart Scan eligibility
• Situations where Smart Scan does not occur
• Monitoring Smart Scan
• Execution plan analysis
• Performance troubleshooting

• Introduction to Storage Indexes
• Storage Index architecture
• How Storage Indexes reduce I/O
• Storage region concepts
• Predicate filtering
• Storage Index and Smart Scan
• Storage Index limitations
• Monitoring Storage Index usage
• Performance examples

• Introduction to HCC
• Row-based vs Column-based storage
• HCC architecture
• Compression units
• Query Low / Query High
• Archive Low / Archive High
• HCC benefits
• HCC use cases
• HCC and Smart Scan
• HCC and storage savings
• Performance considerations
• HCC limitations
• Best practices

• Introduction to IORM
• Why IORM is required
• Exadata I/O Resource Manager architecture
• Database-level I/O prioritization
• Consumer groups
• I/O resource plans
• Inter-database resource management
• Intra-database resource management
• I/O allocation and prioritization
• IORM configuration
• Monitoring IORM
• IORM troubleshooting and best practices

• Introduction to Exadata Flash Log
• Flash Log architecture
• Redo I/O processing
• Flash Log vs traditional redo processing
• Flash Log configuration
• Performance benefits
• Monitoring Flash Log
• Flash Log troubleshooting
• Best practices

• Smart Flash Cache architecture
• Flash Cache vs Disk
• Database Smart Flash Cache
• Frequently accessed data
• Flash Cache population
• Flash Cache eviction
• Write-back Flash Cache
• Flash Cache and Smart Scan
• Flash Cache configuration
• Monitoring Flash Cache
• Performance troubleshooting

• Database node configuration
• Operating system prerequisites
• Network configuration
• DNS and SCAN configuration
• SSH configuration
• Grid Infrastructure prerequisites
• Grid Infrastructure installation
• Cluster configuration
• ASM configuration
• Voting Disk and OCR
• ASM disk groups
• RAC database creation
• Cluster verification
• CRS resource management
• Common Grid Infrastructure installation issues
• Post-installation validation