Deploying, Patching and Upgrading
- Installation and deployment, Read-Only Oracle Home
- Patching strategy: Release Updates and revisions, OPatch and datapatch
- Upgrading to 26ai with AutoUpgrade, direct upgrades from 19c and 21c
- The transition from 23ai to 26ai without an upgrade: a plain Release Update to 23.26.x
- Pre-checks and fallback strategies
Multitenant in Depth
- CDB and PDB management in detail
- Cloning, unplugging, plugging in and relocating PDBs
- Security and data separation in the multitenant environment
- Resource control with Resource Manager at CDB and PDB level
- Application containers and Data Guard per PDB
Backup Strategy and RMAN
- Fundamentals and configuration of backup and recovery
- Working with Recovery Manager, designing backup strategies
- Speeding up RMAN backups
- Building and maintaining the recovery catalog, stored scripts, virtual private catalogs
Recovery and Flashback
- Diagnosing failures with the Data Recovery Advisor
- Complete recovery, point-in-time recovery, block media recovery
- Flashback technologies up to Flashback Database
- PDB snapshots and database duplication
Performance Diagnostics
- Narrowing down the problem: time model, statistics and wait events
- AWR, metrics, alerts and baselines
- ADDM, Active Session History and Real-Time ADDM
- Reading log and trace files correctly
SQL and Optimizer Tuning
- Processing SQL statements and how the optimizer works
- Understanding execution plans, SQL Trace and TKPROF
- Managing optimizer statistics, automatic SQL tuning
- SQL Plan Management, SQL Tuning Advisor and SQL Access Advisor
- Real Application Testing: SQL Performance Analyzer and Database Replay
Memory and In-Memory
- Memory structures: Shared Pool, Buffer Cache, PGA and Large Pool
- Automatic Shared Memory Management
- Setting up and using the In-Memory Column Store
- True Cache to offload the primary database
What’s New in the AI Database for Operations
- AI Vector Search: vector storage, vector indexes, memory sizing and impact on backups
- JSON Relational Duality Views and SQL Property Graphs in live operation
- Rolling out SQL Firewall into production
- Data Privacy Protection at row, column and cell level
- Quantum-resistant encryption and integration with Apache Iceberg
