Skip to Main Content
Hitchhiker's Guide for Upgrading to Oracle Database 19c & 23c

About This Workshop

Youtube Video

About This Workshop
Learn how to upgrade and migrate your database to Oracle Database 19c. In this workshop, you learn how to use AutoUpgrade to make upgrade and non-CDB to PDB migrations a lot easier. Further, you use our Performance Stability Perscription to learn how to avoid the biggest fear of a DBA: bad execution plans after upgrade. Using tools like SQL Performance Analyzer and SQL Plan Management you can ensure performance stability after any change - including upgrades and migrations.

Workshop Info

8 hours
  • Upgrade Oracle Database using AutoUpgrade
  • Convert to multitenant architecture
  • Ensure performance stability
  • Capture workload information
  • Detect regressing statements using SQL Performance Analyzer
  • Fix bad plans using SQL Tuning Advisor
  • Avoid plan regressions with SQL Plan Management
  • Migrate Oracle Database using Full Transportable Export/Import
  • Perform unplug-plug upgrade
  • Familiarity with Database is required
  • Some understanding of database terms is helpful

Other Workshops you might like